Microsoft Excel 2010

May 8th, 2014
DreamIt
Category:
Computer Science
Price: $15 USD

Question 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.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Purdue University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

5 Reviews


Summary
Quality
Communication
On Time
Value
ashleyisgod
Nov 28th, 2016
" Top quality work from this guy! I'll be back! "
Molly_Moon
Nov 6th, 2016
" AMAZING as always! "
Hemapathy
Oct 14th, 2016
" all I can say is wow very fast work, great work thanks "
BlueOcean
Oct 1st, 2016
" Awesome! Exactly what I wanted. "
kevin12622
Sep 22nd, 2016
" Goes above and beyond expectations ! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1821 tutors are online

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