Scribd
Upload
8 views1 page

Excel Autosum and Chart Tutorial

This document contains sales data for 3 products - Sweets, Crisps, and Pops - for the months of January, February, and March for XYZ Limited. It includes a table with the monthly and total sales for each product, as well as a bar graph showing the total sales by month for each product and the overall totals.

Uploaded by

IamMechelle Pates
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
8 views1 page

Excel Autosum and Chart Tutorial

This document contains sales data for 3 products - Sweets, Crisps, and Pops - for the months of January, February, and March for XYZ Limited. It includes a table with the monthly and total sales for each product, as well as a bar graph showing the total sales by month for each product and the overall totals.

Uploaded by

IamMechelle Pates
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

MICROSOFT EXCEL

Activity 2
Using Autosum and Inserting Graph/Chart
XYZ-LIMITED-SALES
PRODUCTS JANUARY FEBRUARY MARCH TOTAL
Sweets 100 150 300 550
Crisps 75 125 215 415
Pops 125 195 350 670
TOTALS 300 470 865 1635

XYZ LIMITED SALES


1800
1600
1400
Sweets
1200
1000 Crisps
RATE

800 Pops
600 TOTALS
400
200
0
JANUARY FEBRUARY MARCH TOTAL
MONTHS

You might also like