9-11
u Formula Input Example
A B C
1
PRICE QUANTITY TOTAL
2 35 15 525
3 52 15 780
4 78 20 1560
Procedure
1. Input the text for line 1, and the applicable values in cells A2 through B4.
2. Move the cursor to cell C2, and input the formula for A2 × B2.
!.(=) av(A) c*al(B) cw
3. Copy the formula in cell C2 and copy it into cells C3 and C4. Move the cell cursor to cell C2
and then perform the following operation.
2(EDIT) 2(COPY) c1(PASTE) c1(PASTE) J
• For details about the copy and paste operations, see
“Copying and Pasting Cell Contents” (page 9-14).
k Inputting a Cell Reference Name
Each cell on a spreadsheet has what is called a “reference name”, which is derived by
combining its column name (A through Z) with its row name (1 through 999). A cell reference
name can be used inside of a formula, which makes the value of the called cell part of the
formula. See “Inputting a Formula into a Cell” above for more information. There are two
methods you can use to input a cell reference name: direct input of the name and input using
the GRAB command. The following illustrates how you would use each of these methods to
input =A1+5 into cell B1.
u To input a cell reference name using direct input
Move the cell cursor to cell B1 and then perform the following operation.
!.(=) av(A) b+fw
To Next Page
Loading...
Need help?
General
