Download Microsoft(R) Excel 97 ,with JAWS For Windows 3.2 Tutorial for

Transcript
Excel 97 with JAWS For Windows 3.2
Lesson Four Performing Calculations
16000;
3. Cell F6 contains the current total service figure. That figure is 26000;
4. Cell F7 contains the current total revenue figure. That figure is 48000;
and
5. Any change to cell E6 will cause changes in cells E7,
F6,
and F7.
Exercise: Changing the Fourth Quarter Service Data
Complete the following five steps to move to cell E6 and change the fourth
quarter service figure.
Step 1: Press the Center key to verify cell F7 is selected.
Step 2: -
Move to cell E6. (Press the Left Arrow key to move to cell E7.
Then, press the Up Arrow key to move to cell E6.)
Step 3: Press the Center key to verify that cell E6 is selected. JFW
announces, "E6 8000."
Step 4: Change the fourth quarter service figure to 9000. Type
9000.
Press Enter to accept the change. Excel accepts the information and
moves the focus to cell E7.
When you enter new data into cell E6, Excel automatically recalculates the
totals in cells E7, F6, and F7 because these cells contain formulas that use
data in cell E6.
Step 5: Verify the correct figure appears in cell E6. Press the Up Arrow
key to move to E6. JFW should announce, "E6 9000.".
Exercise: Checking the Changed Data
Complete the following four steps to check the changes and determine the
new quarterly and yearly totals.
Issue Date: 10/9/98
ASSIST With Windows (Iowa Department for the Blind)
Page: 4-24