Page 61 - Ones and Zeros 4 (Student Book)
P. 61
5 Pie? 6 No! Apple pie!
Yes! I’ve also added data callouts Oh! Hahaha! Let’s find a recipe
to each segment of the pie. online and bake one!
Project! Flying High!
Creating a spreadsheet with a sum statement Pie charts are quite popular when
and a pie chart. used in business and economics.
Now, it’s your turn to create a spreadsheet to Thousands of them are used every
calculate your expenses. day to present data.
1. Open a new spreadsheet. Chocolate bars?
2. Create a data table with two columns.
One will display months and the other
will display the money you spent each
month.
3. Add a sum statement to calculate
the total value of money spent.
4. nsert a pie chart by using the data
I
in the table (without the sum statement).
5. Use data callouts for each segment.
6. Change the chart title to ‘My Expenses’.
7. Save the file as ‘My Expenses.xlsx’
and exit.
All this talk about pies has made
Did you follow all the steps? Check the me hungry. Next time, we’ll use bar
ones you did. charts in our spreadsheets!
59
