Excel Vocabulary

32. Number Formatting

- Excel offers many options for adjusting the way numbers appear on the screen by changing their formatting. Some examples include: General-1234.4321 Currency- $ 1,234.43 Accounting- $ 1234.43

15. Column Letter-

A column letter is the letter of the alphabet that designates a specific column.

21. Dollar Sign($) -

In addition to indicating a currency value, a dollar sign designates an absolute cell address in an Excel formula.

8. Cell address-

A cell address is the location of a cell on a worksheet and is defined by the column letter and the row number. For example, cell A1 is where column A and row 1 intersect.

7. Cell

A cell is the intersection of a row and a column. A cell can contain a label, a numeric value, or a formula.

9. Cell references-

A cell reference, or cell address, identifies a particular cell, such as cell B5. Cell references are used in formulas to indicate where a value is stored.

13. Colon Symbol-

A colon symbol inserted between two cell references in a formula defines a range of adjacent cells. You can think of it as meaning "through" as in saying, "cells C3 through G76. The following are examples of range references using the colon : C3:G7

22. Field-

A field is a cell in a database that contains information. In Excel, fields appear in columns. For example, fields in a Customer database might include Name, Address, and Zip Code.

25. Formulas

A formula is an expression entered in a cell that performs numeric calculation, logical comparison, or text string manipulation

26. Functions

A functions is a preset formula. Functions consist of the function name and its arguments . The function name tells Excel what calculation you want it to perform.

28. Label-

A label is any cell entry other than a numeric value or a formula. A text entry in a cell is called a label. A range of values will often have a label to identify it.

37. Range Address-

A range address identifies a range by the cells located at diagonally opposed corners. For example, F3:G59 identifies a range that starts in cell F3 at the upper left and extends through cell G59.

36. Range

A range is a block of cells that can be selected, manipulated, named, or formatted as a group.

43. Workbook-

A workbook is the Excel file that stores your information. Each workbook may contain numerous worksheets

44. Worksheet-

A worksheet is an electronic spreadsheet that lets you enter, analyze, and calculate data. Within a workbook, worksheets can share information, and calculations pertaining to several worksheets can be performed at one time. The default number of worksheets in a new workbook is three.

42. SUM-

Adds the values in the function argument or the values in the cell references in the argument.

4. AutoFill-

AutoFill is the Excel feature that allows you to automatically copy cells and fill them with a series without using Copy.

6. Borders

Borders are line effects that you can place around cells or cell ranges to improve the appearance of effectiveness of your worksheets.

12. Charts-

Charts are graphic presentations of data from a worksheet

16. Column Width-

Column width is measured as the number of characters that can fit in the column.

17. Columns-

Columns are the vertical divisions of a worksheet that are identified by letters.

34. Parenthesis in Formulas

Excel performs calculations inside parentheses before other operations in a formula. For example, in the formula (B3=2)*4, Excel will first add B3+2, then multiply the result by 4.60.

27. Gridlines

Gridlines are lines on a chart that can make critical data comparisons easier. Some charts, such as 3-D pie chart, don't need gridlines. 28. Label- A label is any cell entry other than a numeric value or a formula. A text entry in a cell is called a label. A range of values will often have a label to identify it.

29. Legends-

Legends provide a key to the data illustrated in a chart.

33. Operators-

Operators are used to tell Excel what mathematical functions to perform in a formula. The following symbols are the operators which are used most often in Excel formulas: Addition (+) Subtraction (-) Multiplication(*) and Division (/)

5. Average-

Provides the average of the range of references in the argument.

18. Count-

Returns a count of the number of items in the range in the argument.

30. MAX

Returns the largest value in the range in the argument.

31. MIN-

Returns the smallest value in the range in the argument.

39. Rows-

Rows are the horizontal divisions of a worksheet that are identified by numbers.

40. Sheet Tabs

Sheet tabs contain the names of the worksheets in a workbook at the bottom of the working screen. You can click the sheet tabs to show their corresponding worksheets.

41. Spreadsheets

Spreadsheet is the generic term for applications, such as Excel, that you can use to enter, analyze, and calculate data. It performs mathematical calculations and projections based on data entered. Common spreadsheet uses include analysis, charting, and budgeting

1. 3-D Pie Chart

The 3-D pie chart is a simple chart style that is useful for illustrating the parts of a whole.

10. Chart Title-

The Chart Title function of Chart Wizard allows you to create a title as part of the chart instead of creating a cell label for it on the worksheet.

3. ALT-

The [ALT] (or Alternate) key on the keyboard is used in conjunction with other keys and mouse actions to perform various commands and functions.

2. Active Cell-

The active cell contains the insertion point and is identified by a dark border around the cell. Its address is shown in the formula bar. Any action you perform is performed on the active cell.

14. Column Headings

The column headings are the grey boxes containing sequential letters at the top of the worksheet. They can be used to select or identify a column.

19. Currency Format-

The currency format places dollar signs and comma separators in numeric entries. Negative currency values are displayed in parentheses.

20. Data Range-

The data range is the area of the worksheet that you want to chart. It includes any numeric data that you want to chart and can include the titles for the data.

23. Fill Handle-

The fill handle is a black symbol in the lower right corner of the active cell. Clicking-and-Dragging the fill handle can copy cell contents or create a series. If Excel recognizes the cell contents as a series, it will continue the series. If Excel doesn't recognize the cell contents as a series, it will copy the contents to the other cells.

24. Formula Bar-

The formula bar is located under the toolbars at the top of the working screen. It contains the edit line for working with formulas, and provides information regarding cell addresses

35. Print Area-

The print area is the range of cells that you have specifies to print. If you do not set a print area, Excel will print the range of worksheet that contains data.

38. Row Headings-

The row headings are the gray boxes containing sequential numbers along the left side of the worksheet. They can be used to select or identify a row.

11. Chart Toolbar-

Use the Chart toolbar to make changes to your chart quickly.