| A | B |
|---|
| Workbook | A spreadsheet file. It contains one or more worksheets, usually with related data. |
| Worksheet | One section in a workbook (spreadsheet file). It is where you enter information. |
| Title Bar | Displays the current worksheet and application names. |
| Workbook Close Button | Click to close the workbook. |
| Excel Close Button | Click to close the Excel Program. |
| Ribbon | Contains the commands and tools grouped by category on different tabs. |
| Tabs | Click to access tools and commands related to the name of the tab. |
| Name Box | Identifies the active cell by the letter of the column and the number of the row it intersects. It also identifies the range of cells being selected. |
| Formula Bar | Displays the contents of the active cell and is used to create or edit text or values. It may be expanded or contracted by clicking the double arrows at the right edge of the bar. |
| Active Cell | Highlighted with a thick border, it stores information that is entered while the cell is active. |
| Columns | Identified by letters that run horizontally. |
| Rows | Identified by numbers that run vertically. |
| Worksheet Tabs | Identify the worksheets in the workbook. |
| View Buttons | Click to display the worksheet in Normal, Page Lay-out, or Page Break Preview view. |
| Zoom Controls | Click the buttons or move the slide to zoom in or out. |
| Scroll Bars | Used to move the display horizontally or vertically within a worksheet. |
| Worksheet Title | Describes the content of a worksheet table. Key the title in all capital letters using a 12-point or 14-point font. Apply bold and center the tile across the columns that have data. Leave one blank row after the title. |
| Column Head | Appears at the top of a column and describes the data in the column. Key column heads in the default font size or a 12-point font. Apply bold and center alignment to column heads. |
| Formulas | Equations that perform calculations on values in a worksheet. You can use formulas to add, subtract, multiply, and divide numbers. To solve math problems, select the cell in which the answer is to appear. Key an equal ( = ) sign to indicate that the following text and numbers will be a formula. Enter the formula and tap ENTER. The formula will appear in the formula bar and the answer will appear in the cell. |
| Function | A predefined formula that can be used to perform calculations. For example, the SUM function is used to add numbers. |
| Fill Handle | The small square in the bottom-right corner of the cell. |
| Sort | To arrange or group items in a particular order. You can sort information in a worksheet in ascending or descending order. |
| Ascending | A to Z for words. For numbers, ascending order means from the lowest to the highest number. |
| Descending | Z to A for words. For numbers, descending order means from the highest to the lowest number. |
| Column Charts | Compare values across categories of data. |
| Bar Charts | Compare values across categories of data. |
| Pie Charts | Show how much each value is of a total value. |
| Category Axis | The x-axis, often called the horizontal axis, is used to plot categories of data. |
| Value Axis | The y-axis, often called the vertical axis, is used to plot values associated with the categories of data. |
| Data Points | The bars, columns, or pie slices that represent the numerical data in a chart. |
| Legend | A key (usually with different colors or patterns) used to identify the chart's data categories. |
