Spreadsheet Exercise
10 points
This exercise needs to be done in one class. Full points will be earned when this exercise is done in class. Save this exercise in your Document folder or send me an email with attachment (ysun@sad60.k12.me.us). The following are the directions.
- Open NeoOffice
- File – New
- Spreadsheet
- Do the data entry according to the first page instructions (different from the example)
2. Calculate
- In Column F (Earnings) type =b2*d2+c2*e2 and then press Return.
- Copy this cell into the next three cells. (Notice that the value changes based on the values in that row.)
- In Total cell type =f2+f3+f4+f5 and press Return.
- In percentage column type the following formula in four cells
- =f2/f7 and press Return
- =f3/f7 and press Return
- =f4/f7 and Press Return
- =f5/f7 and Press Return
3. Copy the values into another file
- Copy the column of the drivers into another column (like the example)
- Highlight all of the percentage values and copy them
- Then go to Edit and select Paste Special
- Check Number
4. Make a Chart
- Highlight the two columns
- Go to Insert
- Click Chart
- Next
- Select Pie Chart
- Create
- Double click the title and change it to Percentage
- Double click the chart
- Click Data labels
- Click Show value
- Check as percentage