[vip_students] Re: Excel Tutorial:Lesson 10, Reviewing the budget data.
- From: "NCBI Technical Support" <paul.traynor@xxxxxxx>
- To: <vip_students@xxxxxxxxxxxxx>
- Date: Thu, 22 Mar 2007 16:28:52 -0000
In this next lesson we will take a look over our work in the previous
lesson.
Exercise: Reviewing the Budget Data
Complete the following twelve steps to read the budget data you entered in
the previous exercise.
Step 1: Press Ctrl-Home to move to the first cell in the worksheet (cell
A1). JAWS announces, "First Cell Budget 2003 A1."
Step 2: Press Ctrl-Shift-D to open the Cells with Data dialog box. JAWS
announces, "Please Wait Collecting Data Cells with Data Dialog List Box
A1: Budget 2003 1 of 10."
Step 3: Press the Down Arrow key repeatedly to review the cells in the
worksheet that contain data. When finished, press Escape.
The focus returns to cell A1 in the worksheet. JAWS announces, "Budget 2003
A1."
Step 4: Press Ctrl-Shift-C to open the Column Cells with Data dialog box.
JAWS announces, "Please Wait Collecting Data Column Cells with Data Dialog
List Box A1: Budget 2003 1 of 6." Then, press the Down Arrow key repeatedly
to review the cells in the current column (column A) that contain data. When
finished, press Escape.
The focus returns to cell A1 in the worksheet.
Step 5: Press Ctrl-Shift-R to open the Row Cells with Data dialog box. JAWS
announces, "Please Wait Collecting Data Row Cells with Data Dialog List
Box A1: Budget 2003 1 of 1." Row 1 contains only one cell with data. When
finished reviewing the data, press Escape.
Step 6: Press the Up, Down, Right, and Left Arrow keys to review the
worksheet data.
Step 7: Use the Arrow keys to move to cell B7.
Step 8: Press Insert-C to read the cell reference again. JAWS announces,
"B7." Then, press the Numpad 5 key to read the cell contents again. JAWS
announces, "1710."
Step 9: Read the contents of the first four cells in column B by pressing
Alt-1 to read the contents of the first cell in the current column. Then,
press Alt-2 to read the second cell in the column. Press Alt-3 to read the
third cell. Finally, press Alt-4 to read the fourth cell.
You should notice that the first three cells in column B do not contain
data. The fourth cell in the current column, cell B4, contains the word
"Expense." This is the text label for the numerical data that follows in
cells B5, B6, and B7.
Step 10: Press the Numpad 5 key to read the contents for the active cell.
JAWS should announce, "1710". (Remember, the selection cursor does not move
when you use the keystrokes to read the first four cells in the current
column.)
Step 11: Press Alt-Ctrl-1 to read the contents of the first cell in the
current row (cell A7). JAWS should announce, "March." Cell A7 contains the
word "March." This is the text label for the numerical data that appears in
row 7.
You should have determined that the March expenses were 1,710.
Step 12: Press Ctrl-Home to move the selection cursor to cell A1.
You will learn how to save your work in the next topic "Saving a Workbook."
What You Learned. In this topic, you learned:
Because a single cell can store up to 32,767 characters, you can enter a
single number or a lengthy text description into a cell. (You may need to
adjust the cell size to ensure all of its data appears on the screen and
printed page.)
Excel treats the data you enter in a cell as either a constant value or a
formula. Constant values include text and numeric figures that do not change
unless you select the data and edit it. A formula is a mathematical
expression that is composed of numeric values, cell references, functions,
and operators. The result of a formula can change when other values in the
worksheet change.
To move to a new cell, use the arrow keys to move the selection cursor.
You should always verify the cell reference before you type or edit data in
a cell.
To enter data, select the appropriate cell and type the data.
Once you type the data, you can press either Enter or any arrow key to enter
the data. When you press Enter, the selection cursor moves to the cell below
the cell in which you entered data. When you press an arrow key, the
selection cursor moves to the corresponding adjacent cell.
When you enter data in a cell, it appears in two places: the active cell and
the edit field on the Formula Bar. (You can press Ctrl-F2 to read the
information in the Formula Bar edit field.)
********************************************************************
NOTICE: The information contained in this email and any attachments
is confidential and may be privileged. If you are not the intended
recipient you should not use, disclose, distribute or copy any of
the content of it or of any attachment; you are requested to notify
the sender immediately of your receipt of the email and then to
delete it and any attachments from your system.
NCBI endeavours to ensure that emails and any attachments generated
by its staff are free from viruses or other contaminants. However,
it cannot accept any responsibility for any such which are
transmitted. We therefore recommend you scan all attachments.
Please note that the statements and views expressed in this email
and any attachments are those of the author and do not necessarily
represent the views of NCBI
********************************************************************
Other related posts:
- » [vip_students] Re: Excel Tutorial:Lesson 10, Reviewing the budget data.
