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

- Q1Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?Formula auditingCalculationDefined namesFunction library45sEditDelete
- Q2Where can you find the Insert Function button in Microsoft Excel?Shortcut menuQuick access toolbarFormula barStatus bar45sEditDelete
- Q3What is a prewritten formula that is built into Microsoft Excel called?FormulaFunctionStatementProcedure45sEditDelete
- Q4When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?Absolute referenceCertain referenceMixed referenceRelative reference45sEditDelete
- Q5Which command on the Home Tab displays the total of the selected cells directly after the selected cells?AddAutosumCalculateTotal45sEditDelete
- Q6Which group on the Formulas Ribbon enables a user to specify when a formula is computed?CalculationFormula AuditingDefined NamesFunction Library45sEditDelete
- 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 Names45sEditDelete
- 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 Reference45sEditDelete
- Q9Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?CurrentDateTodayDateWeekday45sEditDelete
- 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?MixedUnconditionalRelativeAbsolute45sEditDelete
- Q11Which of the following are valid Microsoft Excel functions?MAX, MIN, and WEEKWEEKDAY, MAX, and CLOSEAVERAGE, MAX, and MINAVERAGE, MAX, and NUM45sEditDelete
- 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 Names45sEditDelete
- Q13Madison is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?FunctionFormulaValuesLabels45sEditDelete
- Q14Chelsea has created a spreadsheet containing student grades. Which function would she use to return the current date in cell F1?IfCountNowToday45sEditDelete
- 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?FormulasLabelsFunctionsValues45sEditDelete
- Q16Which of the following is made up of two values and a relational operator, and is true or false for each cell in the range?RestrictionLogicConditionState45sEditDelete