Theme- is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.
Live Preview- as you work Live Preview shows the effects of formatting options on the workbook's appearance before you apply the them. This lets you see and evaluate different formats as you develop your workbook.
Typeface- the appearance of text is determined by its typeface, which is the specific design used for the characters, including letters, numbers, punctuation marks, and symbols. Typefaces are organized into fonts.
Font- a font is a set of characters that employ the same typeface. Commonly used fonts are Arial, Times New Roman, and Courier.
Serif Fonts- such as Times New Roman, have extra decorative strokes at the end of each character.
Sans Serif Fonts- such as Arial do not include these decorative strokes.
Theme Font- associated with a particular theme and used for headings and body text in the workbook.
Non-Theme Font- when you don't want to associate a font with a particular design.
Font Style- formatting feature that changes the appearance of text, such as bold, italic, and underline
Font Size- specifies the size of the characters and is determined by a measurement system called points--where one point is approximately 1/72 of an inch.
Theme Colors- 12 colors belonging to the workbooks theme. 4 colors are used for text and backgrounds, six colors are used for accents and highlights, and two colors are used for hyperlinks. Designed to work well together and to remain readable in all color combos.
Standard Colors- dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple. Always available regardless of the workbooks theme. You can also open an extended palate of 134 colors.
Custom Color- a color you specify as a mixture of red, blue, and green color values, which makes available 16.7 million custom colors - more colors than the human eye can distinguish.
Automatic Color- options that uses your windows default text and background color values, usually black text on a white background.
Mini Toolbar- appears when you select text and contains buttons for commonly used text formats.
General Number Format- default number format that automatically displays number, for the most part, the same way you enter them.
Merge- to join two or more cells together to make one cell
Border- adding a line, or border around a cell or range
Number- provides options for formatting the appearance of numbers, including dates and numbers treated as text (for example, telephone or social security numbers)
Alignment- provides options for how data is aligned within a cell
Font- provides options for selecting font types, sizes, styles, and other formatting attributes such as underlining and font colors
Fill- provides options for creating and applying background colors and patterns to cells
Protection- provides options for locking or hiding cells to prevent other users from modifying their contents
Format Painter- copies the formatting from one cell or range to another cell or range, without duplicating any of the data.
Style- is a collection of formatting. For example you can create a style to display sheet titles in a bold, white 20 point Calibri font on a blue background
Excel Table- a range of data you can treat as a distinct object in a worksheet.
Table Style- formats the entire table as a single unit
Banded Rows- in an Excel table, rows of alternating colors that make data easier to read.
Header Row- formats the the first row of the table
Total Row- inserts a new row at the bottom of the table that adds the column values.
First Column- formats the first column of the table.
Last Column- formats the last column of the table.
Banded Columns- formats alternating columns in different colors.
Conditional Format- applies formatting only when a cell's value meets a specified condition.
Data Bar- a horizontal bar added to the background of a cell to provide a visual indicator of the cell's value.
Highlighting Rules-
Legend - a key that shows each color used in the worksheet and what it means so others know why certain cells are highlighted.
Print Area- consists of the cells and ranges designated for printing.
Page Break- performed manually when a new page is needed for a break or change in content.
Manual Page Breaks- specify exactly where the page breaks occur.
Print Titles- repeat information such as the company name by specifying rows or columns in the worksheet. Info that prints on each page.
Header- text printed in the top margin of each page.
Footer- the text printed in the bottom of the margin of each page.
Margin- the space between the page content and the edges of the page.