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

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 manager45sEditDelete
- 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 names45sEditDelete
- Q3John's workbooks includes 3 worksheets. Which option should he choose to print them?Print selectionPrint entire workbookFit to one pagePrint active sheet45sEditDelete
- Q4What area contains the command used to customize the print options in Microsoft Excel?Home ribbonQuick access toolbarFile tabPage layout ribbon45sEditDelete
- Q5Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?Smart sheetTemplateFormBoilerplate45sEditDelete
- Q6Which group on the Formulas Ribbon enables a user to specify when a formula is computed?Function libraryDefine namesCalculationFormula auditing45sEditDelete
- Q7Steve would like to print only the worksheet he is currently working on. What print option should he choose?Quick printPrint areaEntire workbookActive sheets45sEditDelete
- Q8When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?Absolute referenceVariable referenceCertain referenceRelative reference45sEditDelete
- Q9Sara is calculating her GPA. If she uses "(A1+A2+A3+A4)/4", this is an example of which type of entry?ValuesFormulasLabelsFunctions45sEditDelete
- 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 reference45sEditDelete
- Q11Mike created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):External referenceNames managerScopeNamed range45sEditDelete
- 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 location45sEditDelete
- 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?MixedAbsoluteUnconditionalRelative45sEditDelete
- 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 Handle45sEditDelete
- Q15Ralph would like to print only the cell range A1:F20. What page setup option should he change?Print titlesPrint areaOrientationPage break45sEditDelete
- Q16Alan created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n):Named rangeNames managerExternal referenceScope45sEditDelete