Microsoft Excel 2010

User Generated

frxb92

Computer Science

Description

Exploring_e01_Grader_IR.xlsx 

Start Excel. Open the downloaded Excel file named Exploring_e01_Grader_IR.xlsx.
On the Session1 worksheet, in cell A3, enter Start Date as the text. In cell B3, enter 7/7/11 as the date.
On the Session1 worksheet, in cell E7, create a formula that will calculate the session fee with member discount.
On the Session1 worksheet, change the value in cell D8 to 280, and then clear the contents in cell A13.
On the Session1 worksheet, in cell H7, create a formula that will calculate the total fees collected for the Introduction to Watercolor class.
On the Session1 worksheet, use the fill handle to copy the formulas in cells E7 and H7 down through row 11.
Display the formulas on the Session1 worksheet, and then hide the formulas on the spreadsheet. Delete the worksheet labeled Sheet1.
On the Session1 worksheet tab, insert a new row above row 5.
On the Session1 worksheet, move the range A3:B3 to A14:B14.
On the Session1 worksheet, delete row 3.
On the Session1 worksheet, copy the range A5:E11. Click on the Class Fees worksheet tab, and then paste the copied range into cell A4.
On the Class Fees worksheet, change the width of column A to 30.00 (215 pixels). Change the width of columns D and E to 14.57 (107 pixels).
On the Session1 worksheet, copy the range A1:H2. Paste the values (without formatting) onto the Class Fees worksheet in cell A1.
On the Class Fees worksheet, merge and center the text in cell A1 across the range A1:E1, and then merge and center the text in cell A2 across the range A2:E2.
On the Class Fees worksheet, select the range A4:E5 and add a bottom border. With the range still selected, change the fill color to Tan, Background 2.
On the Class Fees worksheet, apply the Accounting Number format with zero decimal points to the range D6:E10.
On the Class Fees worksheet, change the page setup options so that the data is centered horizontally on the page.
On the Class Fees worksheet, create a header that will display the text Class Fees in the center section of the header area. Print preview the Class Fees worksheet. Return to Normal view.

Unformatted Attachment Preview

The Fernwood Art Center Adult Classes Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Add Oil Painting Workshop? Total Weeks 10 8 1 10 1 Member Discount 0,5 0,5 0,25 0,5 0,25 Session 1 - Enrollment Totals Session Fee Non-Member Member 315 275 75 360 75 Enrollment Totals Non-Member Member 4 2 2 3 5 Total Fees Collected 6 8 4 5 7 The Fernwood Art Center Adult Classes Session 2 - Enrollment Totals Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Start Date: Total Weeks 10 8 1 10 1 9/15/2011 Member Discount 50% 50% 25% 50% 25% Session Fee Non-Member Member $ 315 $ 158 $ 275 $ 138 $ 75 $ 56 $ 360 $ 180 $ 75 $ 56 Enrollment Totals Non-Member Member 3 4 1 3 7 8 2 5 6 2 Total Fees Collected $ 2.205 $ 1.375 $ 356 $ 2.160 $ 638 The Fernwood Art Center Adult Classes Session 3 - Enrollment Totals Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Start Date: Total Weeks 10 8 1 10 1 1/19/2012 Member Discount 50% 50% 25% 50% 25% Session Fee Non-Member Member $ 315 $ 158 $ 275 $ 138 $ 75 $ 56 $ 360 $ 180 $ 75 $ 56 Enrollment Totals Non-Member Member 3 4 1 3 7 8 2 5 6 2 Total Fees Collected $ 2.205 $ 1.375 $ 356 $ 2.160 $ 638 The Fernwood Art Center Adult Classes Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Add Oil Painting Workshop? Total Weeks 10 8 1 10 1 Member Discount 0.5 0.5 0.25 0.5 0.25 Session 1 - Enrollment Totals Session Fee Non-Member Member 315 275 75 360 75 Enrollment Totals Non-Member Member 4 2 2 3 5 Total Fees Collected 6 8 4 5 7 The Fernwood Art Center Adult Classes Session 2 - Enrollment Totals Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Start Date: Total Weeks 10 8 1 10 1 9/15/2011 Member Discount 50% 50% 25% 50% 25% Session Fee Non-Member Member $ 315 $ 158 $ 275 $ 138 $ 75 $ 56 $ 360 $ 180 $ 75 $ 56 Enrollment Totals Non-Member Member 3 4 1 3 7 8 2 5 6 2 Total Fees Collected $ 2,205 $ 1,375 $ 356 $ 2,160 $ 638 The Fernwood Art Center Adult Classes Session 3 - Enrollment Totals Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Start Date: Total Weeks 10 8 1 10 1 1/19/2012 Member Discount 50% 50% 25% 50% 25% Session Fee Non-Member Member $ 315 $ 158 $ 275 $ 138 $ 75 $ 56 $ 360 $ 180 $ 75 $ 56 Enrollment Totals Non-Member Member 3 4 1 3 7 8 2 5 6 2 Total Fees Collected $ 2,205 $ 1,375 $ 356 $ 2,160 $ 638 The Fernwood Art Center Adult Classes Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Add Oil Painting Workshop? Total Weeks 10 8 1 10 1 Member Discount 0.5 0.5 0.25 0.5 0.25 Session 1 - Enrollment Totals Session Fee Non-Member Member 315 275 75 360 75 Enrollment Totals Non-Member Member 4 2 2 3 5 Total Fees Collected 6 8 4 5 7 The Fernwood Art Center Adult Classes Session 2 - Enrollment Totals Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Start Date: Total Weeks 10 8 1 10 1 9/15/2011 Member Discount 50% 50% 25% 50% 25% Session Fee Non-Member Member $ 315 $ 158 $ 275 $ 138 $ 75 $ 56 $ 360 $ 180 $ 75 $ 56 Enrollment Totals Non-Member Member 3 4 1 3 7 8 2 5 6 2 Total Fees Collected $ 2,205 $ 1,375 $ 356 $ 2,160 $ 638 The Fernwood Art Center Adult Classes Session 3 - Enrollment Totals Class Name Introduction to Watercolor Basic Drawing Tilemaking Workshop Black & White Photography Glass Bead Workshop Start Date: Total Weeks 10 8 1 10 1 1/19/2012 Member Discount 50% 50% 25% 50% 25% Session Fee Non-Member Member $ 315 $ 158 $ 275 $ 138 $ 75 $ 56 $ 360 $ 180 $ 75 $ 56 Enrollment Totals Non-Member Member 3 4 1 3 7 8 2 5 6 2 Total Fees Collected $ 2,205 $ 1,375 $ 356 $ 2,160 $ 638
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags