| A | B |
|---|
| Accounting format | Number format that places a $ at the left edge of the column, includes a thousands separator and two decimal places; negative values in parentheses. |
| automatic page break | A page break Excel sets automatically when the page of the printout is full. |
| Average function | An Excel function that calculates the average value from a collection or numbers. |
| cell style | Predefined formatting options that you can apply to cells in a worksheet. |
| Comma style | Number format that adds a thousands separator to numbers, adds two decimal places |
| conditional format | Formatting applied to a cell when its value meets a specified condition. |
| Currency format | Number format that places a $ directly to the left of the first digit of the value, includes thousands separator and two decimal places; negative values are displayed with a negative sign. |
| Format Painter | Feature that copies and pastes formatting from one cell or range to another without duplicating any data. |
| gallery | Menu or grid that shows a visual representation of the options available or the selected button. |
| legend | Key that identifies the colors or the shapes used in a worksheet or a chart. |
| Long Date format | Format for dates that displays the day of the week and the full month in addition to the day of the month and the year. |
| manual page break | Page break you insert to indicate where a new page of the printout should start. |
| merge | To combine, such as several cells into one cell. |
| Percent style | Number format for percentages that adds the % symbol after the number and no decimal places. |
| print area | Range or ranges in a worksheet that you specify to be printed. |
| print title | Information that appears on every printed page; specified as rows or columns to repeat on the top or left of each page. |
| Quick Analysis tool | Button that appears whenever you select a range of cells, providing access to the most common tools for data analysis and formatting for the selected range. |
| Short Date format | Abbreviated format for dates in the format mm/dd/yyyy. |
| style | Collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. |
| theme | Collection of formatting for text, colors, images, and graphical effects that are applied throughout a workbook to create a specific look and feel. |
| theme colors | The 12 colors that belong to the workbook’s theme. |
