[vip_students] Excel Tutorial: Lesson 4, reviewing the excel window!
- From: "Edel Carey" <careyedel@xxxxxxxxxx>
- To: <vip_students@xxxxxxxxxxxxx>
- Date: Mon, 14 May 2007 21:35:05 +0100
----- Original Message -----
From: Loretta Conaty
To: careyedel@xxxxxxxxxx
Sent: Monday, April 23, 2007 8:57 AM
Subject: FW: [vip_students] Excel Tutorial: Lesson 4, reviewing the excel
window!
--------------------------------------------------------------------------------
From: vip_students-bounce@xxxxxxxxxxxxx
[mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of Lists
Sent: 09 March 2007 17:00
To: vip_students@xxxxxxxxxxxxx
Subject: [vip_students] Excel Tutorial: Lesson 4, reviewing the excel window!
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)
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.463 / Virus Database: 269.5.7/771 - Release Date: 21/04/2007 11:56
Other related posts:
