Module 2 Excel Definitions Flashcards
Accounting format
The number format that places a currency symbol at the left edge of the column, adds a thousands separator to the value, shows two decimal places, lines up numbers within a column by their currency symbols and decimal points, displays negative numbers within parentheses, and displays zero
automatic page break
A page break Excel sets 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 workbook.
Comma style
The number format that adds a thousands separator to numbers, adds two decimal places, and lines up values within a column by their decimal points.
conditional formatting
Formatting that is applied to a cell when its value meets a specified condition.
Currency format
The number format that places a currency symbol directly to the left of the first digit of the currency value, adds a thousands separator to the value, shows two decimal places, lines up numbers within a column by their decimal points, and displays negative numbers with a negative sign.
fill color
A background color that can be added to cells to help differentiate parts of a worksheet or highlight data.
font
A set of characters that employ the same typeface, such as Arial, Times New Roman, and Courier.
font style
Formats that can applied to a font such as italic, bold, bold italic, underline, strikethrough, and color.
footer
Information that appears at the bottom of each printed page
Format Painter
A feature that copies and pastes formatting from one cell or range to another without duplicating any data.
header
Information that appears at the top of each printed page.
legend
A key that identifies the colors or the shapes used in a worksheet or a chart.
Live Preview
A showing of how a workbook would be affected by an option in a gallery.
Long Date format
A 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
A page break you set to indicate where a new page of the printout should start.
margin
The space between the page content and the edges of the page.
merge
To combine, such as several cells into one cell.
Mini toolbar
A toolbar that contains buttons to perform common formatting options for a selection.
Percent style
The number format for percentages that adds the % symbol after the number and no decimal places.
print area
The range or ranges in a worksheet that you specify to be printed.
print title
Information that is included on every page of the printout; specified as rows or columns to repeat on the top or left of each page.
Quick Analysis tool
A 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
An abbreviated format for dates in the format mm/dd/yyyy.
standard color
One of 10 colors—dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple—that is always available regardless of the workbook’s theme.
style
A collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.
theme
A collection of formatting for text, colors, images, and graphical effects that are applied throughout a workbook to create a specific look and feel.
theme color
One of 12 colors that belong to the workbook’s theme
theme font
A font associated with a particular theme and used for headings and body text in the workbook; theme fonts change automatically when the theme is changed.