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.

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
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.
What driver had 6.52% ofthe total in May
Who drove the most milesin the April?

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?
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!
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!
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

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

• At ClassicWritersBay.com, most of our writers are degree-holding native speakers of English who are familiar with various writing styles. Our writers are proficient in many fields, including Economics, Business, Accounting, Finance, Medicine, Chemistry, Literature, Mathematics, Statistics, and many others.
• Making our customers happy is an important part of our service. So do not be surprised if you get your paper well before the deadline!
• We pay a lot of attention to ensuring that you get excellent customer service. You can contact our Customer Support Representatives 24/7. When you order from us, you can even track the progress of your paper as it is being written!