Microsoft Excel Review

QuizÂ by Sheryl Avery

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Measure skills

from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can

- edit the questions
- save a copy for later
- start a class game
- view complete results in the Gradebook and Mastery Dashboards
- automatically assign follow-up activities based on studentsâ€™ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet

35 questions

Show answers

- Q1A formula that has at least two different mathematical operators is called what?simple formulafunctioncomplex formulacomplex function20sEditDelete
- Q2Multiple worksheets within one file are collectively called what?excelPDFworkbooktext20sEditDelete
- Q3A formula that has just one mathematical operation is called what?simple formulaoperatorcomplex formulafunction20sEditDelete
- Q4A single sheet within a workbook that contains datatableworkbookcellworksheet20sEditDelete
- Q5Cells labeled with numbers going down a worksheet are called what?columnschartstablesrows20sEditDelete
- Q6Cells labeled with letters that go across a worksheet are called what?tableschartscolumnsrows20sEditDelete
- Q7The location or name of the cell is called it's what? Example A2columnrowworkbookCell Address20sEditDelete
- Q8This action allows you to temporarily hide data.sparklinesortfiltercell range20sEditDelete
- Q9A reference that used a particular cell over and over again as opposed to changing the cells relative to the position of the formula is what type of reference?Absolute referencerelative referencesimple referencecell reference20sEditDelete
- Q10Organizing data is called what?functionsfilteringsortingsparklines20sEditDelete
- Q11A group of cells represented by a colon : is called what? Ex: A5:A8functionabsolute referencecell rangesorting20sEditDelete
- Q12Changing the formula based on a cell's relative position within the worksheet when copying a formula across cells is what type of reference?absolute referencesparklinesrelative referencecell ranges20sEditDelete
- Q13Miniature charts inserted within just one cell are called what?Sparklinessortingscell rangesfunctions20sEditDelete
- Q14A predefined formula used to calculate data where you don't need to use any mathematical operator signs.cell rangessimple formulaFunctioncomplex formula20sEditDelete
- Q15Cells can only contain numbersFalseTrue20sEditDelete
- Q16To select a group of cells, my cursor should look like a thin, back plus sign.FalseTrue20sEditDelete
- Q17If #### appear in your cell after inserting a formula, your formula is incorrect.TrueFalse20sEditDelete
- Q18Grouping worksheets allows a change on one sheet to appear on the other sheet.FalseTrue20sEditDelete
- Q19Autosum only adds numbers togetherFalseTrue20sEditDelete
- Q20I can only sort data alphabetically or numerically.TrueFalse20sEditDelete