7. Select the
labels (the month names in the first Row)
Apply the CELL STYLE: Accent 6
8. Rename the
spreadsheet SHEET 1 to be Rainfall Graph
SHEET 2 and add the following labels:
SHEET 2 to be Expenses
Sheet 2 and add the following data:
Column B for currency.
13. Create a
3D pie chart from the Expense data.
the Options to show: Category name and Percentage.
15. Save the
file as Your Name Excel Intermediate Skill Test.
Please submit the Skill Test online.
Please do the
1. Open a new blank spreadsheet.
In Cell A1 type: April
In Cell B1 type: May
Use the Autofill to enter the labels
from June through October
2. Add the following values to your spreadsheet:
3. Select the Range from A1 through G2.
Create a Chart using this Range.
Select the Cylinder Chart type and
remove the legend.
Place the Chart on the same
spreadsheet as your data
4. Select the Chart and format the CHART COLUMN fill
color to red.
Format the CHART COLUMN for September
5. Select the
chart WALL (behind the Chart columns)
Format the fill to be the Waterdrop texture.
6. Select the
text on the AXIS of the Cylinder chart
Format the type to be 9pt.