EXCEL CHARTING EXERCISES – 3X
Part I – Donut Shop
Input the following data into a new spreadsheet file.
Hopper’s Donut Shop - Monthly Expenses
Kitchener Waterloo Cambridg
e
Guelph TOTAL
Land Line 85.76 92.21 127.16 77.72
Mail 147.22 286.94 152.10 99.67
Cell
Phone
142.88 275.22 100.23 62.25
Internet 63.27 63.27 63.27 63.27
TOTAL
● Use the SUM function to tally both the horizontal and vertical
totals.
● Make sure that the numbers are formatted as currency.
● Create a Column graph on a separate page.
Chart Title: Hopper’s Donut Shop - Monthly Expenses
X Axis: Location
Y Axis: Cost
Add a Legend
Save the file as “Donut Shop”
Part II –Bread Shop
Input the following data into a new spreadsheet file.
Willy’s Bread Shop
Total Yearly Sales
Bagels 23,556
Cheese Buns 16,200
Dinner Rolls 15,857
French Stick 12,391
Soft Pretzels 30,078
Weck Buns 9844
Rye Bread 16,390
TOTAL
