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