Microsoft Excel 2010
| 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. |
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
