Topic: Opening Excel Topic: Excel 2002 or later or later Settings Topic: The Excel Program Window Topic: Using Toolbars Topic: About the Task Pane Topic: About the Adjust JAWS Verbosity Dialog Box Topic: Exiting Excel JAWS 's Tutor Messages. Tutor messages provide you with keystroke and navigation information when you select a menu, menu command, or dialog box field. JAWS reads this information when you are using the Beginner level verbosity setting. If you would like to turn off the tutor messages, complete the following five steps: Step 1: Press Insert-J to open the JAWS program window. JAWS announces, "JAWS." Step 2: Press Alt-O to pull down the Options menu. JAWS announces, "Menu Active Basics Dot Dot Dot." Then, press Enter to choose the Basics command. The Basic Settings dialog box appears. JAWS announces, "Leaving Menus Basic Settings Dialog Tutor Messages Announce Menu and Control Help Radio Button Checked 1 of 3 To change the selection, use the Arrow keys." Step 3: Press the Down Arrow key until JAWS announces, "Tutor Messages Turn Off Menu and Control Help Radio Button Checked 2 of 3." Step 4: Press Tab until the OK button is selected. Then, press Enter. The Basic Settings dialog box closes. JAWS announces, "JAWS." Step 5: Minimize the JAWS program window by pressing Alt-Spacebar to pull down the Application Control menu. Then, press N to choose the Minimize command. JAWS announces, "Leaving Menus." JAWS will no longer read tutor messages when you select a menu, menu command, or dialog box field. It will, however, continue to read the tutor message when you press Insert-Tab to read the current field, menu, or menu command. Helpful Keystrokes. Here are some keystrokes that you may find helpful as you work through this tutorial. To read the selected cell position, press Insert-C To read the selected cell's data, press Numpad 5 key. To read active worksheet and cell, press Insert-Tab. To spell the text in the selected cell, press and hold the Insert key. Then, press the Numpad 5 key twice rapidly. Topic: About Excel Introduction. Excel 2002 or later is a spreadsheet program developed and distributed by Microsoft(R) Corporation. Spreadsheet programs, like Excel, are popular because they allow you to easily edit data, establish relationships between data, and perform calculations. Using Excel, you can manipulate data to compare financial outcomes or establish projected costs. Excel is often used by businesses to figure profits and expenses, and by individuals to create budgets and project various loan payment scenarios. Excel can also be used to track and analyze large lists of related data, such as customer information or product orders. Excel Terms. In order to use Excel effectively, you should be familiar with the following terms: Workbook. A workbook is the file that stores your worksheet data. A single workbook can contain up to 256 worksheets. By default, a new workbook contains only 3 worksheets. Worksheet. A worksheet is the document where you enter your data. A worksheet is laid out as a grid, consisting of a series of columns and rows. Gridlines mark the boundaries of the rows and columns. A single worksheet has 256 columns and 65,536 rows. Cell. A cell is a rectangular area formed by the intersection of row and column gridlines. You enter a single piece of data into each cell. The data is usually text, a numeric value, or a formula. Cell Reference. A cell reference is the column and row coordinates for a cell. By default, a cell reference uses a letter to indicate the column and a number to indicate the row. For example, the cell reference A3 indicates the cell at column A, row 3; the cell reference CA102 indicates the cell at column CA, row 102. Note: In some instances, a cell reference may be expressed with a number used for both the column and the number. This reference style is known as the R1C1 reference style. Using cell A1 as a starting point, the number following "R" indicates the number of rows from row one. The number following "C" indicates the number of columns from column A. This style is most commonly used in Excel macros. You will not use the R1C1 reference style in this tutorial. What You Learned. In this topic, you learned: Excel 2002 or later is a spreadsheet program that allows you to easily edit data, establish relationships between data, perform calculations, and manage lists of data. Using Excel, you can manipulate data to compare financial outcomes, establish projected costs, or analyze data. A workbook is the file that stores your worksheet data. By default, a new workbook contains 3 worksheets. A workbook can contain up to 256 worksheets. A worksheet is the document where you enter your data. A worksheet is laid out as a grid, consisting of a series of columns and rows. (A single worksheet has 256 columns and 65,536 rows.) A cell is a rectangular area formed by the intersection of row and column gridlines. You enter a single piece of data into each cell. A cell reference is the column and row coordinates for a cell. Excel expresses the cell reference in two ways: the A1 reference style and the R1C1 reference style. In this tutorial you will only use the A1 (column letter, row number) reference style.----- Original Message ----- From: "Kathleen Doyle" <doylekay@xxxxxxxxxxxxxxxx>
To: <vip_students@xxxxxxxxxxxxx> Sent: Friday, March 23, 2007 5:57 PM Subject: [vip_students] Re: Feedback info required!
Hi Paul, Yes, I think the Excel lessons are a great idea. However, as I am only a member for a short time, I missed lesson 1, 2, and 3. I would be grateful if you could let me have them or let me know how to access the archives so that I can locate them there.Best wishes, 7Kathleen Doyle.----- Original Message ----- From: "NCBI Technical Support" <paul.traynor@xxxxxxx>To: <vip_students@xxxxxxxxxxxxx> Sent: Friday, March 23, 2007 3:38 PM Subject: [vip_students] Feedback info required!Hi All,I just wondered how many of you have taken on the excel challenge?. I wouldlike to hear from anyone who has done something with the lessons I have sent out and tell me what they thought about them. I would be very interested to know. If you haven't managed to get round to them just yet,tell me if you think at least they are a good idea and if they are useful.Regards, Paul. ******************************************************************** 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.17/731 - Release Date: 23/03/2007 15:27