Microsoft Office Tutorials and References
In Depth Information
order of precedence
tab scrolling buttons
There are no Data Files needed for the Review Assignments.
Sandra has another set of orders she wants you to enter into a new Excel workbook. The
data is shown in Figure 1-38.
Practice the skills you
learned in the tutorial
using the same case
313 Oak Street
Midtown, FL 80481
25 Fourth Street
Cabot, FL 81121
312 Olive Street
Midtown, FL 81241
315 Maple Street
Midtown, FL 80440
Note that Sandra has added the phone numbers of the customers to her data. She wants
the phone numbers entered into the customer address cell, but on a different line within
that cell. To complete this task:
1. Start Excel and open a blank workbook. In the range A1:F5, enter the labels and data
from Figure 1-38. Make sure that the address information is inserted with the street
address on the first line; the city, state, and ZIP code on the second line; and the
phone number on the third line.
2. In cell G1, enter the label “Total.”
3. In the cells below G1, enter formulas to calculate the total amount of each order.
4. In cell A6, enter the label “TOTAL.”