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
- 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 function20s
- Q2Multiple worksheets within one file are collectively called what?excelPDFworkbooktext20s
- Q3A formula that has just one mathematical operation is called what?simple formulaoperatorcomplex formulafunction20s
- Q4A single sheet within a workbook that contains datatableworkbookcellworksheet20s
- Q5Cells labeled with numbers going down a worksheet are called what?columnschartstablesrows20s
- Q6Cells labeled with letters that go across a worksheet are called what?tableschartscolumnsrows20s
- Q7The location or name of the cell is called it's what? Example A2columnrowworkbookCell Address20s
- Q8This action allows you to temporarily hide data.sparklinesortfiltercell range20s
- 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 reference20s
- Q10Organizing data is called what?functionsfilteringsortingsparklines20s
- Q11A group of cells represented by a colon : is called what? Ex: A5:A8functionabsolute referencecell rangesorting20s
- 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 ranges20s
- Q13Miniature charts inserted within just one cell are called what?Sparklinessortingscell rangesfunctions20s
- Q14A predefined formula used to calculate data where you don't need to use any mathematical operator signs.cell rangessimple formulaFunctioncomplex formula20s
- Q15Cells can only contain numbersFalseTrue20s