Have an account?
Skip to Content
Build your own quiz
20 questions
Show Answers
See Preview
- 1. Multiple Choice
If you click on a letter at the top of an Excel spreadsheet, what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
- 2. Multiple Choice
A four-sided arrow does what in Excel?
copies the contents of one cell to others around it
moves the contents of one cell to another location
selects the cell
- 3. Multiple Choice
Every formula starts with what?
=
+
-
( )
- 4. Multiple Choice
What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?
cell bar
formula bar
status bar
name box
- 5. Multiple Choice
If you click a number at the left of an Excel spreadsheet, what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
- 6. Multiple Choice
Where are the two places to find the autosum feature?
Home ribbon
Insert ribbon
Function ribbon
Formulas ribbon
- 7. Multiple Choice
To exit an active formula, you always click out of the current cell?
True
False
- 8. Multiple Choice
If the following was entered into a cell, what would appear in that cell? sum(A1:B3)
the sum of A1 through B3
sum(A1:B3)
nothing
- 9. Multiple Choice
If you see the following, what does it mean? ######
the formula has an error
the contents are too large to display
text was entered where numbers should be
- 10. Multiple Choice
If you change the value in a cell then the associated graph will NOT change.
True
False
- 11. Multiple Choice
Select all of the following that are available under the Autosum button:
sum
minimum
average
maximum
division
- 12. Multiple Choice
What are the two (2) ways to display a spreadsheet in Microsoft Excel?
fixed
value
variable
formula
- 13. Multiple Choice
If you center or merge and center it does exactly the same thing.
True
False
- 14. Multiple Choice
What tool allows you to capture the formatting in one location and easily format other cells the same way?
copy and paste
cut and paste
format painter
alignment tool
- 15. Multiple Choice
What is the difference in the following numbers: 1/3, .33, 33%
the value
the format
the function
- 16. Multiple Choice
What happens to a spreadsheet when you use the Ctrl~ command on a PC?
calculates the values in formulas
autofits the columns and rows
displays the formulas
nothing
- 17. Multiple Choice
Which page orientation makes the sides longer than the top and bottom?
landscape
portrait
fixed
variable
- 18. Multiple Choice
Margins are the white space on the spreadsheet where nothing prints.
True
False
- 19. Multiple Choice
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
- 20. Multiple Choice
To arrange data in alphabetical or numerical order is what?
coding
sorting
graphing
grouping
- Answer choicesTagsAnswer choicesTags