[vip_students] Excel Tutorial: Lesson 4, reviewing the excel window!
- From: "Lists" <lists@xxxxxxxxxxxxxxx>
- To: <vip_students@xxxxxxxxxxxxx>
- Date: Fri, 9 Mar 2007 16:59:48 -0000
Hi All,
Ready for another couple of excel lessons?. Okay, go to your "start menu,
Programs menu" and down arrow till you come to Microsoft Excel then press
the enter key to open.
Topic: The Excel Program Window
Introduction. This topic describes the layout of the Excel program window
and defines the elements in the window. You will learn how to review the
Excel program window to find each of these elements.
You may find it helpful to review the program window when you open a program
that is new to you. Reviewing the window can help you learn what the program
can do and what commands are available.
Exercise Objective. In the following exercise, you will review the Excel
program window using the JAWS Cursor.
Exercise: Reviewing the Program Window
Complete the following thirteen steps to review the Excel program window.
Step 1: Press Insert-T to verify that Excel is the active program. JAWS
announces, "Title Equals Microsoft Excel - Book1."
Step 2: Press Insert-Minus route the JAWS Cursor to the PC Cursor.
Step 3: Press Page Up to move the JAWS Cursor to the top of the window.
Then, press Insert-Up Arrow. JAWS announces, "Microsoft Excel - Book1
Minimize Symbol Restore Symbol Close Symbol."
The focus is on the title bar.
The title bar is a horizontal bar appearing at the top edge of the program
window. The title bar lists the name of the active workbook. It also
contains the Minimize, Restore, and Close buttons. You can press Insert-T at
any time to read the workbook name in the title bar.
Minimize Button. When you activate the Minimize button, the program window
reduces to a button on the Taskbar. The Minimize button performs the same
function as the Minimize command on the Application Control menu.
Restore Button. The Restore button expands the program window to its
fullest possible size, or returns the window to its previous size after you
have maximized it. This button performs the same functions as the Restore
and Maximize commands on the Application Control menu.
Close Button. When you activate the program Close button, the program window
and Microsoft Excel program closes. The Close button performs the same
function as the Exit command on the File menu.
Step 4: Press the Down Arrow key to locate the menu bar. JAWS announces,
"Minimize Symbol Restore Symbol Close Symbol."
Step 5: Press the Down Arrow key. JAWS announces, "File Edit View
Insert Format Tools Data Window Help Type a question for help
Minimize Symbol Restore Symbol Close Symbol."
The focus is on the menu bar.
The menu bar appears below the title bar. The menu bar contains these menus:
File, Edit, View, Insert, Format, Tools, Data, Window, and Help. The Ask a
Question combo box and the document Minimize, Restore, and Close buttons
also appear on the menu bar.
Ask a Question Combo Box. You can use the Ask a Question combo box to obtain
information on the question or keyword you type in the combo box.
Minimize Button. When you activate the Minimize button on the menu bar, the
document window reduces to a button in the program window. The Minimize
button performs the same function as the Minimize command on the Document
Control menu.
Restore Button. The Restore button on the menu bar expands the document
window to its fullest possible size, or returns the window to its previous
size after you have maximized it. This button performs the same functions as
the Restore and Maximize commands on the Document Control menu.
Close Button. When you activate the program Close button on the menu bar,
the active workbook closes. The Close button performs the same function as
the Close command on the File menu.
Note: "left alt + f4" is also a close command.
Step 6: Press the Down Arrow key. JAWS reads all of the buttons on the
Standard toolbar.
The Standard toolbar appears below the menu bar. It contains buttons that
represent the most frequently used commands, such as open a file, print,
save, and cut and paste text. (You will learn how to review the Standard
toolbar with the selection cursor later in this lesson.)
Step 7: Press the Down Arrow key. JAWS reads all of the commands on the
Formatting toolbar.
The Formatting toolbar appears below the Standard toolbar. It contains
buttons that represent the most frequently used formatting commands, such as
font settings, bold, justification, and indent. (You will learn how to
review the Formatting toolbar with the selection cursor later in this
lesson.)
Step 8: Press the Down Arrow key. JAWS announces, "A1 Scroll Down
Symbol."
The focus is on the Name combo box on the Formula Bar.
The Formula Bar contains the Name combo box, Insert Function button, and an
edit field. The Name combo box lists the active cell's name or reference.
The edit field lists the contents of the active cell.
The document window appears below the Formula Bar. The document window
displays a single workbook. When you first open Excel, a new workbook opens
to a blank worksheet. The worksheet includes column and row heading bars,
cells, gridlines, and sheet tabs.
The Task Pane also appears to the right of the document window. The Task
Pane lists commands related to the current function. You will learn more
about the Task Pane later in this lesson.
Step 9: Press the Down Arrow key. JAWS announces, "A B C D E F G H I J K L
New Workbook."
The focus is on the line displaying the Column Heading Bar and the top of
the Task Pane.
The Column Heading Bar marks the top of the workbook in the document window.
It displays a column reference at the top of each column. Column references
run A through Z, then AA through AZ, BA through BZ, and continuing to IA
through IZ. The column reference is the first coordinate in a cell
reference.
The title "New Workbook" appears at the top of the Task Pane, indicating
commands related to creating a new workbook appear in the Task Pane.
Step 10: Press the Down Arrow key to locate the first row reference on the
Row Heading Bar. JAWS announces, "1." (Currently, 23 rows are displayed.)
The Row Heading Bar is a vertical bar that appears along the left side of
the workbook. It lists the row reference at the beginning of each row. The
row references number 1 through 65,536. The row reference is the second
coordinate in a cell reference.
Currently the worksheet grid for the first worksheet in the workbook is
displayed. The worksheet grid consists of row and column gridlines and
cells.
Below the worksheet grid are three Sheet Tabs.
Step 11: Press the Down Arrow key until JAWS announces, "Sheet1 Sheet2
Sheet3 Scroll Left Symbol Scroll Right Symbol." (As you press the Down
Arrow key JAWS will read the row reference numbers currently displayed and
the commands in the Task Pane.)
The Sheet Tabs list the name of each worksheet in the workbook. By default,
worksheets are named Sheet1, Sheet2, Sheet3, etc.
Step 12: Press the Down Arrow key to locate the status bar. JAWS
announces, "Ready."
The status bar provides information about some selected commands or
information about an operation in progress. The right side of the status bar
indicates whether keys such as the Caps Lock, Scroll Lock, or Num Lock are
active. When you are not performing a task, the status bar lists "Ready"
indicating you can enter new data or execute a command. To read the status
bar, press Insert-Page Down.
Step 13: When you are finished reviewing the window, press the Plus key to
activate the PC cursor.
What You Learned. In this topic, you learned:
You can review the Excel program window using the JAWS Cursor and the Up and
Down Arrow keys.
The Excel program window contains the following elements:
Title Bar
Program Resize and Close Buttons
Menu Bar
Document Resize and Close Buttons
Standard Toolbar
Formatting Toolbar
Formula Bar
Task Pane
Document Window that displays the workbook's Column Heading Bar, Row Heading
Bar, Worksheet Grid, and Sheet Tabs
Status Bar
You can press Insert-T to read the title bar. To read the status bar, press
Insert-Page Down.
(End of lesson)
Other related posts:
