Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started