MICROSOFT EXCEL - Master Handout
1. What is Microsoft Excel and when would it be used?
2. a) What is the default filename in Excel?
b) What is the extension added to Excel files?
3. Label the Excel screen below. Draw lines and write the appropriate letter beside each line
from the list below.
a) Formula bar b) Menu bar c) Column headings
d) Row labels e) Filename f) Cell
g) Column h) Row i) Standard toolbar
j) Formatting toolbar k) Status bar l) Name box
m) Fill handle n) Active cell
4. In a spreadsheet,
a) Do columns run vertically or horizontally?
b) Do rows run vertically or horizontally?
5. What do you call the intersection of a row and a column?
6. Which bar on your screen tells you where your cursor is located?
7. What is the default column width size?
8. What are the next 3 columns after Z? ______, ______, ______
9. What keys move your cursor to: (same as Word Processing)
a) beginning of your file quickly?
b) end of your file quickly?
10. What function key will allow you to go to a specified cell quickly?
11. Name 5 ways to enter information into a cell. ______, ,
______, ______,______
12. What are the two types of cell contents? ______,
13. How are labels justified once they are entered into a cell?
14. What are the two types of value entries? ______,
15. How are values justified once they are entered into a cell?
16. What must you type to start off a formula?
17. How do you indicate the following operations in a formula?
a) addition
b) subtraction
c) multiplication
d) division
e) exponentiation
18. What does a relative reference mean in a spreadsheet?
19. Spreadsheets are neat because you can use formulas and then just fill in the formula for the rest of the cells.
a) To fill a formula down a column, what do you select from the Edit menu?
b) To fill a formula across a row, what do you select from the Edit menu?
20. How do you sort the alphabet in descending order?
21. Explain when a second sort is important?
22. Name 5 built-in functions you can use in formulas. ______,
______, ______, ______
23. When you select the following from the toolbar, how many decimal places are automatically put in?
a) %
b) $
24. When you select Percent or Currency from the Format/Cells/Number menu, how many decimal places can you have?
25. What option do you select from the Format/Cells/Number menu to change a number to a certain number of decimal places, but it is not currency or percent?
26. Where do inserted rows go relative to the cell you are on?
27. Where do inserted columns go relative to the cell you are on?
28. What appears in a cell with values in it when the column widths are set too small?
29. Name six ways to improve the looks of a spreadsheet.
1) 4)
2) 5)
3) 6)
30. What key do you press to edit a cell?
31. Explain when you would use the following buttons.
a)
b)
c)
d)
32. a) How do you hide a column?
b) How do you show the column again?
33. Choose from Clear, Cut, Copy, or Delete for the following.
a) When you select ______or ______from the Edit menu, a copy is sent to the clipboard.
b) When you select ______or ______from the Edit menu, a copy is not sent to the clipboard.
c) What do you select from the Edit menu to delete a block of cells? ______
34. When you highlight cells and select Clear from the Edit menu, what is the difference between the
following options?
All-
Contents-
Formatting-
35. Give a specific example on when the following error messages might appear when entering a value.
a) ####
b) #NAME?
c) #REF!
d) #VALUE!
Complete ______(Teacher Use Only)
Adapted from W. Warner (L.C.C.V.I.) Page 3 of 3