E CH01 EXPV1 A1 Instructions
Fernwood Art Center Adult Classes
Project Description:
In this project, you will create a spreadsheet detailing the list of adult classes offered by the Fernwood Art Center for Session 2. You will calculate the cost of each class for those with a member discount. Additionally, you will create a formula to summarize the total fees collected for each class during the first session of the season. Finally, you will format the worksheet spreadsheet to make it visually appealing.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Start Excel. Download and open the workbook named exploring_e01_grader_a1.xlsx.
0
2
Set a width of 25 for column A.
4
3
Center horizontally the labels in the range A8:G8 and then apply wrap text to the labels in the range A8:G8.
6
4
Merge and center the label Total Fees Collected in the range H7:H8. Wrap text for the label in its merged cell.
6
5
In cell E9, enter a formula that calculates the Session Fee for a Member. Members receive a Member Discount off the Non-Member Session Fee. Copy the formula from cell E9 down through row 12.
15
6
In cell H9, create a formula that will calculate the total fees collected for the Introduction to Watercolor class. Copy the formula from cell H9 down through row 12.
15
7
Change the value in cell D11 to 280. Insert a row below row 9. Enter Basic Drawing in cell A10, 4 in cell B10, 50% in cell C10, 275 in cell D10, 10 in cell F10, and 4 in cell G10. Be sure the formulas in columns E and H are copied to the new row.
10
8
Apply Percent Style to the Member Discount values in column C. Center horizontally the Member Discount percentages in column C.
4
9
Apply Accounting Number Style to the Non-Member fees in column D, the Member fees in column E, and the Total Fees Collected in column H.
8
10
Set the Outside Borders around the range A7:H13.
4
11
Apply Green, Accent 6, Darker 50% fill color and White, Background 1 font
Project Description:
In this project, you will create a spreadsheet detailing the list of adult classes offered by the Fernwood Art Center for Session 2. You will calculate the cost of each class for those with a member discount. Additionally, you will create a formula to summarize the total fees collected for each class during the first session of the season. Finally, you will format the worksheet spreadsheet to make it visually appealing.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Start Excel. Download and open the workbook named exploring_e01_grader_a1.xlsx.
0
2
Set a width of 25 for column A.
4
3
Center horizontally the labels in the range A8:G8 and then apply wrap text to the labels in the range A8:G8.
6
4
Merge and center the label Total Fees Collected in the range H7:H8. Wrap text for the label in its merged cell.
6
5
In cell E9, enter a formula that calculates the Session Fee for a Member. Members receive a Member Discount off the Non-Member Session Fee. Copy the formula from cell E9 down through row 12.
15
6
In cell H9, create a formula that will calculate the total fees collected for the Introduction to Watercolor class. Copy the formula from cell H9 down through row 12.
15
7
Change the value in cell D11 to 280. Insert a row below row 9. Enter Basic Drawing in cell A10, 4 in cell B10, 50% in cell C10, 275 in cell D10, 10 in cell F10, and 4 in cell G10. Be sure the formulas in columns E and H are copied to the new row.
10
8
Apply Percent Style to the Member Discount values in column C. Center horizontally the Member Discount percentages in column C.
4
9
Apply Accounting Number Style to the Non-Member fees in column D, the Member fees in column E, and the Total Fees Collected in column H.
8
10
Set the Outside Borders around the range A7:H13.
4
11
Apply Green, Accent 6, Darker 50% fill color and White, Background 1 font