Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. Naomi and Kaito have more string instruments than any other type. Naomi wants to summarize the string instrument data using subtotals to show the

image text in transcribed

8. Naomi and Kaito have more string instruments than any other type. Naomi wants to summarize the string instrument data using subtotals to show the value of each type. Switch to the Strings worksheet and add subtotals as follows: Sort the table by the Instrument field in ascending order. Convert the table to a normal range. CH Insert subtotals into the range B2:G12, with the subtotals appearing at each change in the Instrument column value. The subtotals should use the SUM function and include subtotals for the Price and Est. Value fields. Switch to the Wind worksheet and remove the duplicate record based on the values in the Instrument, Manufacturer, and Condition columns. The duplicate record has an incorrect Purchase Date of 7/11/2020. 10. The data bars in the last two columns make some of the numbers hard to read and could coordinate better with the formatting of the Wind table. Change the Data Bars conditional formatting for the range F3:G12 to use the Gradient Fill Orange Data Bar format. Naomi wants to calculate the totals for the instrument collection data. Switch to the All Instruments worksheet, and then create the following formulas: In cell B40, use the COUNTA function with a structured reference to count the values in the Instrument column of the Instruments table. In cell F40, use the SUM function with a structured reference to total the values in the Price column of the Instruments table. 13 In cell G40, use the SUM function with a structured reference to total the values in the Est Value column of the Instruments table. 12 Naomi and Kaito are preparing to sell some of the instruments, and Naomi wants to include the sales date in the Instruments table Add a table column to the end of the table

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

Accounting The Basis For Business Decisions

Authors: Robert F. Meigs, Mary A. Meigs, Mark Bettner, Ray Whittington

10th Edition

0070433607, 978-0070433601

More Books

Students also viewed these Accounting questions

Question

What is the biggest strength of the program?

Answered: 1 week ago

Question

Identify ways to increase your selfesteem.

Answered: 1 week ago