- Hello!
0 of 9 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 9 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
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.
Match the actions to the correct keyboard shortcut:
Ctrl + Z
|
|
Ctrl + P
|
|
Ctrl + X
|
|
Shift + Spacebar
|
|
If I wanted to lock down the range A1 through B3 in a formula, what would that reference look like?
In a VLOOKUP formula, what is the purpose of putting “FALSE” at the end of the formula?
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?
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?
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?
Why do you need to click “Refresh” on the Analyze tab anytime you update your PivotTable’s source data?
Match the formula with the correct definition:
SUM
|
|
COUNTA
|
|
VLOOKUP
|
|
IF
|
|
Use the Final Exam Workbook file for this question. What is the total of revenue in column H?