# Fernwood Art Center Adult Classes, computer science homework help

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 cellD11 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