one input
one input
Correct
2
Which function, when entered into cell G7, allows you to determine the sum total of annual sales for market regions 18 and greater?
=SUMIF(F2:F6,">=18",G2:G6)
=SUMIF(F2:F6,">=18",G2:G6)
Correct
3
Which Excel add-in will help you find a target result by varying multiple inputs to a formula?
Solver
Goal Seek
Incorrect
4
Which formula is NOT equivalent to all of the others?
=SUM(A3,A6)
=SUM(A3,A6)
Correct
5
What is the difference between a workbook and a worksheet?
An Excel file is a workbook. A workbook contains one or more worksheets.
An Excel file is a workbook. A workbook contains one or more worksheets.
Correct
6
What is the output of the formula =(8+2*3)/7?
2
2
Correct
7
In Excel, what do most formulas begin with?
=
=
Correct
8
To discover how many cells in a range contain values that meet a single criterion, use the _ function.
COUNTIF
COUNTIF
Correct
9
What is the term for an expression that is entered into a worksheet cell and begins with an equal sign?
formula
formula
Correct
10
Which is a valid Excel formula?
=(A5+B5)*B7
=(A5+B5)*B7
Correct
11
Which formula, when entered into cell D2 and then dragged to cell D6, calculates the average total number of minutes spent on phone calls for each representative?
=C2/B2
=B2*C2
Incorrect
12
Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?
Conditional Formatting
Conditional Formatting
Correct
13
A colleague shared an Excel file with you, and you want to display a worksheet that is hidden in it. How can you do that?
Right-click on any worksheet tab and select Unhide
Right-click on any worksheet tab and select Unhide
Correct
14
Which function returns the largest value amongst all values within the range H2:H30?
=MAX(H2:H30)
=MAX(H2:H30)
Correct
15
What ribbon command on the Home tab can you use to change a cell's fill color automatically, based on the value of the cell?
Conditional Formatting
Conditional Formatting
Correct
16
You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?
list
list
Correct
17
To insert a new column to the left of a specific column, right-click the header containing the column's letter and select _.
Insert
Insert
Correct
18
To calculate gross pay, hours are multiplied by the hourly rate. What formula would you put in cell C4 to then be able to copy that cell down to the rest of the column?
=B1*B4
=$B$1*B4
Incorrect
19
What is the intersection of a worksheet row and column?
Cell
Cell
Correct
20
Which formula contains a valid absolute reference?
=B7*$G$3
=B7*$G$3
Correct
Final Quiz
Questions:
20
Quiz Time:
60 Minutes
Total Marks:
77.00/92.00
Passing Marks:
36.80
Date
Question
Total Marks
Pass Marks
Correct Answer
Incorrect Answer
Earned Marks
Result
February 21, 2025 11:32 am
20
92.00
36.80 (40%)
17
3
77.00 (84%)
Pass
