Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm on 23. i dont understand why my answers are different from the people on here. can someone please help me? A F 8- SC_019.CS4-Ta

I'm on 23. i dont understand why my answers are different from the people on here. can someone please help me? image text in transcribed
image text in transcribed
A F 8- SC_019.CS4-Ta Delany Walt Home the De Page Layout Formas Data View Help Tabs A. 19 Wap Ten f BUSA Merge Center $ - % X 75 4 BODO 10 11 12 13 54 15 16 37 18 19 ID Project Name Project Type Start Date Budget AC533 Just Spirits Action movie 6/2/2022 $ 45,500 AC210 Tension Sunrise Action movie 6/13/2022 S 12.000 TV453 Against the Wall Action movie 7/12/2022 5 22.500 TV697 Say idee Action movie 7/28/2022 $ 28,500 AC328 The Castle Behind Me Action movie 9/1/2022 $ 23,010 Action movie Total $ 131,510 C0720 Mack and Mac Comedy 9/20/2022 5 18,555 C0789 Space Plum Comedy 10/3/2022 $ 25,000 C0329 Karate Night Comedy 10/9/2022 $ 20,000 DR887 Never in common Comedy 11/1/2022 S 19,700 DR543 All My Friends Comedy 11/18/2022 $ 12,200 DR521 A Great Getaway Comedy 1/10/2023 5 31.500 Comedy Total $ 126,955 C0325 Teenage Miracle Mile Drama 1/13/2023 S 24,000 DR512 The Great Grasshopper Drama 2/22/2023 S 12,500 DR622 Downtown Bike Path Drama 2/28/2023 $ 15,000 TV482 Because of Winston Drama 3/3/2023 5 24,500 AC736 Wir Drama 3/11/2021 10.00 SULEC All Content Subtotalsantion Funding 3 Type here to search O Ru 2. 3 4 Q E B T A S D F G N V B as worked whiccese DOCES LLC worksheet. Bao wants to display the data by project tyre, and then list the projects by. start date. (Hint: You must complete all actions in this step and the following ster correctly to receive full credit Sort the data in the table in ascending order first by project type and then by start date. both in ascending order 23. Bao also wants to calculate subtotals for each funding type. Convert the table to a range Insert a subtotal.at each change in the Project Type value. c. Use the Sum function to calculate the subtotals. d. Add subtotals to the Budget values only. e. Include a summary below the data. f. Collapse the outline to display only the subtotals for each project.type and the grand total 24. Go to the Expansion Funding worksheet. VSS is considering whether to expand into selling portable media devices for viewing their streaming content. The company would buy the devices from a manufacturer and then ship them from a distribution center Bag is seeking funding for the expansion and wants to create a loan analysis to cover the cost of the distribution center First. Bao wants to update and define names in the worksheet as follows: a. Delete the Loan Calculator defined name

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Accounting And Finance For Non Specialist Managers

Authors: Anthony Dixon

1st Edition

1081965290, 978-1081965297

More Books

Students also viewed these Accounting questions

Question

What early evidence of management practice can you describe?

Answered: 1 week ago

Question

Why do some firms still rely on the IRR rule instead?

Answered: 1 week ago