Have an account?
Skip to Content
Build your own quiz
Suggestions for you
30 questions
Show Answers
See Preview
- 1. Multiple Choice
What do you call the blank boxes on a spreadsheet?cellsinfosquaresspots - 2. Multiple ChoiceWhat would be a correct formula for sum in excel?=SUM(B3:B9)=SUMB3+B9SUM(B3:B9)=ADD(B3:B9)
- 3. Multiple Choice_____ are vertical.RowsColumns
- 4. Multiple Choice________ are horizontalRowsColumns
- 5. Multiple ChoiceA combination of numbers and symbols used to express a calculation. Always begins with an = sign.Cell addressWorksheetFormula
- 6. Multiple ChoiceMicrosoft Excel is what type of software?Word ProcessingSpreadsheetPresentationDrawing
- 7. Multiple ChoiceWhich symbol must you use to begin a formula?+=/*
- 8. Multiple ChoiceHow do you make a cell the active cell?Click the ACTIVE buttonClick INSERT CELLClick on the cellCells are always active
- 9. Multiple ChoiceWhat is the name of this cell?B105BB5A5
- 10. Multiple ChoiceTrue or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?TrueFalse
- 11. Multiple ChoiceWhat is the Formula sign for multiply?*-/+
- 12. Multiple ChoiceBy default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.TrueFalse
- 13. Multiple ChoiceAlex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?=(A1+A2+A3)/4A1+A2+A3/4=A1+A2+A3^4(A1+A2) + A3/4
- 14. Multiple ChoiceGerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?=(C3+C5+C9)/3=SUM(C2:C10)=AVERAGE(C2:C10)=(C3+C5+C9)
- 15. Multiple ChoiceYou want to enter a series of dates down a column. What would be the best tool for the job?Cut and PasteAutoFillSpelling CheckerFind and Replace
- 16. Multiple ChoiceTrue or False: Microsoft Excel can use Headers & Footers, just like Microsoft Word.TrueFalse
- 17. Multiple ChoiceYou have decided to center the text within a cell. What have you done?Changed alignmentWrapped textMerged cellsAutofit content
- 18. Multiple ChoiceWhich of these number formats would you want to apply to a cell showing the total sales for the month?PercentageCurrencyDate
- 19. Multiple ChoiceTrue or False: You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.TrueFalse
- 20. Multiple ChoiceYou want to enter a series of dates down a column. What would be the best tool for the job?Find and ReplaceCut and PasteSpelling CheckerAutoFill
- 21. Multiple ChoiceWhat term refers to mathematical equations used in Excel to perform calculations?CellFormatFormulasSummations
- 22. Multiple ChoiceIn Excel, all formulas must begin with what symbol?!#$=
- 23. Multiple ChoiceWhat symbol is used to designate an absolute cell reference?#!$@
- 24. Multiple Choice
To sort names in a worksheet, we can use this button.
- 25. Multiple Choice
To display the Letter Grade Equivalent, we can use the ___ function.
if
count
average
sum
- 26. Multiple Choice
What function was used to find the highest grade?
average
min
sum
max
- 27. Multiple Choice
The cell in the worksheet in which you can type data.
Active Cell
Formula
Landscape
Range
- 28. Multiple Choice
A line around the edges of a cell.
Cell Reference
Fill Handle
Cut
Border
- 29. Multiple Choice
Formatting option that changes the way numbers/data look in a cell.
Copy
Merge
Formula
Number Format
- 30. Multiple Choice
The intersection of a column and a row in a table or worksheet.
Workbook
Column
Sheet Tab
Cell
- Answer choicesTagsAnswer choicesTags