[vip_students] Fw: Excel Tutorial: Lesson 6, The Task Pain!

  • From: "Edel Carey" <careyedel@xxxxxxxxxx>
  • To: <vip_students@xxxxxxxxxxxxx>
  • Date: Mon, 14 May 2007 21:35:26 +0100

----- Original Message ----- 
From: Loretta Conaty 
To: careyedel@xxxxxxxxxx 
Sent: Monday, April 23, 2007 8:57 AM
Subject: FW: [vip_students] Excel Tutorial: Lesson 6, The Task Pain!






--------------------------------------------------------------------------------
From: vip_students-bounce@xxxxxxxxxxxxx 
[mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of Lists
Sent: 11 March 2007 12:52
To: vip_students@xxxxxxxxxxxxx
Subject: [vip_students] Excel Tutorial: Lesson 6, The Task Pain!


Topic: About the Task Pane

 

Introduction.  The Task Pane is a new feature in Excel 2002 or later . The Task 
Pane displays commands related to frequently used features. The contents of the 
Task Pane change, depending on the task you are performing. For instance, 
commands related to opening a workbook appear in the Task Pane when you open 
Excel.

 

The Task Pane appears next to the document window. You can move the focus to 
the Task Pane by pressing the Alt key and then Ctrl-Tab. Once in the Task Pane 
you can select commands by pressing Tab or the Arrow keys.

 

 

Exercise Objective.  In the following exercise, you will review the contents of 
the Task Pane.

 

 

Exercise: Reviewing the Task Pane

Complete the following five steps to review the contents of the Task Pane.

 

Step 1:  Press Insert-T to verify Excel is the active program. JAWS  announces, 
"Title Equals Microsoft Excel - Book1."

 

Step 2:  Press the Alt key to move the focus to the menu bar. JAWS  announces, 
"Menu Bar  File."

 

Step 3:  Move to the Task Pane by pressing Ctrl-Tab until JAWS  announces, 
"Task Pane  New Workbook  Blank Workbook Link."

 

Step 4:  Press Tab or the Down Arrow key repeatedly to review the commands in 
the Task Pane.

 

Currently, the commands in the Task Pane relate to creating a new workbook or 
opening an existing workbook. 

 

Step 5:  Press Escape to return the focus to the worksheet. JAWS  announces, 
"Leaving Task Pane  Blank  A1."

 

 

Hiding the Task Pane.  If you are no longer using the Task Pane, you can hide 
it by unchecking the Task Pane command on the View menu.  The Task Pane will 
remain hidden until you choose another feature that displays a command in the 
Task Pane or until you exit the Excel program.

 

 

What You Learned.  In this topic, you learned:

 

The Task Pane displays tasks related to frequently used features. The contents 
of the Task Pane change, depending on the task you are performing.

 

The Task Pane replaces many dialog boxes that were used in previous versions of 
Excel.

 

The Task Pane appears next to the document window.

 

You can move the focus to the Task Pane by pressing the Alt key and then 
Ctrl-Tab. Once in the Task Pane you can select commands by pressing Tab or the 
Arrow keys.

 

If you are no longer using the Task Pane, you can hide it by unchecking the 
Task Pane command on the View menu.

 

 

Topic: About the Adjust JAWS Verbosity Dialog Box

 

Introduction.  You can use the Adjust JAWS Verbosity dialog box to change 
settings that affect the amount and type of information that JAWS  reads. When 
you open this dialog box from the Excel program, it will contain settings you 
can adjust for the Excel program. For instance, you can change the amount of 
information that JAWS  reads for the selected cell. By default, JAWS  reads the 
cell's coordinates and content when you select it. You can change this setting 
so that JAWS  only reads the cell's contents.

 

JAWS  will save the changes you make to the verbosity settings. It will 
continue to use the verbosity settings you chose until you make another change.

 

This tutorial uses the default settings in the Adjust JAWS Verbosity dialog 
box. When you need to make a change, you will be directed to do so.

 

 

Exercise Objective.  In the following exercise, you will open and review the 
default settings in the Adjust JAWS Verbosity dialog box for the Microsoft 
Excel program.

 

 

Exercise: Reviewing the Adjust JAWS Verbosity Dialog Box

Complete the following five steps to review the Adjust JAWS Verbosity dialog 
box.

 

Step 1:  Press Insert-T to verify Excel is the active program. JAWS  announces, 
"Title Equals Microsoft Excel - Book1."

 

Step 2:  Press Insert-V to open the Adjust JAWS Verbosity dialog box. JAWS  
announces, "List Box Cell Verbosity  Contents plus Coordinates 1 of 25."

 

The focus is in the Adjust JAWS Verbosity list box.

 

This dialog box has a list box, Close button, and Execute button.

 

Step 3: Press Insert-Tab to read the current setting. JAWS  announces, "List 
Box  Cell Verbosity  Contents plus Coordinates 1 of 25."

 

Step 4:  Press the Down Arrow key repeatedly to review the settings.

 

To change a setting, select the setting. Then, use the Spacebar or the Execute 
button to cycle through the options. When you have selected the setting you 
prefer, change another setting or activate the Close button.

 

Step 5:  When you have finished reviewing the dialog box, press Tab until the 
Close button is selected. Then, press Enter to activate the button.

 

JAWS  accepts any changes you may have made and closes the dialog box. If you 
made changes, JAWS  will announce, "Application Settings Saved."

 

 

What You Learned.  In this topic, you learned:

 

You can use the Adjust JAWS Verbosity dialog box to change settings that affect 
the amount and type of information that JAWS  reads.

 

When you open this dialog box from the Excel program, the Adjust JAWS Verbosity 
dialog box will contain settings you can adjust for the Excel program.

 

To open the Adjust JAWS Verbosity dialog box, press Insert-V.

 

To change a verbosity setting, select the setting. Then, use the Spacebar or 
the Execute button to cycle through the options. When you have selected the 
setting you prefer, change another setting or activate the Close button.

 

JAWS  saves the verbosity settings you chose until you make another change.

 

 

Topic: Exiting Excel

 

Introduction.  This topic explains how to exit Excel. If you made changes to a 
workbook since the last time you saved it, a dialog box will prompt you to save 
it before exiting Excel. To prevent mishaps, you should always save your 
workbooks before you activate the Exit command. If you exit Excel without 
saving your workbook, you will not be able to retrieve any changed information 
in the workbook. If you created a new workbook and chose not to save it, the 
workbook is not available for future use.

 

The Exit command appears on the File menu. This tutorial directs you to use the 
keyboard shortcut Alt-F4 when exiting Excel.

 

 

Exercise Objective.  In this exercise, you will exit Excel without saving the 

Book1 workbook.

 

 

Exercise: Exiting Excel

Complete the following two steps to exit Excel without saving Book1.

 

Step 1:  Press Insert-T to verify Excel is the active program. JAWS  announces, 
"Title Equals  Microsoft Excel - Book1."

 

Step 2:  Press Alt-F4 to exit Excel. 

 

When the Excel program closes, JAWS  reads the current focus. Book1 has not 
been saved.

 

 

What You Learned.  In this topic, you learned:

 

You can press Alt-F4 to exit Excel.

 

If you made changes to a workbook since the last time you saved it, a Microsoft 
Excel dialog box appears prompting you to save the workbook before exiting 
Excel. 

 

When the Excel program closes, JAWS  reads the current focus.

 

 



--------------------------------------------------------------------------------


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:

  • » [vip_students] Fw: Excel Tutorial: Lesson 6, The Task Pain!