Calculate the subtotal of each individual sales (Total column)

Words: 190
Pages: 1
Subject: Uncategorized

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)

Let Us write for you! We offer custom paper writing services Order Now.

REVIEWS


Criminology Order #: 564575

“ This is exactly what I needed . Thank you so much.”

Joanna David.


Communications and Media Order #: 564566
"Great job, completed quicker than expected. Thank you very much!"

Peggy Smith.

Art Order #: 563708
Thanks a million to the great team.

Harrison James.


"Very efficient definitely recommend this site for help getting your assignments to help"

Hannah Seven