Students can use this list to choose items for their spreadsheet. Students are having a party and have invited several classmates, family members and friends.
Students choose at least 6 different foods, drinks, and party gifts that they think their friends will enjoy.
Students create a simple spreadsheet and chart using their chosen items.
Students choose at least 6 different foods, drinks, and party gifts that they think their friends will enjoy.
Students create a simple spreadsheet and chart using their chosen items.
Instructions:
- Type your title "Caleb's Party Food Chart" in Cell B1, then Enter.
- Add the party food data in Column A cells.
- Add the quantities in Column B cells.
- Select (highlight) the food labels and number values in columns A and B.
- On the Insert menu tab select bar chart, choose 2 D bar.
- Double click the chart and then choose "chart layouts" on the ribbon. Choose a chart layout.
Instructions: Students have decided to raise funds to help needy children pay for school supplies. They will make and sell fresh fruit juices and smoothies at the next important school event. Students choose at least 8 items from the Fruit Stand Shopping List for their fruit juice and smoothie creations.
1) Enter the title of the table in cell B1. In this example: Mrs. Viator's Fruit Stand 2) Click in cell B1 and drag the selection to F1. On the Menu bar, go to Table > merge cells.
3) Change the font color, size and style of Mrs. Viator's Fruit Stand text.
4) Enter the fruit data into column A cells. Change the font color, size and style.
5) Enter the number into the column B cells. Change the font size.
6) Select (highlight) the ice cream and number data in columns A and B.
7) Click the Charts button on the menu bar and select the 3D bar chart.
8) The Chart Inspector displays options to adjust the chart. Change the chart colors here.
9) Double click the chart title and change it, in this example: Mrs. Viator's Fruit Stand
1) Enter the title of the table in cell B1. In this example: Mrs. Viator's Fruit Stand 2) Click in cell B1 and drag the selection to F1. On the Menu bar, go to Table > merge cells.
3) Change the font color, size and style of Mrs. Viator's Fruit Stand text.
4) Enter the fruit data into column A cells. Change the font color, size and style.
5) Enter the number into the column B cells. Change the font size.
6) Select (highlight) the ice cream and number data in columns A and B.
7) Click the Charts button on the menu bar and select the 3D bar chart.
8) The Chart Inspector displays options to adjust the chart. Change the chart colors here.
9) Double click the chart title and change it, in this example: Mrs. Viator's Fruit Stand
