1. The box formed at the intersection of a row and a column is called a ___________. (4 points)
row
cell
column
line
2. A ________ contains information arranged horizontally. (4 points)
row
cell
column
line
3. A ________ contains information arranged vertically. (4 points)
row
cell
column
line
4. Which symbols are used to calculate formulas?
(4 points)
=
+
*
all of the above
5. In the following formula, what does the : represent in the equation =sum(B1:B5)? (4 points)
first number
all numbers between
last number
several numbers
6. What symbol do you always use to start a formula?
(4 points)
=
+
-
all of the above
7. What symbol activates the AutoSum Function?
(4 points)
=
+
-
8. How do you move through out the spreadsheet?
(4 points)
click the mouse
press the enter key
press the tab key
all of the above
9. This has columns, rows, text, and numbers. Values are calculated from raw data here. What is it?
(4 points)
calculator
formula
spreadsheet
document
10. How do you start Microsoft Excel? (4 points)
click on the Menu, Tools, Excel
click on Start, Program, Microsoft Office, Excel
click Explorer, Programs, Office
none of the above
11. If you click on Window, Freeze Pane, what have you accomplished? (4 points)
Hide the row/column
Open the row/column
Freeze the row/column
None the above
12. What does the AutoSum Function do? (4 points)
automatically multiplies the numbers selected
automatically adds a large column of numbers
automatically takes the difference of a large column of numbers
none of the above
13. How do you copy and paste data? (4 points)
Edit, Copy then Edit, Paste
Right click on the data, copy, move to new location, right click, then Paste
Ctrl C and Ctrl V
All of the above
14. To cut and paste data in Excel in another location, what are you doing? (4 points)
moving data
duplicating data
editing data
none of the above
15. When typing formulas in Excel to reference the location of a cell, a cell reference may be written as: (4 points)
5C
C5
C:5
none of the above
16. Clicking on the fill handle in the cell’s lower right hand corner and dragging down to the cell you want is: (4 points)
Autodrag.
Autofil.
Autolocate.
All of the above
17. Where are additional worksheet tabs located in a worksheet? (4 points)
bottom
left
right
top
18. How do you change the color of the worksheet tabs? (4 points)
Left click and choose color
Right click and choose color
Triple click and choose color
All of the above
19. Where would you go to change the appearance of the font? (4 points)
Format, Font
Format, Cells
Format, Row
Format, Column
20. The primary benefit of using Microsoft Excel is: (4 points)
calculating numbers.
typing text.
coloring cells.
saving files.
21. How do you add another worksheet within a worksheet? (4 points)
Insert, worksheet
Right click, on the Sheet tab, and choose Insert
Both a and b
None of the above
22. How do you delete a worksheet? (4 points)
Edit, Delete Sheet
Right click, on the Sheet tab, and choose Delete
Both a and b
None of the above
23. How do you change the date in Excel? (4 points)
Format, Cell, Number Tab, Date
Data, Cell, Date
Tools, Options, Date
Edit, Date
24. How do you change a number to currency? (4 points)
Format, Cell, Number Tab, Currency
Data, Cell, Number
Tools, Options, Currency
Edit, Number
25. How do you print your spreadsheet with the cell lines? (4 points)
Click print only
File, Page Set up, click on Sheet tab, Gridlines
Insert, Worksheet, Gridlines
None of the above