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 color to the Total Fees Collected label. |
8 |
|
12 |
Change the page setup options so that the data is centered horizontally on the page. |
3 |
|
13 |
Change the orientation to Landscape. |
3 |
|
14 |
Create a footer that displays the text Art Center Classes in the left section and insert the sheet name code in the right section of the footer area. |
6 |
|
15 |
Copy the Session 2 worksheet, move it to the end, and rename it as Copy. |
4 |
|
16 |
Display the settings to print gridlines and headings. |
4 |
|
17 |
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Session2, Copy. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed. |
0 |
|
Total Points |
100 |
0 comments