  Excel Lesson 5

Quiz by Lisa DeCastillia

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

• 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
• Q1
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
Formula auditing
Calculation
Defined names
Function library
45s
Edit
Delete
• Q2
Where can you find the Insert Function button in Microsoft Excel?
Formula bar
Status bar
45s
Edit
Delete
• Q3
What is a prewritten formula that is built into Microsoft Excel called?
Formula
Function
Statement
Procedure
45s
Edit
Delete
• Q4
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Absolute reference
Certain reference
Mixed reference
Relative reference
45s
Edit
Delete
• Q5
Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
Autosum
Calculate
Total
45s
Edit
Delete
• Q6
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
Calculation
Formula Auditing
Defined Names
Function Library
45s
Edit
Delete
• Q7
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Formula Auditing
Calculation
Function Library
Defined Names
45s
Edit
Delete
• Q8
What 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 Reference
Sheet Name
Calling the Sheet
Worksheet Reference
45s
Edit
Delete
• Q9
Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?
CurrentDate
Today
Date
Weekday
45s
Edit
Delete
• Q10
What 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?
Mixed
Unconditional
Relative
Absolute
45s
Edit
Delete
• Q11
Which of the following are valid Microsoft Excel functions?
MAX, MIN, and WEEK
WEEKDAY, MAX, and CLOSE
AVERAGE, MAX, and MIN
AVERAGE, MAX, and NUM
45s
Edit
Delete
• Q12
Which command group on the Formulas Ribbon allows a user to choose from various categories of functions to use in a worksheet?
Formula Auditing
Calculation
Function Library
Defined Names
45s
Edit
Delete
• Q13
Madison is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
Function
Formula
Values
Labels
45s
Edit
Delete
• Q14
Chelsea has created a spreadsheet containing student grades. Which function would she use to return the current date in cell F1?
If
Count
Now
Today
45s
Edit
Delete
• Q15
Jordan 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?
Formulas
Labels
Functions
Values
45s
Edit
Delete
• Q16
Which of the following is made up of two values and a relational operator, and is true or false for each cell in the range?
Restriction
Logic
Condition
State
45s
Edit
Delete

Teachers give this quiz to your class