Computer Applications
Excel Chapter 2 Study Guide
1. What is a function? (EX 66)
2. What are the keys that you press to start a new line within the same cell? (EX 71)
3. What happens when you enter a two-digit year that is less than 30? (EX 72)
4. What are all the Excel valid arithmetic operators? (EX 76)
5. What is the order of operations that Excel follows? (EX 77)
6. What is Point mode and what does it allow you to do? (EX 77-78)
7. What does relative cell reference mean? (EX 81)
8. On the Ribbon, what is the path to the Copy and Paste buttons? ex. (tab | group) (EX 81)
9. How do you undo an automatic correction? (EX 82)
10. What are the AutoFill options and what do they do? (EX 82)
11. If you have an invalid formula, what is the options button that lists error-checking
options? (EX 82)
12. How do you select a range using the keyboard only? (EX 82)
13. What is the option button that lists formatting options following an insertion of cells,
rows, or columns? (EX 82)
14. Does a blank cell have a numerical value? If so, what is its numerical value? (EX 83)
15. What does the average function do (be specific)? (EX 84)
16. What is the Formula AutoComplete list? (EX 84)
17. What is the path to the Sum Function? (EX 85)
18. What does the MAX function do? (EX 86)
19. Where is the Insert Function button located? (EX 86)
20. What does the MIN function do? (EX 87)
21. What are the shortcut keys for copying cell contents? (EX 90)
22. What are the shortcut keys for pasting cell contents? (EX 90)
23. What is the Range Finder? (EX 91)
24. What is a theme? (EX 93)
25. What are the shortcut keys to open the Format Cells dialog box? (EX 97)
26. What is the most popular background color? (EX 98)
27. What is the difference between a fixed dollar sign and a floating dollar sign? (EX 100)
28. What formatting styles use fixed dollar signs and which use floating? (EX 100)
29. What is the path to the Comma Style button? (EX 101)
30. What is the path to the Conditional Formatting button? (EX 104)
31. What is the default column width? (EX 107)
32. What happens if you decrease a row height to 0? (EX 111)
33. What is the path to the spelling button? (EX 112)
34. What is Page Layout view? (EX 114)
35. How would you print a range of cells in the active worksheet only? (EX 118)
36. What button will recalculate all formulas? (EX 75)
37. How many functions does Excel have? (EX 89)
38. What is conditional formatting? (EX 104)
39. What does best fit mean? (EX 107)
40. Matching:
a. ALT + ENTER (EX 71)
b. #REF! (EX 74)
c. F9 (EX 75)
d. F8 (EX 82)
e. CTRL + C (EX 90)
f. CTRL + 1 (EX 97)
g. CTRL + SHIFT + $ (EX 103)
h. F7 (EX 113)
i. CTRL + ACCENT MARK (‘) (EX 119)
j. CTRL + V (EX 90)
