Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
MS-Office Excel Ch 2
Formatting a Workbook
| Term | Definition |
|---|---|
| formatting | The process of chnaging a workbook's appearance by defining the fonts, styles, colors, and decorative features. |
| theme | A collection of formats for text, colors, images, and graphical effects applied throughout a workbook. |
| theme font | associated with a particular theme and used for headings and body text in the workbook --change when you change a theme. |
| non-theme font | Text formatted with this retains its appearance no matter what theme is used with the workbook |
| serif font | Such as Times New Roman, have extra decorative strokes at the end of each character |
| sans serif | such as Arial, do not include decorative strokes at the end of each character |
| theme colors | 12 colors that belong to the workbook's theme |
| accents | each theme color as five of these variations where a different tint or shading is applied to the theme |
| standard colors | are always available regardless of the workbook's theme. Include dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple. |
| custom color | color you can create by specifying a mixture of red, green and blue values. 16.7 million are available. |
| automatic color | option that uses your Windows default text and background colors, usually black text on a white background. |
| number format | Displays the values in a way that makes it easy for the reader to quickly understand and interpret them. Can change without changing values. |
| general number format | Displays values exactly as they are typed by the user. If value is calculated, from a formula or function, Excel shows as many digits after the decimal point as will fit in the cell with the last displayed digit rounded |
| merge and center | merges the range into one ell and horizontally centers the content |
| merge across | merges each of the rows in the selected range across the columns in the range. |
| merge cells | merges the range into a single cell, but does not horizontally center the cell content |
| unmerge cells | reverses a merge, returning the merged cell back into a range of individual cells. |
| Header row | Excel table element which formats the first row of the table |
| total row | Excel table element which inserts a new row at the bottom of the table that adds the column valued |
| first column | Excel table element which formats the first column of the table |
| last column | Excel table element which formats the last column of the table |
| banded rows | Excel table element which formats alternating rows in different colors |
| banded columns | Excel table element which formats alternating columns in different colors |
| legend | key that shows each color used in a worksheet and what it means so others know why certain cells are highlighted |
| print area | region that is sent to the printer from the active sheet |
| automatic page breaks | inserted by Excel when the contents of a worksheet do not fit on a single page |
| manual page breaks | inserted by users to split a worksheet into logical segments for printing |
Created by:
mgarda
Popular Computers sets