IS2241 Computer spreadsheet excersice Please follow instructions attached till the end Need by Sunday at 0800 CST

Office 2010 – myitlab:grader – Instructions Exploring Excel Chapter 01 - IRCD project

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 during the 2011-2012 season. 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 your spreadsheet to make it visually appealing.

Instructions: For the purpose of grading of the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel file named Exploring_e01_Grader_IR.xlsx. 0 2 On the Session1 worksheet, in cell A3, enter Start Date as the text. In cell B3, enter 7/7/11 as the date. 0 3 On the Session1 worksheet, in cell E7, create a formula that will calculate the session fee with member discount. 10 4 On the Session1 worksheet, change the value in cell D8 to 280, and then clear the contents in cell A13. 2 5 On the Session1 worksheet, in cell H7, create a formula that will calculate the total fees collected for the Introduction to Watercolor class. 10 6 On the Session1 worksheet, use the fill handle to copy the formulas in cells E7 and H7 down through row 11. 16 7 Display the formulas on the Session1 worksheet, and then hide the formulas on the spreadsheet. Delete the worksheet labeled Sheet1. 8 8 On the Session1 worksheet tab, insert a new row above row 5. 4 9 On the Session1 worksheet, move the range A3:B3 to A14:B14. 8 10 On the Session1 worksheet, delete row 3. 4 11 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. 6 12 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). 6 13 On the Session1 worksheet, copy the range A1:H2. Paste the values (without formatting) onto the Class Fees worksheet in cell A1. 8 14 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. 4 15 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. 5 16 On the Class Fees worksheet, apply the Accounting Number format with zero decimal points to the range D6:E10. 5 17 On the Class Fees worksheet, change the page setup options so that the data is centered horizontally on the page. 2 18 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. 2 19 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Class Fees; Session1; Session2; Session3. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed. 0 Total Points 100

Updated on: 15/3/2010 2 E_CH01_EXPV1_IRCD_Instructions.docx