Have an account?
Skip to Content
Build your own quiz
Suggestions for you
21 questions
Show Answers
See Preview
- 1. Multiple Choice
What is an arrangement of cells in columns and rows used to organize information, usually in numerical form
workbook
label
Spreadsheet
formula
- 2. Multiple Choice
What is a file that contains one or more spreadsheets?
formula
cell
workbook
function
- 3. Multiple Choice
The area where a row and column meet:
cell
blog
cube
unit
- 4. Multiple Choice
Column width is adjusted to fit ______ entry.
shortest
longest
aligned
spreadsheet
- 5. Multiple Choice
_______is used to fill a column or row with consecutive data
primary sort
freeze panes
editing
auto fill
- 6. Multiple Choice
A space near the top of the spreadsheet where the formulas or other information in the active cell can be viewed is called the:
address label
title bar
formula bar
active cell
- 7. Multiple Choice
A _____classification is used for cells that contain text or for numbers that will not be used in calculation
formula
value
label
cell data
- 8. Multiple Choice
A ______classification indicates that the data has then potential to be used in calculation
value
formula
cell data
label
- 9. Multiple Choice
A ______ instructs the software to perform a calculation.
cell data
value
formula
label
- 10. Multiple Choice
Which of the following is an example of an addition formula?
=B4+D7
F3*G7
2+3+6 = 11
B9/B6
- 11. Multiple Choice
Which of the following is the example of a subtraction formula?
A-B
=C10-B9
$14.00-$5.00=$9.00
B9/B6
- 12. Multiple Choice
Which of the following is an example of multiplication formula?
46X39
B4 X B6
B2+B3/C4
=L3*C7
- 13. Multiple Choice
The most useful function of a spreadsheet are:
formulas and graphs
fonts and borders
labels and envelops
lines and pictures
- 14. Multiple Choice
=sum(C4:C18) adds the range of cells from C4 through C18. What is the function?
average
sum
maximum
header
- 15. Multiple Choice
=Average (C4:C18) determines the average of the range of cells from C4 through C18. What is the function?
maximum
sum
average
header
- 16. Multiple Choice
=Max (C4:C18) finds the highest number in the range of cells from C4 through C18. What is the function?
maximum
average
sum
minimum
- 17. Multiple Choice
=Min(C4:C18) finds the lowest number in the range of cells from C4 through C18. What is the function?
average
minimum
maximum
sum
- 18. Multiple Choice
Your math teacher has asked you to create a chart comparing candy sales for the last 3 years. Which will best display your data?
line graph
bar chart
scattergram
pie chart
- 19. Multiple Choice
_____ allows the user to work in multiple areas of a large spreadsheet and focus the view on specific call ranges.
secondary sort
fill series
word wrapping
freeze panes
- 20. Multiple Choice
What is used to arrange data in alphabetical or chronological order?
sort
renaming
cells
editing
- 21. Multiple Choice
Which type of chart best illustrates values has part if a whole picture?
line graph
scattergram
bar chart
pie chart
- Answer choicesTagsAnswer choicesTags