Intermediate Excel Skill Test

 

 

 
 
 

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

 

9. Select SHEET 2 and add the following labels:
A1=Expenses
A2=Rent
A3=Phone
A4=Electricity

 

10. Rename SHEET 2 to be Expenses

 

11. Select Sheet 2 and add the following data:
B1=Amount
B2=1,500
B3=545
B4=130

 

12. Format Column B for currency.

 

13. Create a 3D pie chart from the Expense data.

 

14. Change 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 following steps:

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:
A2=3.4
B2=2.7
C2=1.8
D2=.75
E2=.5
F2=6.4
G2=3.4


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 yellow.

 

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.