Have an account?
Skip to Content
Build your own quiz
20 questions
Show Answers
See Preview
- 1. Multiple ChoiceWhat would be a correct formula for SUM in excel?=SUM(B3:B9)=SUMB3+B9SUM(B3:B9)=ADD(B3:B9)
- 2. Multiple ChoiceWhich button can you click to add up a series of numbers?The autosum buttonThe Formula buttonThe quicktotal buttonThe total button
- 3. Multiple ChoiceWhich formula gets the biggest value of a range of cells?MAXMINLARGESUM
- 4. Multiple ChoiceWhich formula gets the smallest value of a range of cells?MAXMINSMALLSUM
- 5. Multiple ChoiceWhich symbol must all formula begin with?=+(@
- 6. Multiple Choice
What text formula joins the text from two or more cells?
concatenate
proper
left
e=mc2
- 7. Multiple Choice
Which formula will calculate the average based on a condition? (return the average of sales if over $20)
average
countif
averageif
sumif
- 8. Multiple Choice
Which formula would you use to calculate how many sales are over $20 from a series.
sum
sumif
count
countif
- 9. Multiple Choice
Which formula will automatically capitalize the first letter of a word?
abra-ka-dabra
proper
capitalize
upper-case
- 10. Multiple Choice
Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.
format cell
conditional formatting
fill color
magic cell
- 11. Multiple Choice
Which tab contains the tool "Freeze Panes"?
Home
Page Layout
View
Review
- 12. Multiple ChoiceA ___________ conveys a visual representation of data.chartpicturetext boxstyle
- 13. Multiple Choice_____ are vertical.RowsColumns
- 14. Multiple Choice________ are horizontalRowsColumns
- 15. Multiple ChoiceA(n) _________ is a prewritten formula that is built into EXCEL.functionproblemequationequal sign
- 16. Multiple ChoiceA combination of numbers and symbols used to express a calculation. Always begins with an = sign.Cell addressWorksheetFormula
- 17. Multiple ChoiceExcel allows you toread storieswork with datainvent ideas
- 18. Multiple ChoiceA command line above the worksheet where text, numbers, and formulas are entered into a worksheet.InsertFormula barTables
- 19. Multiple ChoiceHow do you select an entire column?Select Edit > Select > Column from the menuClick the column heading letterHold down the shift key as you click anywhere in the column.Hold down the Ctrl key as you click anywhere in the column
- 20. Multiple ChoiceWhat allow quickly apply the content for one cell to another cell?Active cellAutocellAuto sumAuto Fill
- Answer choicesTagsAnswer choicesTags