Have an account?
Skip to Content
Build your own quiz
20 questions
Show Answers
See Preview
- 1. Multiple ChoiceA(n) Excel ___ allows data to be easily summed and charted.worksheetformattabledisplay
- 2. Multiple ChoiceA ___________ conveys a visual representation of data.chartpicturetext boxstyle
- 3. Multiple Choice_____ are vertical.RowsColumns
- 4. Multiple Choice________ are horizontalRowsColumns
- 5. Multiple ChoiceA(n) _________ is a prewritten formula that is built into EXCEL.functionproblemequationequal sign
- 6. Multiple ChoiceA combination of numbers and symbols used to express a calculation. Always begins with an = sign.Cell addressWorksheetFormula
- 7. Multiple ChoiceExcel allows you toread storieswork with datainvent ideas
- 8. Multiple ChoiceA3 is an example of a cell's addresstruefalse
- 9. Multiple ChoiceA command line above the worksheet where text, numbers, and formulas are entered into a worksheet.InsertFormula barTables
- 10. Multiple ChoiceWhat would be a correct formula for sum in excel?=SUM(B3:B9)=SUMB3+B9SUM(B3:B9)=ADD(B3:B9)
- 11. Multiple ChoiceTo create a formula, you first:Select the cell you want to place the formula intoType the equals sign (=) to tell Excel that you're about to enter a formulaEnter the formula using any input values and the appropriate mathematical operators that make up your formulaChoose the new command from the file menu
- 12. 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
- 13. Multiple ChoiceThe ______ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.AutorepairAutocheckGrammarAutocorrect
- 14. Multiple ChoiceA formula is a combination of numbers and symbols used for calculationsTRUEFALSE
- 15. Multiple ChoiceThe cell in your worksheet that has been selected. It will have bolder gridlines around it.TRUEFALSE
- 16. Multiple ChoiceWhat allow quickly apply the content for one cell to another cell?Active cellAutocellAuto sumAuto Fill
- 17. Multiple ChoiceWhat is a worksheet?A "page" within an Excel workbook that contains columns rows and cellsHomeworkSomething you get at schoolAll wrong
- 18. Multiple Choice
What do you call the blank boxes on a spreadsheet?cellsinfosquaresspots - 19. Multiple ChoiceExcel allows you toread storieswork with datainvent ideas
- 20. Multiple ChoiceWhich tab in Excel has charts and tables?reviewhomefileinsert
- Answer choicesTagsAnswer choicesTags