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

"Is this question part of your assignment? We can help"

ORDER NOW