[vip_students] Re: Excel Tutorial:Lesson 12, Saving files, Part 2.

  • From: "noreenmeagher" <noreenmeagher@xxxxxxxxxx>
  • To: <vip_students@xxxxxxxxxxxxx>
  • Date: Thu, 29 Mar 2007 22:47:21 +0100

Hi Paul,
This is XL lesson 12, part 2. I don't think we got lesson 12, Part 1 unless I overlooked it?
Thanks,
Noreen M.
----- Original Message ----- From: "NCBI Technical Support" <paul.traynor@xxxxxxx>
To: <vip_students@xxxxxxxxxxxxx>
Sent: Wednesday, March 28, 2007 9:01 AM
Subject: [vip_students] Excel Tutorial:Lesson 12, Saving files, Part 2.


Exercise: Saving a New Workbook
Complete the following eight steps to save your new workbook.

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

Step 2:  Press Alt-F to pull down the File menu. JAWS announces, "Menu
Active  New Dot Dot Dot Ctrl+N."

Step 3:  Select the Save As command by pressing the Down Arrow key until
JAWS announces, "Save As Dot Dot Dot  A." Then, press Enter to execute the
Save As command.

The Save As dialog box appears. JAWS announces, "Save As Dialog File Name:
Edit Combo  Book1.xls."

A selection cursor appears around the default name (Book1.xls) in the File
Name field. The dialog box is prompting you to assign a name and specify the
drive and folder in which you want to save the workbook.

Step 4: Type Budget 2003 in the File Name field. (You can include spaces in
the name.)

Your name replaces the name offered by Excel.

Step 5:  Press Insert-Tab to read the workbook name in the File Name field
again. JAWS announces, "File Name: Edit Combo  Budget 2003  To set the
value, use the Arrow keys or type the value." (Excel adds .xls to the name
when you save it.)

Step 6: Move to the Save In combo box by pressing Tab until JAWS announces,
"Save In: Combo Box  My Documents."

If the My Documents folder is not selected, press Alt-Down Arrow to open the
combo box. Press the Down Arrow key until JAWS announces, "My Documents."
Then, press Enter to open the My Documents folder.

The contents of the My Documents folder appear in the list view.

The name of your workbook is Budget 2003.xls. You are saving the workbook in
the My Documents folder on the C drive.

Step 7:  Press Tab until the Save button is selected. Then, press Enter to
activate the button.

JAWS does not indicate that Excel is saving your workbook. However, it
announces, "Budget 2003.xls Sheet1 A1," when Excel is finished saving your
workbook.

Step 8: Press Insert-T to read the title bar. JAWS announces, "Title Equals
Microsoft Excel - Budget 2003.xls."

Notice that the name of your workbook appears in the title bar.


Exercise: Quick Saving an Existing Workbook
You can use the keystroke Ctrl-S to save the Budget 2003.xls quickly. This
method is the best way to save a workbook that you have saved at least once.

Complete the following six steps to add data and then save the workbook
again.

Step 1: Press Insert-T to read the title bar. JAWS announces, "Title Equals
Microsoft Excel - Budget 2003.xls."

Step 2: Move the selection cursor to cell A8 by pressing the Down Arrow key
until JAWS announces, "Blank  A8."

Step 3:  In cell A8, type April. Then, press the Right Arrow key to accept
the data and move to cell B8. JAWS announces, "Blank  B8".

Step 4:  In cell B8, type 1650. Then, press Enter to accept the new data.

Step 5:  Press Ctrl-Home to move to cell A1. JAWS announces, "First Cell
Budget 2003  A1."

Step 6:  Press Ctrl-S to save the workbook.

Excel saves the Budget 2003.xls file with the new data. (JAWS does not
indicate that Excel saved the workbook.)


Exercise: Saving a Workbook Under a New Name
If you would like to save an existing workbook with another name or in a new
location, use the Save As command.

Remember, when you use the Save As command, the existing workbook remains
intact. Any changes you made to the workbook are reflected in the workbook
that you created using the Save As command.

Complete the following seven steps to save the information in Budget
2003.xls in a new workbook with another name.

Step 1:  Press Insert-T to verify Budget 2003.xls is the active workbook.
JAWS announces, "Title Equals  Microsoft Excel - Budget 2003.xls."

Step 2: Press Alt-F to pull down the File menu. Then, press A to choose the
Save As command.

The Save As dialog box appears. JAWS announces, "Leaving Menus  Save As
Dialog  File Name: Edit Combo Budget 2003.xls." A selection cursor appears
around the name Budget 2003.xls in the File Name field.

The Save As dialog box is prompting you to assign a name and specify the
drive and folder in which you want to save the workbook.

Step 3: Move to the Save In combo box by pressing Tab until JAWS announces,
"Save In: Combo Box  My Documents."

The file will be saved in the My Documents folder. Because you want the file
saved in this folder you do not need to select a different drive.

Step 4:  Move the focus to the File Name field by pressing Tab until JAWS
announces, "Save As Dialog  File Name: Edit Combo  Budget 2003.xls."

Step 5:  Assign a new name to the workbook by typing Expenses in the File
Name field. Excel replaces Budget 2003.xls with Expenses. To verify, press
Insert-Tab.

Step 6:  Press Tab until the Save button is selected. Then, press Enter to
activate the Save button

JAWS does not indicate that Excel is saving your workbook. However, it
announces, "Expenses.xls  Sheet1  Budget 2003  A1," when Excel is finished
saving the workbook.

Excel automatically closes the Budget 2003.xls workbook. Expenses.xls is the
active workbook.

Step 7: Press Insert-T to verify Expenses.xls is the active workbook. JAWS
announces, "Title Equals  Microsoft Excel - Expenses.xls."


What You Learned.  In this topic, you learned:

You should save your workbooks frequently.

You must follow naming guidelines when you assign a name to a workbook.

You should let Excel supply the default extension for Excel workbooks, which
is .xls. You can use the default extension by simply typing a name for the
workbook in the File Name field of the Save As dialog box.

To open the Save As dialog box, choose the Save As command on the File menu.

You use the Save As dialog box the first time you save a workbook and when
you want to save an existing workbook with a new name or in a new location.

In the Save As dialog box, make sure you selected the correct drive in the
Save In combo box, opened the correct folder in the list box, and assigned a
valid name in the File Name field.

To save a workbook quickly, press Ctrl-S to activate the Save command. (Use
the Save command when you do not want to change the workbook's name or
location.)



********************************************************************

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


********************************************************************







--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.20/736 - Release Date: 27/03/2007 16:38



Other related posts: