3. Insert a Total Row in the Brass table, and then use the Total row to calculate the total of the values in the Price and Est. Value fields.

Question

help with these qns pls:

Kaito and Naomi Sato started collecting musical instruments as a hobby a few years ago and are now organizing their collection in an Excel workbook. Naomi asks for your help in updating and analyzing the data. Switch to the Brass worksheet. Unfreeze the top row of the worksheet.
Sort the data in the Brass table first in descending order by the Purchase Date field and then in descending order by the Est. Value field.
Insert a Total Row in the Brass table, and then use the Total row to calculate the total of the values in the Price and Est. Value fields.
Naomi wants to highlight the brass instruments she and Kaito bought on the same date. Apply a conditional formatting rule to the range E3:E10 that uses Green Fill with Dark Green Text for duplicate values.
Switch to the Percussion worksheet. Freeze the first column of the worksheet.
Format the range B2:G10 as an Excel table with headers using the Gold, Table Style Medium 12 table style. Enter Percussion as the name of the table.
Naomi and Kaito bought a new snare drum last week, and Naomi wants to include it in the Percussion table. Add the record shown in Table 1 to the end of the Percussion table. Table 1: New Record for the Percussion Table _ B C D E F G 11 Snare drum Sousa Good 2/16/22 100 150

davidmacago · Answer

Go to the brass worksheet. Go to view tab > Freeze Panes > Unfreeze
Click dropdown of Purchase Date, select Newest to Oldest. Similarly, click dropdown of Est. Field > Largest to Smallest.
Click on any sell in table > Go to Table Design tab. Click Total Row checkmark. On cell F11 enter =sum([Price])
Select E3 through E10. Home tab > Conditional Formating > Highlight Cell Rules > Duplicate Value > choose Green Fill with Dark Green Text value.
Switch to Percussion worksheet. Click 1st row > View tab > Freeze Panes > Freeze First Column
Select B2 through G10. Home tab > Format as Table > Gold Medium Style 12. Click any cell inside table. Table Design tab > Enter Percussion as the name of the table.
Copy the data > select cells which are supposed to be fulled > right click and paste using Match Destination Format option.

Video instruction:

Answers