Excel Review
1. The direction in which the contents of a page will print is called ________________________________.
2. The intersection of a column and a row is called a _________________________.
3. Where can you fine the active cell address? _____________________________________
4. A file that consists of one or more worksheets is called a ____________________________.
5. What do you use to switch from sheet to sheet in a workbook? ______________________________
6. Besides directly in the cell, where can you enter data in the worksheet? _____________________________
7. The dark rectangle that outlines the active cell is called the ____________________________________.
8. A selection of multiple cells is called a ___________________________________.
9. Using a cell address in a formula is known as ____________________________________.
10. What sign precedes a formula? _______________________________
11. Labels are ______________________________________________________________.
12. Entries that contain numbers, formulas, and functions that can be used in calculations are ______________.
13. The AutoSum button selects a range _____________________ then to the _____________________.
14. Which key changes a relative cell to an absolute cell reference? ____________________________
15. Which key do you press to edit a cell? __________________________________________
16. The maximum number of worksheets in a workbook is ______________________.
17. What keys do you press to see the spreadsheet with formulas displayed? ___________________________
18. To preserve the relationship to the formula location, use this cell reference. _________________________
19. A reference that doesn’t change when you copy the formula. ____________________________________
20. You can’t use the clipboard to enter a function.
21. To select nonadjacent cells, press this key. __________________________________
22. What does the fill handle do? ______________________________________________________________
23. To clear the content of selected cells push the ____________________________key.
24. How do you Autofit (best fit) a column width? ________________________________________________
25. What is a pie chart used for? ______________________________________________________________
26. Which chart uses a vertical format to compare distinct object levels? ______________________________
27. Which tab appears when a chart is selected? ___________________________________
28. Which tab do you choose to create a chart? ____________________________________
29. Which tab do you choose to recolor part of a chart? ___________________________________________
30. Which tab would you choose to add a row to a worksheet. ______________________________________
31. What does a legend do? __________________________________________________________________
32. Labels are automatically positioned ___________ aligned in a cell.
33. You cannot select a chart from the layout tab.
34. What is the range finder used for? __________________________________________________________
35. Is multiply a function that can be performed using the AutoCalculate button? _______________________
36. What do the following arithmetic operators stand for?
a. * _________________________ c. + ____________________________
b. / __________________________ d. - ____________________________
37. If the error message ######### is displayed in a cell, what does it mean? __________________________
38. Solve this equation: 9*(4+2) = ________________________
39. When using the fill handle, the next three values after 255, 260, 265 would be _______, _______, _______
40. What cell style do you apply to get one line above and two lines below a row? ______________________