Download the DataSheet (Word document).
Copy the information and insert it into an Excel document.
Use the correct formulas and functions to carry out the following operations:
Calculate the subtotal of each individual sales (Total column)
Calculate the grand total of all sales (Grand Total)
Create a chart showing the total sales (Profit) distributed by item category
Create a chart showing the distribution of items sold
After doing the calculations, answer the following questions:
How much is the grand total of sales?
Which item was sold the most?
Which item generated the most profit?
IMPORTANT: Use Excel to perform the assignment.
[See document A7-2.DataSheet Download A7-2.DataSheetand A7-2_InstructorWorkbook Download A7-2_InstructorWorkbook)