[vip_students] Excel Lesson 3:Preparing the excel menus.
- From: "Lists" <lists@xxxxxxxxxxxxxxx>
- To: <vip_students@xxxxxxxxxxxxx>
- Date: Tue, 6 Mar 2007 10:12:14 -0000
Topic: Excel 2002 or later Settings
Introduction. Excel uses shortened menus and toolbars that initially only
list the most commonly used commands.
Note:Such menus are known as "selective menus". If you have used windows XP
then go into the programs menu and arrow through it, you will notice
sometimes that items you feel should be there in the menus are not. However
if you persist in down arrowing through the menus eventually those items
will reappear, this is selective menus at work and you now see them in
applications such as in excel and word.
As you work with Excel, the commands that you use most often will move to
the top of the menu. Those commands that you don't use will be temporarily
hidden.
Note: Zoomtext, Lunar and Supernova users, (You must choose the double arrow
button at the bottom of the menu to expand the menu and display all of the
commands.)
Jaws, hal and window eyes users, Using the down arrow should work.
Also, Excel may use shortened Standard and Formatting toolbars. To access
additional toolbar buttons, you must choose the Toolbar Options button.
The menus and toolbars will continually adjust themselves to reflect those
commands you use most often.
For consistency throughout the tutorial, you will turn off these features so
that Excel will always show the full set of commands for each menu and
toolbar. If you want to use the personalized menus and toolbars, activate
the personalized settings again once you have completed the tutorial.
Note: I think however you should leave what settings you make now alone
afterwards as they tend to be easier to use.
Exercise Objective. In the following exercise, you will turn off Excel's
customize toolbars and menus feature.
Exercise: Turning Off Excel's Customize Commands Feature
Complete the following seven steps to turn off Excel's customize toolbars
and menus feature.
Step 1: Press Insert-T to verify that Excel is the active program. JAWS
announces, "Title Equals Microsoft Excel - Book1."
Step 2: Press Alt-T to pull down the Tools menu. JAWS announces, "Menu
Active Spelling Dot Dot Dot F7."
Step 3: Press the Up Arrow key until JAWS announces, "Customize Dot Dot
Dot C." Then, press Enter to activate the Customize command.
The Customize dialog box appears. JAWS announces, "Leaving Menus Customize
Dialog," followed by the selected field.
The Customize dialog box has three tabbed pages: Toolbars, Commands, and
Options.
Note: You can move between tabs by using the keys "Control + Tab"
Step 4: Press Alt-O to verify the Options tabbed page is the active tabbed
page. JAWS announces, "Options Tab."
Step 5: Press Tab to move to the Show Standard and Formatting Toolbars on
Two Rows check box. JAWS announces, "Show Standard and Formatting Toolbars
on Two Rows Check Box Checked."
If JAWS indicates that the check box is not checked, press the Spacebar to
check it. Then, go to Step 6. (You can press Insert-Tab again to verify that
it is checked.)
If JAWS indicates that the check box is checked, go to Step 6.
Step 6: Press Tab to move to the Always Show Full Menus check box. JAWS
announces, "Always Show Full Menus Check Box Not Checked."
If JAWS indicates that the check box is not checked, press the Spacebar to
check it. Then, go to Step 7. (You can press Insert-Tab again to verify that
it is checked.)
If JAWS indicates that the check box is checked, go to Step 7.
Step 7: Press Tab until JAWS announces, "Close Button." Then, press Enter
to activate the button.
The Customize dialog box closes. JAWS announces, "Blank A1."
What You Learned. In this topic, you learned:
Excel may use shortened menus and toolbars that only list the most commonly
used commands. Other commands are temporarily hidden. The menus and toolbars
continually adjust themselves to reflect those commands you use most often.
You turned off the personalized features so that Excel will always show the
full set of commands for each menu and toolbar. (Once you have completed the
tutorial, you can activate the personalized settings again.)
To turn off the personalized menus and toolbars feature, choose the
Customize command on the Tools menu. Make sure the Show Standard and
Formatting Toolbars on Two Rows, and Always Show Full Menus check boxes are
checked.
-----Original Message-----
From: vip_students-bounce@xxxxxxxxxxxxx
[mailto:vip_students-bounce@xxxxxxxxxxxxx] On Behalf Of O'Neill, Tom
Sent: 06 March 2007 09:14
To: vip_students@xxxxxxxxxxxxx
Subject: [vip_students] Re: Excel Tutorial: What is a spread sheet?
Paul
More and more of my work is appearing on excel spread sheets so anything you
put out will be useful Keep it in English though as little computer jargon
as you can Tom
-----Original Message-----
From: vip_students-bounce@xxxxxxxxxxxxx
[mailto:vip_students-bounce@xxxxxxxxxxxxx]On Behalf Of noreenmeagher
Sent: 03 March 2007 23:50
To: vip_students@xxxxxxxxxxxxx
Subject: [vip_students] Re: Excel Tutorial: What is a spread sheet?
*************************************
This e-mail has been received by the Revenue Internet e-mail service.
*************************************
Hi Paul,
This would be great as XL/Jaws has changed a lot since I did my ECDL and
though I have not been using it much I now find I need to use it more.
Keep up the great work.
Noreen
----- Original Message -----
From: "Lists" <lists@xxxxxxxxxxxxxxx>
To: <vip_students@xxxxxxxxxxxxx>
Sent: Saturday, March 03, 2007 1:17 PM
Subject: [vip_students] Excel Tutorial: What is a spread sheet?
> Hi All, it has been on my mind for some time now to just go through
> the basics of excel with you all. Please let me know if you feel this
> is useful as I am not sure how many of you would even use excel but
> even if you don't it is good to know what excel is and what it does.
>
> of a spread sheet:A spreadsheet is a sheet of paper that shows
> accounting or other data in rows and columns; a spreadsheet is also a
> computer application program that simulates a physical spreadsheet by
> capturing, displaying, and manipulating data arranged in rows and
> columns. The spreadsheet is one of the most popular uses of the
> personal computer.
>
> Okay now that we have some idea of what the spread sheet is, we can
> simply call excel a "spread sheet program".
>
> Most people will have the program "Excel" on their computers, if you
> have then go into the "start menu, programs" and arrow down till you find
it.
> If you don't find it directly in the programs menu then you may find
> that arrowing down through the programs menu till you come to a
> "Microsoft Office" sub menu then right arrowing into it and down
> arrowing will locate it for you. When you come to it, just press the
"enter key".
>
> When excel opens up you will be presented with lots and lots of
> rectangular shapes called cells. These cells are both numbered and
> alphabetized.
> Numbers run down the left hand side of the excel page, while letters
> run across the top of the page.
>
> For example you have the first cell on a spread sheet designated "cell A1"
> the cell to the right of this cell is called "Cell B2" and the cell
> directly beneath cell A1 is "Cell A2"
>
> Now you can try out this for yourselves and just get a feel for the
> page you are working in. As we go along, I will try and explain
> useful shortcut keys which you can use within the Excel program both
> jaws specific keys and excel specific keys. They will all combine to
> help you use it more effectively.
> I will wherever necessary try and also include those using
> magnification if I feel it is necessary.
>
> Regards for now,
>
> Paul.
>
>
>
> I've stopped 143 spam and fraud messages. You can too!
> Free trial of spam and fraud protection at http://www.cloudmark.com/sig/?
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.6/709 - Release Date:
> 03/03/2007
> 08:12
>
>
************************
This message has been delivered to the Internet by the Revenue Internet
e-mail service
*************************
Other related posts:
- » [vip_students] Excel Lesson 3:Preparing the excel menus.
