### Free Educational Resources

• > Exploring ­ Excel Chapter 1: Assessment Project...
+

# Exploring ­ Excel Chapter 1: Assessment Project 1 Fernwood Art Center Adult Classes

##### Rating:
(0)
Author: matthew stock
##### Description:

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

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

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 19 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial