Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/16
Score 0
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
45
Formula auditing
Calculation
Defined names
Function library
Q 2/16
Score 0
Where can you find the Insert Function button in Microsoft Excel?
45
Shortcut menu
Quick access toolbar
Formula bar
Status bar
16 questions
Q.
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
1
45 sec
Q.
Where can you find the Insert Function button in Microsoft Excel?
2
45 sec
Q.
What is a prewritten formula that is built into Microsoft Excel called?
3
45 sec
Q.
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy
location?
4
45 sec
Q.
Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
5
45 sec
Q.
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
6
45 sec
Q.
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
7
45 sec
Q.
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?
8
45 sec
Q.
Which function do you use to insert today's date in a worksheet so that it automatically updates each time the
worksheet is opened?
9
45 sec
Q.
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?
10
45 sec
Q.
Which of the following are valid Microsoft Excel functions?
11
45 sec
Q.
Which command group on the Formulas Ribbon allows a user to choose from various categories of functions to use in a worksheet?
12
45 sec
Q.
Madison is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
13
45 sec
Q.
Chelsea has created a spreadsheet containing student grades. Which function would she use to return the current date in cell F1?
14
45 sec
Q.
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?
15
45 sec
Q.
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?