Microsoft Office Tutorials and References
In Depth Information
Session 1.2
Key Terms
active cell
adjacent range
argument
arithmetic operator
AutoComplete
AutoSum
cell
cell range
cell reference
clear
column
delete
documentation sheet
edit mode
formula
Formula bar
Formula view
function
landscape orientation
Name box
nonadjacent range
order of precedence
portrait orientation
range
range reference
row
sheet
sheet tab
Spell Checker
spreadsheet
SUM function
tab scrolling buttons
value
what-if analysis
workbook
workbook window
worksheet
worksheet window
Review Assignments
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
Practice the skills you
learned in the tutorial
using the same case
scenario.
Figure 1-38
Name
Address
Date
Item
Price
Qty
Wendy Battle
313 Oak Street
5/1/2006
Deluxe Combo
$23
2
Midtown, FL 80481
(833) 555-1284
Eugene Burch
25 Fourth Street
5/1/2006
Red Grapefruit
$14
4
Cabot, FL 81121
(833) 555-3331
Nicole Sweeny
312 Olive Street
5/3/2006
Deluxe Combo
$23
1
Midtown, FL 81241
(833) 555-9811
Amy Yang
315 Maple Street
5/4/2006
Navel Oranges
$17
3
Midtown, FL 80440
(833) 555-3881
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.”
 
Search JabSto ::




Custom Search