[vip_students] Re: Excel Tutorial:Lesson 9,
- From: "NCBI Technical Support" <paul.traynor@xxxxxxx>
- To: <vip_students@xxxxxxxxxxxxx>
- Date: Thu, 22 Mar 2007 16:27:10 -0000
Lesson 9, please open up your Microsoft excel program and go through the
following lessons.
Introduction. A single cell can store up to 32,767 characters. This allows
you to type as much information into a single cell as necessary for your
work, from a single number to a lengthy text description. Once you enter the
data, however, only the data that will fit into the currently defined size
of the cell will appear on the screen and printed page until you change the
cell size. (You will learn how to adjust the cell size in Lesson Five:
Formatting Data.)
Note: What this means is that you have little retangular shapes on an excel
sheet. If you type in more information into each one of those retangular
shapes some of what you have typed in will disappear under the edges of the
little shapes so if you hear jaws reading the information within the
rectangales a bit funny as if some bits are chopped off the sides don't
worry too much about it.
Types of Data. Excel treats the data you enter in a cell as either a
constant value or a formula.
Definition of a constant value:a quantity that does not vary, thus if I have
the number "33" on my door, then my house is deemed to be number 33 now and
always on the address, it never changes and this is an example of a constant
value, "it never changes".
Another definition of a Constant Value. Any data that you enter in a cell
that is not a formula is considered a constant value. This includes text and
numeric figures such as dates, times, currency, or percentages. This type of
data does not change unless you select the data and edit it.
Formula. A formula is a mathematical expression that is composed of numeric
values, cell references, functions, and operators. The data that is produced
by a formula can change when other values in the worksheet change. You will
learn more about formulas in Lesson Four: Performing Calculations.
Data Alignment. By default, all text is left aligned in the cell and all
numbers, dates, and times are right aligned. If you type in a combination of
text and numbers, the data is left aligned. Formulas are right aligned.
Exercise Objective. In the following exercise, you will type data into a
blank worksheet.
Note: All of the data you will enter in this lesson will be constant values
(data that does not change unless you edit it).
Exercise: Typing Data into a Blank Worksheet
Complete the following twenty-one steps to type budget data into a blank
worksheet.
Step 1: Press Insert-T to verify Microsoft Excel is the active program.
JAWS announces, "Title Equals Microsoft Excel - Book1."
Step 2: Press Insert-C to read the current cell reference. JAWS should
announce, "A1." The selection cursor is around cell A1.
Tip: You should always verify the cell reference before you type or edit
data in a cell.
Step 3: Type in the following text into cell A1: Budget 2003.
When you enter data into a cell, the data 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.)
Step 4: Press Enter to accept the data you typed in cell A1.
JAWS announces, "Blank A2."
When you finish typing data in a cell, you must press Enter or any Arrow to
accept the information in the cell. When you press Enter, Excel accepts the
information and places a selection cursor around the next cell in the
current column.
Step 5: Press Insert-C to read the cell reference for the active cell. JAWS
should announce, "A2," indicating the selection cursor is around the cell at
column A, row 2.
Step 6: In cell A2, type Personal. Then, press Enter to accept the data in
the cell.
JAWS announces, "Blank A3." The focus is on cell A3.
Step 7: Press the Down Arrow key once to move the selection cursor to cell
A4.
Step 8: Press Insert-C to read the current cell reference. JAWS should
announce, "A4." In cell A4, type Month.
Step 9: Press the Right Arrow key to accept the data in cell A4 and move
the selection cursor to cell B4. JAWS announces, "Blank B4."
Step 10: Press Insert-C to read the current cell reference. JAWS should
announce, "B4." In cell B4, type Expense.
Step 11: Press the Left Arrow key once to enter the data and move back to
cell A4. Then, press the Down Arrow key to move the selection cursor to cell
A5.
Step 12: Press Insert-C to verify that cell A5 is the active cell. In cell
A5, type January.
Step 13: Press the Right Arrow key to enter the data and move the selection
cursor to cell B5.
Step 14: Press Insert-C to verify that cell B5 is the active cell. In cell
B5, type 1680.
Step 15: Press the Left Arrow key once to enter the data and move back to
cell A5. Then, press the Down Arrow key to move the selection cursor to cell
A6.
Step 16: Press Insert-C to verify that cell A6 is the active cell. In cell
A6, type February.
Step 17: Press the Right Arrow key to enter the data and move the selection
cursor to cell B6. In cell B6, type 1474.
Step 18: Press the Left Arrow key to enter the data and move back to cell
A6. Then, press the Down Arrow key to move the selection cursor to cell A7.
Step 19: Press Insert-C to verify that cell A7 is the active cell. In cell
A7, type March.
Step 20: Press the Right Arrow key to enter the data and move the selection
cursor to cell B7.
Step 21: In cell B7, type 1710. Then, press Enter to accept the data.
********************************************************************
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 9,
