12/9/22, 6:42 PM Example of the Final Exam: FINAN 6040 Adv Excel for Professionals Fall 2022
https://utah.instructure.com/courses/824130/quizzes/2889746 1/5
* Some questions not yet graded
Example of the Final ExamDue Dec 9 at 11:59pm Points 0 Questions 6Available Nov 29 at 12am – Dec 9 at 11:59pm Time Limit 30 MinutesAllowed Attempts 21
Attempt HistoryAttempt Time Score
LATEST Attempt 1 less than 1 minute 0 out of 0 *
Score for this attempt: 0 out of 0 *Submitted Dec 9 at 6:42pmThis attempt took less than 1 minute.
Take the Quiz Again
0 / 0 ptsQuestion 1
This question is an example of a Multiple Answer Question:
Select all the statements below that are true about financial modeling.
Financial modeling is a skill needed by almost all companies. Correct!Correct!
Often simple mistakes can lead to major losses. Correct!Correct!
Building good financial models is easy.
Financial modeling is the task of building an abstract representation of afinancial decision making situation.
orrect Answerorrect Answer

12/9/22, 6:42 PM Example of the Final Exam: FINAN 6040 Adv Excel for Professionals Fall 2022
https://utah.instructure.com/courses/824130/quizzes/2889746 2/5
0 / 0 ptsQuestion 2UnansweredUnanswered
This question is an example of a matching question:
In the Final Exam Workbook, create a pivot table from a table calledTrucking. This is a hidden table so you will just type in the name of thetable in the pivot table dialog box. Put months across the columns (useDelivery Date and Time to get the month) and the driver’s names in therows. Calculate the percent of total miles each driver drove as a percentof the grand total.
Filter the table to show Q2 trips only. Sort the table largest to smallest bythe grand total.
Show the top 10 drivers.
Answer the following questions about this pivot table:
Who is the top Driver? ou Answeredou Answered
Ben MullinsCorrect AnswerCorrect Answer
What driver had 6.52% ofthe total in May
ou Answeredou Answered
Aurora RamseyCorrect AnswerCorrect Answer
Who drove the most milesin the April?
ou Answeredou Answered
Ramiro FrazierCorrect AnswerCorrect Answer

12/9/22, 6:42 PM Example of the Final Exam: FINAN 6040 Adv Excel for Professionals Fall 2022
https://utah.instructure.com/courses/824130/quizzes/2889746 3/5
Other Incorrect Match Options:Ramiro HahnEvelyn EstradaMakenzie LutzAlejandro SchmittBrian DanielsBarbara NixonIyana TrujilloSincere DrakeKeira AliDante ReidLana ChangHalle RangelWill RamosJane DoeBradley BartonAlfonso ShafferJensen Li
Of the top 10 who had theleast amount of miles?
ou Answeredou Answered
Leah SandersCorrect AnswerCorrect Answer
0 / 0 ptsQuestion 3UnansweredUnanswered
Example of a multiple choice technical Question.
In the example final exam workbook I have a hidden table namedExampleTable. The columns in this table are:
InvoiceNumberInvoiceDateShippedDateQuantityUnitPriceAmount

12/9/22, 6:42 PM Example of the Final Exam: FINAN 6040 Adv Excel for Professionals Fall 2022
https://utah.instructure.com/courses/824130/quizzes/2889746 4/5
The table includes invoice for 2022.
Write a Dax Formula to sum total units sold in 2022. What is the total?
1,093.29
52,062.75
1,062.51
#Spill!
2,487.00 orrect Answerorrect Answer
0 / 0 ptsQuestion 4
Example of true or false question
Look at the table below.
This table is set up correctly to build a line chart.
True
False Correct!Correct!

12/9/22, 6:42 PM Example of the Final Exam: FINAN 6040 Adv Excel for Professionals Fall 2022
https://utah.instructure.com/courses/824130/quizzes/2889746 5/5
0 / 0 ptsQuestion 5
A theory multiple choice question
What chart below is embedded in a cell in the worksheet layer of excel?
Slicer
Combo Chart
Waterfall Chart
Spark Line Correct!Correct!
Not yet graded / 0 ptsQuestion 6UnansweredUnanswered
Please upload your Final Exam Workbook here.
Quiz Score: 0 out of 0

QUALITY: 100% ORIGINAL – NO PLAGIARISM

(USA, AUS, UK & CA PhD. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS

The Best Custom Essay Writing Service

About Our Service

We are an online academic writing company that connects talented freelance writers with students in need of their services. Unlike other writing companies, our team is made up of native English speakers from countries such as the USA, UK, Canada, Australia, Ireland, and New Zealand.

Qualified Writers

Our Guarantees:

CLICK TO SUBMIT YOUR ORDER