# Microsoft Excel 2010

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

Question description

 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.

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

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 ! "

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