New Perspectives Excel 365/2021 | Module 6: SAM Project 1b | excel module 6 sam project 1b

To Get this Solution Contact us on Email and WhatsApp is given in Video
WhatsApp no : +923146535108
Email address: solution000777@gmail.com

PROJECT STEPS
1. 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.
2. 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.
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.
4. 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.
5. Switch to the Percussion worksheet. Freeze the first column of the worksheet.
6. 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.
7. 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/25 100 150

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:
a. Sort the table by the Instrument field in ascending order.
b. Convert the table to a normal range.
c. 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.
9. 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/2023.
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.
11. Naomi wants to calculate the totals for the instrument collection data.

#NewPerspectivesExcel365/2021Module1EndofModuleProject1
#NewPerspectivesExcel365/2021Module1EndofModuleProject2
#NewPerspectivesExcel365/2021Module2EndofModuleProject1
#NewPerspectivesExcel365/2021Module2EndofModuleProject2
#NewPerspectivesExcel365/2021Module3EndofModuleProject1
#NewPerspectivesExcel365/2021Module3EndofModuleProject2
#NewPerspectivesExcel365/2021Module4EndofModuleProject1
#NewPerspectivesExcel365/2021Module4EndofModuleProject2
#NewPerspectivesExcel365/2021Module5EndofModuleProject1
#NewPerspectivesExcel365/2021Module5EndofModuleProject2
#NewPerspectivesExcel365/2021Module6EndofModuleProject1
#NewPerspectivesExcel365/2021Module6EndofModuleProject2
#NewPerspectivesExcel365/2021Module7EndofModuleProject1
#NewPerspectivesExcel365/2021Module7EndofModuleProject2
#NewPerspectivesExcel365/2021Module8EndofModuleProject1
#NewPerspectivesExcel365/2021Module8EndofModuleProject2
#NewPerspectivesExcel365/2021Module9EndofModuleProject1
#NewPerspectivesExcel365/2021Module9EndofModuleProject2
#NewPerspectivesExcel365/2021Module10EndofModuleProject1
#NewPerspectivesExcel365/2021Module10EndofModuleProject2
#NewPerspectivesExcel365/2021Module1EndofModuleProject1
#NewPerspectivesExcel365/2021Module1:SAMProject1a
#NewPerspectivesExcel365/2021Module1:SAMProject1
#NewPerspectivesExcel365/2021Module2:SAMProject1a
#NewPerspectivesExcel365/2021Module2:SAMProject1b
#NewPerspectivesExcel365/2021Module3:SAMProject1a
#NewPerspectivesExcel365/2021Module3:SAMProject1b
#NewPerspectivesExcel365/2021Module4:SAMProject1a
#NewPerspectivesExcel365/2021Module4:SAMProject1b
#NewPerspectivesExcel365/2021Module5:SAMProject1a
#NewPerspectivesExcel365/2021Module5:SAMProject1b
#NewPerspectivesExcel365/2021Module6:SAMProject1a
#NewPerspectivesExcel365/2021Module6:SAMProject1b
#NewPerspectivesExcel365/2021Module7:SAMProject1a
#NewPerspectivesExcel365/2021Module7:SAMProject1b
#NewPerspectivesExcel365/2021Module8:SAMProject1a
#NewPerspectivesExcel365/2021Module8:SAMProject1b
#NewPerspectivesExcel365/2021Module9:SAMProject1a
#NewPerspectivesExcel365/2021Module9:SAMProject1b
#NewPerspectivesExcel365/2021Module10:SAMProject1a
#NewPerspectivesExcel365/2021Module10:SAMProject1b
#NewPerspectivesExcel365/2021Module11:SAMProject1a
#NewPerspectivesExcel365/2021Module11:SAMProject1b
#NewPerspectivesExcel365/2021Module12:SAMProject1a
#NewPerspectivesExcel365/2021Module12:SAMProject1b

Видео New Perspectives Excel 365/2021 | Module 6: SAM Project 1b | excel module 6 sam project 1b канала MS Office Hub