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
10
Current
Review
Answered
Correct
Incorrect
Question 1 of 10
1. Question
Use the Final Exam Workbook file for this question. In column H, I want to highlight the top 20% of sales green. What is the process to do this?
Select Conditional Formatting on the Home tab
Select the sales in column H
Select Top/Bottom Rules
Select Top 10%, change the value from 10% to 20%, and select a green color formatting
View Answers:
Correct
Incorrect
Question 2 of 10
2. Question
Use the Final Exam Workbook file for this question. How many purchases did Glen Milum make? Hint: Use the COUNTIFS formula.
Correct
Incorrect
Question 3 of 10
3. Question
Use the Final Exam Workbook file for this question. Create a PivotTable using the data in columns B through I. The PivotTable should have the Month in the columns, with the customer ID and Product in the rows. In month 2, how much did customer 3 spend on wands?
Correct
Incorrect
Question 4 of 10
4. Question
I have a data table that lists dates in one column and sales in another. To easier/better summarize my data using SUMIFS and PivotTables, what should I do with my dates?
Correct
Incorrect
Question 5 of 10
5. Question
What characteristic is required in your source data to create a PivotTable?
Correct
Incorrect
Question 6 of 10
6. Question
I downloaded a data set from an accounting program. All of the account numbers have between 3 and 5 spaces before the actual account number. For example: ” 348495″. What’s the most efficient way to get rid of these leading spaces so I can perform a VLOOKUP?
Correct
Incorrect
Question 7 of 10
7. Question
What is the process for adding a Slicer to our PivotTable?
Select the PivotTable
Click OK
Select the Analyze tab
Check which fields you want to slicer your data on
Select Insert Slicer
View Answers:
Correct
Incorrect
Question 8 of 10
8. Question
How do we access the commands on the Quick Access Toolbar using just our keyboard?
Correct
Incorrect
Question 9 of 10
9. Question
On the ribbon, which tab houses both the Remove Duplicates and Text-to-Columns functions?
Correct
Incorrect
Question 10 of 10
10. Question
After selecting an entire column, what is the keyboard shortcut to quickly add a new column?
