Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Excel Review
| Question | Answer |
|---|---|
| What does a function or formula always begin with? | = |
| What symbol represents that the column is too small to fit its contents? | # |
| What symbol represents an absolute function? | $ |
| How would you describe your cursor when you select something? | White plus sign |
| How would you describe your cursor when you are using the fill tool? | Black plus sign |
| How would you describe your cursor when you are moving a cell? | Four sided arrow |
| What are three ways you can copy something? | Copy/Paste, Fill Tool, Format Painter |
| How do you display or print formulas? | Show Formulas Button on the FORMULAS tab |
| How do you change the page orientation and fit to option in excel? | Page Layout or Page Setup |
| Explain how to name a range. | Click on the formulas tab, then click on define name. |
| What formula calculates the number of cells that have numbers in a range? | Count |
| What formula calculates the number of cells that have both values and text in a range? | CountA |
| How do you use wrap text? | Home Tab, Wrap Text |
| Explain wrap text. | Moves text to a second line to fit in the column width |
| How do you change the column width/row height? | Click between column labels: double click, or drag boundary. OR on the HOME tab, click on the format button, and click column width/row height or auto fit |
| How do you insert a new row or column? | Right click the row/column heading and click insert. OR on the HOME tab, click on the insert button in the cells group |
| What is the purpose of freezing a row or column? | To be able to see the headings when working in a workbook |
| How do you change the color of a worksheet tab? | Right-click the tab and Select Tab Color |
| How do you freeze columns or rows? | Click on the VIEW tab, in the windows group, click freeze panes |
| Where are check boxes you can select to view or print guidelines? | On the PAGE LAYOUT tab, in the Sheet Options group |
| How do you unhide a hidden row or column? | Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide |
| A worksheet is a little too wide to print on one page. Which feature can you use to force all data to print on one page? | Scale to Fit |
Created by:
enix
Popular Business sets