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.
Having Trouble Meeting Your Deadline?
Get your assignment on
Sort the data in the table in ascending order first by project type and then by start date completed on time. avoid delay and – ORDER NOW
a. Convert the table to a range.
b. 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. Bao is seeking funding for the expansion and wants to create a loan analysis to cover the cost of the distribution center.
