Before you start the final exam, make sure you download the Excel file below. Many questions will be based on this file. In order to successfully complete the course and receive a certificate, you must achieve a 70% or higher on the exam. You may take the exam as many times as you need.
Bummer, you didn’t pass the final exam. That’s okay, try taking it again! You can do it!
Congrats on passing the final exam! You can download your certificate which is found on the My Courses page and also on this screen.
1
2
3
4
5
6
7
8
9
Current
Review
Answered
Correct
Incorrect
Question 1 of 9
1. Question
Match the actions to the correct keyboard shortcut:
Sort elements
Undo
Print
Cut
Select entire row
Ctrl + Z
Ctrl + P
Ctrl + X
Shift + Spacebar
Question 2 of 9
2. Question
If I wanted to lock down the range A1 through B3 in a formula, what would that reference look like?
Question 3 of 9
3. Question
In a VLOOKUP formula, what is the purpose of putting “FALSE” at the end of the formula?
Question 4 of 9
4. Question
Use the Final Exam Workbook file for this question. In column C, I want to include the customer’s first name. What would the VLOOKUP formula look like?
Question 5 of 9
5. Question
Use the Final Exam Workbook file for this question. In column F, I want to extract just the month number from the sale date in column E. What would the formula in cell F5 look like?
Question 6 of 9
6. Question
Use the Final Exam Workbook file for this question. If I wanted to extract out just the area code from the phone numbers in column O, what formula would I use?
Question 7 of 9
7. Question
Why do you need to click “Refresh” on the Analyze tab anytime you update your PivotTable’s source data?
Question 8 of 9
8. Question
Match the formula with the correct definition:
Sort elements
Sums all cells within a defined range
Counts all cells in a range that contains a value
Performs a vertical lookup by searching for a value in the first column of a table and returning the value in a specified column
Performs a logical test and then returns one value for a TRUE result and another for a FALSE result
SUM
COUNTA
VLOOKUP
IF
Question 9 of 9
9. Question
Use the Final Exam Workbook file for this question. What is the total of revenue in column H?
