Excel help

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 Exam Due Dec 9 at 11:59pm Points 0 Questions 6 Available Nov 29 at 12am - Dec 9 at 11:59pm Time Limit 30 Minutes Allowed Attempts 21

Attempt History Attempt 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:42pm This 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 a financial 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 called Trucking. This is a hidden table so you will just type in the name of the table in the pivot table dialog box. Put months across the columns (use Delivery Date and Time to get the month) and the driver's names in the rows. Calculate the percent of total miles each driver drove as a percent of the grand total.

Filter the table to show Q2 trips only. Sort the table largest to smallest by the 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% of the total in May

ou Answeredou Answered

Aurora RamseyCorrect AnswerCorrect Answer

Who drove the most miles in 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 Hahn Evelyn Estrada Makenzie Lutz Alejandro Schmitt Brian Daniels Barbara Nixon Iyana Trujillo Sincere Drake Keira Ali Dante Reid Lana Chang Halle Rangel Will Ramos Jane Doe Bradley Barton Alfonso Shaffer Jensen Li

Of the top 10 who had the least 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 named ExampleTable. The columns in this table are:

InvoiceNumber InvoiceDate ShippedDate Quantity UnitPrice Amount

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