Unformatted Attachment Preview
Office 2013 – myitlab:grader – Instructions
Excel Project
SKL ECH05 H2 - Aspen Falls 1.1
Project Description:
In this project, you will format a worksheet for the Aspen Falls Department of Tourism. In the worksheet, you will
create custom number formats, cell styles, worksheet themes, change background fill colors, and apply borders.
Additionally, you will apply conditional formatting to a range of cells, and use the Format Painter to copy
formatting. Finally, you will insert header and footer elements, and modify the display of the worksheet.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
1
2
Points
Possible
Instructions
Start Excel 2013, and then download, open, and save the file exl05_grader_h2.xlsx.
0
Select the range D5:D16. Create a custom number format that will display the value as a
dollar sign followed by a digit, a comma, and then two-digit number with zero decimal places.
Use the Format Painter to copy the format from cell to G5:G21.
9
Hint: On the HOME tab, in the Number group, click the Number Dialog Box Launcher, and
then click Custom.
3
Select the cell B4. Use the Format Painter to copy the format to C4:G4.
9
4
Select cell A17. Insert a cell to move the cells to the right, and then insert a row above row
17.
12
5
Select the range B4:G16. Use the Font group to apply the fill color Green, Accent 6, Lighter
80%. Apply the Thick Box Border with a border color of Green, Accent 6, Darker 50%, and a
thin inside border with the color Green, Accent 6.
12.5
6
7
8
9
Select the range C5:C15. Apply the 4 Arrows (Colored) Icon Sets Style.
12
Apply conditional formatting in the cell range G5:G15 so the cell will be formatted Bold with
the font color Blue, Accent 5 if the value in the cell is greater $30.
Select cell A1. In the Cell Styles group, create a new Cell Style using the name Vintage
Style. Change the number format to Text; change the horizontal alignment to Center Across
Selection; vertical alignment to Center; change the font to Arial; apply Bold formatting;
change the font size to 14; and change the fill color to Green, Accent 6, Darker 50%. Apply
the Cell Style, Vintage Style to the range B1:G2.
Select the range B18:G22. Apply the Green, Accent 6, Lighter 80% fill color, and a Thick box
border color Green, Accent 6, Darker 50%. Select B20:G20. Apply a thin line Green, Accent 6,
Darker 50% top and bottom border, and a Green, Accent 6, Lighter 40% fill color. Apply the
same fill color to B16:G16 and B22:G22.
Updated: 02/13/2015
1
12.5
0
0
Current_Instruction.docx
Office 2013 – myitlab:grader – Instructions
Step
Excel Project
Points
Possible
Instructions
10
In the Themes group, create a Custom Font using the name Vintage Fonts. Change the
body font to Arial.
12.5
11
Download, save, and insert exl05_grader_h2_Logo.jpg in the left section of the worksheet
footer. Insert the file name element in the right section of the worksheet footer.
12.5
12
13
Change the sheet options to hide the worksheet gridlines and row and column headings.
Save the workbook, close the workbook window, and then submit the workbook as directed.
Total Points
Updated: 02/13/2015
2
9
0
101
Current_Instruction.docx
Aspen Falls
2014 Vintage Car Show
Fees
Car Clubs
National Capitol Club
Bay Club
Capitol Rockets
Fast Guys Club
Roaring Engines
Eastern Fast Cars
Northwest Flyers
Southern Screamers
Rip Roaring Classics
Hot Rod Trucks
Fast Lane Ladies
Total
$40
Spectators
Total Earnings
No. of Cars Fees
Vendors
Spaces
Fees
21
840
Flea Tea
1
15
600 Perkins Popcorn
2
23
920
Candy Shack
1
42
1680 Thirst Quencher
1
24
960
Pop &Pizza
3
16
640 Hotty Dogs Plus
2
32
1280 Car Memorabilia
1
9
360
Stylish Shirts
2
46
1840 Tracy's Treasures
1
38
1520
Art's Auto
3
28
1120 Custom Interiors
2
294
11760
19
$30
673
$5
30
60
30
30
90
60
30
60
30
90
60
570
3365
15695