Have an account?
Skip to Content
Build your own quiz
Suggestions for you
25 questions
Show Answers
See Preview
- 1. Multiple ChoiceCells that run horizontally on a spreadsheetRowColumnWorkbookRange
- 2. Multiple ChoiceAll functions and formulas begin with which symbol?#/:=
- 3. Multiple Choice
The intersection of a column and a row is called a ______.gridlinecellvalueformula - 4. Multiple ChoiceThe cell that is currently selectedCell referenceCell rangeLabelActive cell
- 5. Multiple ChoiceA single page in Excel is called a:worksheetworkbookspreadsheet
- 6. Multiple ChoiceWhich of the following is a FORMULA that will add cells c9 and c10?=c9+c10c9+c10sum(c9:c10)=sum(c9:c10)
- 7. Multiple ChoiceFormat cells as ______________ when working with amounts of money.currencypercentnumberscientific
- 8. Multiple ChoiceA formula that automatically adds up a column of numbers is called __________.cellauto sumgraphvalue
- 9. Multiple ChoiceA mathematical operation is called a _____.formularangelabelgraph
- 10. Multiple ChoiceA graph is a visual representation of data within a spreadsheet.TrueFalse
- 11. Multiple Choice
What key is used to select multiple ranges of cells?
Shift
CTRL
ALT
Shift+ALT
- 12. Multiple Choice
What function offers you the possibility to view different results depending on the entered condition?
=if()
=sumif()
=sum()
=TRUEFALSE()
- 13. Multiple Choice
What will be the result according to this formula: =vlookup(B1,A4:B8,2,TRUE) ?
A
B
C
D
- 14. Multiple Choice
What will be the result from this vlookup() function?
1%
2%
3%
None of the Above
5%
- 15. Multiple Choice
Which of the following cursor allows you to select a range of cells
- 16. Multiple Choice
What formula would I write in the blue box to count how many students prefer the beach to the pool?
=COUNTIF(A2:A15,Beach)
=COUNTIF(A2:A15,"Pool")
=COUNTIF(A2:A15,Pool)
=COUNTIF(A2:A15,"Beach")
- 17. Multiple Choice
How do you get something like this in your spreadsheet?
Select the cells containing the data then click the "Insert" menu then choose "Chart"
Select the cells containing the data then click the "Edit" menu then choose "Insert Chart"
Select the cells containing the data then click the "Insert" menu then choose "Pie"
Click the "Help" button, choose "Report a problem" and then type "My teacher didn't teach me how to do this crazy stuff!".
- 18. Multiple ChoiceA group of cells is called a _____.graphselectingrangecell
- 19. Multiple ChoiceHorizontal and vertical lines in a spreadsheet are called ____.rowsgraphslabelsgridlines
- 20. Multiple Choice
What is the formula to work out the MIN of the highlighted cells?
=MIN(C1:Q1)
=MIN(C15:Q15)
=C15:Q15
+MIN(E15:15)
- 21. Multiple Choice
What is the formula to work out the AVERAGE of the highlighted cells?
=AVERAGE(C1:Q1)
=AVERAGE(C2:C8)
=AVERAGE(C15:Q15)
=C15:Q15
- 22. Multiple Choice
What value would you get if you put in the formula: =A1*B1
2
3
4
Error
rumus
- 23. Multiple Choice
Spreadsheet rows are easily identified by:
a. numbers.
b. letters.
c. Roman numerals.
d. colors.
reguler
- 24. Multiple Choice
If you wanted to add the values in four consecutive cells together which function would you use?
SUM
MIN
MAX
AVERAGE
- 25. Multiple Choice
What is the cell reference of the cell with value Sprite Lite inside?
8A
C5
A8
B8
- Answer choicesTagsAnswer choicesTags