i need help with excel creating formulas

fnovr
timer Asked: Apr 22nd, 2015

Question Description

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

                                                                                                                       


User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors