Microsoft Office Tutorials and References
In Depth Information
Review Assignments
Review Assignments
Practice the skills
you learned in
the tutorial using
the same case
scenario.
There are no Data Files needed for the Review Assignments.
Amanda has another set of orders for you to enter on the Customer Orders worksheet. In
addition to calculating the charge for creating the DVDs, Amanda also wants to include
the cost of shipping in the total charged to each customer. Complete the following:
1. Open a blank workbook, and then save the workbook as Order Report in the
Excel1\Review folder.
2. Rename the Sheet1 worksheet as Documentation , and then enter the following data
into the specifi ed cells:
Cell A1: RipCity Digital
Cell A3: Author Cell B3: your name
Cell A4: Date Cell B4: the current date
Cell A5: Purpose Cell B5: To track customer orders for RipCity Digital
3. Rename the Sheet2 worksheet as Customer Orders .
4. Delete the Sheet3 worksheet.
5. On the Customer Orders worksheet, enter the following data into the specifi ed cells:
Cell A1: RipCity Digital
Cell A3: Customer Orders Report
Cell A4: March 27 to April 17, 2013
6. In cells A5 through H10, enter the column titles and data from Figure 1-33. The
address text in column D should be set on two lines within each cell.
Figure 1-33
New customer order data
Price per
DVD
Shipping
Charge
Date
Last
First
Address
Phone
DVDs
3/27/2013
Fleming
Doris
25 Lee St.
Bedford, VA 24523
(540) 555-5681
7
$18.29
$7.49
4/4/2013
Ortiz
Thomas
28 Ridge Ln.
Newfane, VT 05345
(802) 555-7710
13
$16.55
$9.89
4/8/2013
Dexter
Kay
150 Main St.
Greenbelt, MD 20770
(301) 555-8823
25
$15.79
$7.23
4/9/2013
Sisk
Norman
250 East Maple Ln.
Cranston, RI 02910
(401) 555-3350
15
$16.55
$10.55
4/17/2013
Romano
June
207 Jackston Ave.
Westport, IN 47283
(812) 555-2681
22
$15.79
$13.95
7. Set the width of column A to 10 characters, columns B and C to 12 characters,
column D to 20 characters, and columns E, G, and H to 16 characters.
8. Autofi t all of the rows in the worksheet to the cell contents.
9. In cell I5, enter Total Charge . In cell I6, insert a formula that calculates the total
charge for the fi rst customer (the number of DVDs multiplied by the price per
DVD and then added to the shipping charge). Increase the width of column I to
11 characters.
10. Copy the formula in cell I6 and paste it into the range I7:I10.
 
Search JabSto ::




Custom Search