Excel 3 & 4
Quiz by Lisa DeCastillia
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
Our brand new solo games combine with your quiz, on the same screen
Correct quiz answers unlock more play!
16 questions
Show answers
- Q1Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n):External referenceScopeNamed rangeNames manager45s
- Q2Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?Formula auditingFunction libraryCalculationDefined names45s
- Q3John's workbooks includes 3 worksheets. Which option should he choose to print them?Print selectionPrint entire workbookFit to one pagePrint active sheet45s
- Q4What area contains the command used to customize the print options in Microsoft Excel?Home ribbonQuick access toolbarFile tabPage layout ribbon45s
- Q5Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?Smart sheetTemplateFormBoilerplate45s
- Q6Which group on the Formulas Ribbon enables a user to specify when a formula is computed?Function libraryDefine namesCalculationFormula auditing45s
- Q7Steve would like to print only the worksheet he is currently working on. What print option should he choose?Quick printPrint areaEntire workbookActive sheets45s
- Q8When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?Absolute referenceVariable referenceCertain referenceRelative reference45s
- Q9Sara is calculating her GPA. If she uses "(A1+A2+A3+A4)/4", this is an example of which type of entry?ValuesFormulasLabelsFunctions45s
- Q10What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?Name referenceCalling the sheetSheet nameWorksheet reference45s
- Q11Mike created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):External referenceNames managerScopeNamed range45s
- Q12How is a cell reference in a formula and its corresponding location in a worksheet identified?Cell reference and cell location are circledCell reference and cell location are outlined in matching colorsArrows pointing from the formula to the locationLines connect from the formula to the location45s
- Q13What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?MixedAbsoluteUnconditionalRelative45s
- Q14What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?Copy method from Shortcut MenuCopy using the Quick Access ToolbarCopy from the Home RibbonCopy using the Fill Handle45s
- Q15Ralph would like to print only the cell range A1:F20. What page setup option should he change?Print titlesPrint areaOrientationPage break45s
- Q16Alan created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n):Named rangeNames managerExternal referenceScope45s