# Excel Lesson 5

## 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
- 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

- Q1Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?Formula auditingCalculationDefined namesFunction library45s
- Q2Where can you find the Insert Function button in Microsoft Excel?Shortcut menuQuick access toolbarFormula barStatus bar45s
- Q3What is a prewritten formula that is built into Microsoft Excel called?FormulaFunctionStatementProcedure45s
- Q4When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?Absolute referenceCertain referenceMixed referenceRelative reference45s
- Q5Which command on the Home Tab displays the total of the selected cells directly after the selected cells?AddAutosumCalculateTotal45s
- Q6Which group on the Formulas Ribbon enables a user to specify when a formula is computed?CalculationFormula AuditingDefined NamesFunction Library45s
- Q7Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?Formula AuditingCalculationFunction LibraryDefined Names45s
- Q8What 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 ReferenceSheet NameCalling the SheetWorksheet Reference45s
- Q9Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?CurrentDateTodayDateWeekday45s
- Q10What 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?MixedUnconditionalRelativeAbsolute45s
- Q11Which of the following are valid Microsoft Excel functions?MAX, MIN, and WEEKWEEKDAY, MAX, and CLOSEAVERAGE, MAX, and MINAVERAGE, MAX, and NUM45s
- Q12Which command group on the Formulas Ribbon allows a user to choose from various categories of functions to use in a worksheet?Formula AuditingCalculationFunction LibraryDefined Names45s
- Q13Madison is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?FunctionFormulaValuesLabels45s
- Q14Chelsea has created a spreadsheet containing student grades. Which function would she use to return the current date in cell F1?IfCountNowToday45s
- Q15Jordan is calculating her average sales for the past four months. If she uses "=AVERAGE(A1:A7)", this is an example of which type of entry?FormulasLabelsFunctionsValues45s