1.        Worksheets Worksheets allow you to enter, calculate, manipulate, and analyze data such as numbers and text.

2.        Charts Charts pictorially represent data.

3.        Databases Databases manage data.

4.        Web Support Web support allows Excel to save workbooks or parts of a workbook in HTML format so they can be viewed and manipulated using a browser.

5.        Workbook the workbook is like a notebook.

6.        Worksheets inside the workbook are work sheets.

7.        Each sheet name displays on a sheet tab at the bottom of the workbook.

8.        A column letter above the grid, also called the column heading, identifies each column.

9.        A row number on the left side of the grid, also called the row heading, identifies each row.

10.     A cell is the basic unit of a worksheet into which you enter data.

11.     A cell is referred to by its unique address, or cell reference, which is the coordinate of the intersection of a column and a row.

12.     One cell on the worksheet, designated the active cell, is the one in which you can enter data.

13.     First, a heavy border surrounds the cell; second, the active cell reference displays immediately above column A in the Name Box.

14.     The horizontal and vertical lines on the worksheet itself are called gridlines.

15.     The mouse pointer displays as a block plus sign whenever it is located in a cell on the worksheet.

16.     You view the portion of the worksheet displayed on the screen through a worksheet window.

17.     Below and to the right of the worksheet window are scrollbars, scroll arrows, and scroll boxes that you can use to move the window around to view different parts of the active worksheet.

18.     To the right of the sheet tabs at the bottom of the screen is the tab split box.

19.     The menu bar that displays when you start Excel is the worksheet menu bar.

20.     When you click a menu name on the menu bar, a short menu displays listing the most recently used commands.

21.     The full menu lists all the commands associated with a menu.

22.     A recessed command is a hidden command because it does not display on a short menu.

23.     A dimmed command displays in a faint type, which indicates it is not available for the current selection.

24.     If you are working with a chart sheet rather than a worksheet. The chart menu bar displays with menu names that reflect charting commands.

25.     Also, when you move the mouse pointer over a button or box, the name of the button or box displays below it in a screen tip.

26.     An alternative to sliding one toolbar over another is to use the more buttons button on a toolbar to display the buttons that are hidden.

27.     As you type, the data displays in the formula bar.

28.     Excel also displays the active cell reference on the left side of the formula bar in the name box.

29.     The status bar displays a brief description of the command selected.

30.     Mode Indicators such as Enter and Ready, display on the status bar and specify the current mode of Excel.

31.     When the mode is Ready, Excel is ready to except the next command or data entry.

32.     When the mode indicator reads Enter, Excel is in the process of accepting data through the keyboard into the active cell.

33.     The Auto-Calculate area can be used in place of a calculator to view the sum, average, or other types of totals of a group of numbers on the worksheet.

34.     Keyboard indicators, such as NUM, CAPS, and SCRL show which keys are engaged.

35.     The easiest way to select a cell is to use the mouse to move the block plus sign to the cell and then click.

36.     An alternative method is to use the arrow keys that are located just to the right of the typewriter keys on the keyboard.

37.     In Excel, any set of characters containing a letter, hyphen, or space is considered text.

38.     Clicking the Enter Box completes the entry.

39.     Clicking the cancel box cancels the entry.

40.     Left-Aligned means the cell entry is positioned at the far left in the cell.

41.     If you type the wrong letter and notice the error before clicking the Enter box or pressing the Enter Key, use the Backspace Key to erase all the characters back to and including the one that is wrong.

42.     To cancel the entire entry before entering it into the cell, click the cancel box in the formula bar or press the Esc Key.

43.     The autocorrect of Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell.

44.     Number can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - () , / . $ % E e.

45.     The Numbers in row 3 are right aligned, which means Excel displays the cell entry to the far right in the cell.

46.     Excels SUM function provides a convenient means to accomplish this task.

47.     Then, you can use the AutoSum button. On the standard toolbar to enter the SUM function as shown in the following steps.

48.     A range is a series of two or more adjacent cells in a column or row or a rectangular group of cells.

49.     The cell being copied is called the copy area.

50.     The range of cells receiving the copy is called the paste area.

51.     Each adjusted cell reference is called a relative reference.

52.     The fill handle is the small black square located in the lower right corner of the heavy border around the active cell.

53.     The heavy border and transparent background is called see-through view.

54.     You format a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

55.     The font type defines the appearance and shape of the letters, numbers, and special characters.

56.     The font size specifies the size of the characters on the screen.

57.     A single point is about 1/72 of one inch in height.

58.     Thus, a character with a point size of 10 is about 10/72 of one inch in height.

59.     Font style indicates how the characters are formatted.

60.     You bold an entry in a cell to emphasize it or make it stand out from the rest of the worksheet.

61.     Follow these steps to format the range A2:F7 automatically using the Auto format command on the format menu.

62.     The close button terminates current activity without making changes.

63.     You can also use the cancel button, immediately below the OK button, for this purpose.

64.     Use the question mark button, to obtain help on any box or button located in the dialog box.

65.     The options button allows you to select additional formats to assign as part of the selected customized format.

66.     The 3-d column chart is called an embedded chart because it is drawn on the same worksheet as the date.

67.     Excel derives the scale along the vertical axis (also called the y-axis or value axis) of the chart on the basis of the values in the worksheet.

68.     With the range to chart selected, you click the chart wizard button on the standard toolbar to initiate drawing the chart.

69.     The area on the worksheet where the chart displays is called the chart location.

70.     The small sizing handles at the corners and along the sides of the selection rectangle indicate the chart is selected.

71.     Excel automatically selects the entries in the topmost row of the range as the titles for the horizontal axis (also called the x-axis or category axis) and draws a column for each of the 16 cells in the range containing numbers.

72.     The legend identifies each bar in the chart.

73.     The default chart type is the chart Excel draws if you click the finish button in the first chart Wizard dialog box.

74.     A saved workbook is referred to as a file or workbook.

75.     When you click the tools button in the save as dialog box, a list box displays.

76.     The general options command in the list allows you to save a back up copy of the workbook, create a password to limit access to the workbook, and carry out other functions that will be discussed later.

77.     Saving a backup workbook means that each time you save a workbook, Excel copies the current version of the workbook on disk to a file with the same name, but with words, Backup of, appended to the front of the file name.

78.     You also can use the general options command on the tools list to assign a password to a workbook so others cannot open it.

79.     Case Sensitive means Excel can differentiate between uppercase and lowercase letters.

80.     The History button displays a list of shortcuts to the most recently used files in a folder titled recent.

81.     A printed version of the worksheet is called a hard copy or printout.

82.     The range of cells you choose to print is the print area.

83.     You can easily obtain a total, an average, or other information about the numbers in a range by using the auto calculate are on the status bar.

84.     If the entry in the cell is long and the errors are minor, the edit menu may be a better choice.

85.     This editing procedure is called in-cell editing because you can edit the contents directly in the cell.

86.     You can also use the mouse to drag through the character or adjacent characters you want to delete and then press the DELETE key or click the cut button on the standard toolbar.

87.     In insert mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.

88.     In overtype mode, Excel overtypes the character to the right of the insertion point.

89.     Excel provides the undo command on the edit menu and the undo button on the standard toolbar that you can use to erase most recent cell entry.

90.     The redo button allows you to repeat previous actions.

91.     Never press the SPACEBAR to clear a cell.

92.     Be aware, however, that the cut button or cut command not only deletes the contents from the range, but also copies the contents of the range to the office clipboard.

93.     You also can clear and unsaved workbook by clicking the workbooks close button or by clicking close on the file menu.

94.     The select all button selects the entire worksheet.

95.     If you close the workbook, click the new button on the standard toolbar or click new on the file menu to begin working on the next workbook.

96.     This tip feature is part of the IntelliSense technology that is built into Excel, which understands what you are trying to do and suggests better ways to do it.

97.     Absolute cell reference Use this if you do not want the cell reference to change when the formula is moved or copied to a new cell. You need to insert a $ sign before the column letter and/or the row number of the cell reference you want to stay the same.

98.     Argument is a value, cell reference, range, or text that is enclosed in parentheses after the function name.

99.     Ascending Order Sorts alphabetically from A to Z and numerically from the lowest to the highest number.

100.  Column Labels Alphabetical labels horizontally above the columns that help you identify what column you are in.

101.  Descending order Sorts alphabetically Z to A and numerically from the highest to the lowest number.

102.  Equal Sign Tells Excel that a formula follows.

103.  Formulas An equation used to calculate values in a cell.

104.  Function Is an Excel tool that makes it easy to perform a calculation. It contains 3 parts the equal sign, the function name and the arguments.

105.  Function Formula Names a function instead of using operators when creating a formula.

106.  Function name Tell Excel what to do the data in a formula.

107.  Landscape orientation prints sideways with the long edge of the page at the top.

108.  Logical functions Are used to display text or values when certain conditions exist.

109.  Merge You combine several cells into a single cell.

110.  Merge & center button Combines several cells into one and centers the text horizontally within that cell.

111.  Mixed cell reference When you use a combination of both relative and absolute cell references.

112.  Operand Is a number or cell reference within a formula.

113.  Operator is a symbol that tells Excel what mathematical operation to perform with the operands in a formula.

114.  Order of evaluation The order in what formulas are evaluated.

115.  Portrait orientation Prints with the short edge of the page at the top. This is the default setting.

116.  Relative cell reference When a formula is copied to another cell, the cell references will be adjusted relative to the formulas new location.

117.  Row labels Numeric labels vertically along the left side of your screen that helps you identify what row you are in.

118.  Spreadsheet Is a grid of rows and columns containing numbers, text and formulas.

ALT + PAGE DOWN   Selects the cell one window to the right and moves the window accordingly.

ALT + PAGE UP                     Selects the cell one window to the left and moves the window accordingly

ARROW                                 Selects the adjacent cell in the direction of the arrow key.

CTRL + ARROW                   Selects the border cell of the worksheet in combination with the arrow keys and moves the window accordingly.

CTRL + HOME                      Selects cell A1 or the cell one column and one row below and to the right of frozen titles and moves the window accordingly.

Find command on edit menu                Finds and selects a cell the contains specific contents that you enter in the find dialog box. If necessary, Excel moves the window to display the cell. You can press SHIFT + F5 or CTRL + F to display the find dialog box.

F5                            Selects the cell that corresponds to the cell reference you enter in the go to dialog box and moves the window accordingly. You can press CTRL + G to display the find dialog box.

Home                      Selects the cell at the beginning of the row that contains the active cell and moves the window accordingly.

Name Box                Selects the cell in the workbook that corresponds to the cell reference you enter in the Name box.

Page Down                Selects the cell down one window form the active cell and moves the window accordingly.

Page up  Selects the cell up one window from the active cell and moves the window accordingly.