Excel Lesson 5

Quiz by Lisa DeCastillia

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
• Q2
Where can you find the Insert Function button in Microsoft Excel?
Formula bar
Status bar
45s
• Q3
What is a prewritten formula that is built into Microsoft Excel called?
Formula
Function
Statement
Procedure
45s
• 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
• Q5
Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
Autosum
Calculate
Total
45s
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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

Teachers give this quiz to your class