| A | B |
|---|
| Formatting Mark | A(n) _______________ is a character that Word displays on the screen but is not visible on a printed document. (WD 6) |
| Blue Wavy | A(n) _______________ underline indicates the text may have a contextual spelling error, such as the misuse of homophones. (WD 9) |
| Ignore All | To instruct Word not to flag future occurrences of a spelling error, right-click the flagged word and click ______________ on the shortcut menu. (WD 10) |
| Headline | The _______________ is the first line of text on a flyer. (WD 11) |
| Character | _______________ formatting is the process of changing the way characters appear on the screen and in print. (WD 13) |
| Font | The _______________, or typeface, defines the appearance and shape of the letters, numbers, and special characters. (WD 14) |
| Color Scheme | A(n) _______________ is a document theme that identifies 12 complementary colors for text, background, accents, and links in a document. (WD 31) |
| Style | A(n) _______________ is a named group of formatting characteristics. (WD 38) |
| Standard | _______________ properties are associated with all Microsoft Office files and include author, title, and subject. (WD 44) |
| Green | ______________ computing involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies. (WD 51) |
| Research Paper | A(n) _______________ is a document you can use to communicate the results of research findings. WD 66 |
| Works Cited | The MLA documentation style uses the term, _______________, to refer to the bibliographic list of sources at the end of the paper. WD 68 |
| Paragraph Spacing | _______________ is the amount of space above and below a paragraph. WD 72 |
| Horizontal | Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the _______________ ruler. WD 82 |
| Field | A(n) _______________ is a placeholder for data whose contents can change. WD 90 |
| Endnote | A note that exists at the end of a document is called a(n) _______________. WD 92 |
| Background | Word refers to the automatic page break task as _______________. WD 101 |
| Works Cited Page | According to the MLA documentation style, the _______________ is a list of sources that are referenced directly in a research paper. WD 104 |
| Office Clipboard | The _______________ is a temporary storage area that holds up to 24 items copied from any Office program. WD 111 |
| Thesaurus | A(n) _______________ is a book of synonyms. WD 116 |
| Letterhead | A(n) _______________ is a section of a letter that identifies an organization or individual. WD 141 |
| Floating Object | A(n) _______________ is an object that can be positioned at a specific location in a document or in a layer over or behind text in a document. WD 144 |
| Document Theme | A(n) _______________ is a coordinated combination of colors, fonts, and effects. WD 148 |
| Clipart | Predefined graphics are called _______________. WD 148 |
| Clear Formatting | Word uses the term, _______________, to refer to returning the formats to the Normal style. WD 161 |
| Hyperlink | When you press ENTER after typing an email address or web address, Word automatically formats the address as a(n) _______________. WD 162 |
| Building Block | If you use the same text or graphic frequently, you can store the text or graphic as a(n) _______________ and then insert the entry in an open document, as well as future documents. WD 170 |
| Nonbreaking Hyphen | A(n) _______________ is a special type of hyphen that prevents two words separated by a hyphen from splitting at the end of a line. WD 173 |
| Table | A Word _______________ is a collection of rows and columns. WD 174 |
| End-of-cell Mark | Each table has a(n) _______________, which is a formatting mark that assists you with selecting and formatting cells. WD 175 |
| Function | A(n) _______________ is a prewritten formula that is built into Excel. EX 66 |
| Equal Sign | A(n) _______________ alerts Excel that you are entering a formula or function and not text. EX74 |
| Order of Operations | The order in which calculations are performed in a formula is called the _______________. EX75 |
| Point Mode | _______________ allows you to select cells for use in a formula by using the mouse. EX76 |
| Max | Excel includes a function called the _______________ function that displays the highest value in a range. EX82 |
| Average | The _______________ function sums the numbers in a specified range and then divides the sum by the number of cells with numeric values in the range. EX 86 |
| Range Finder | _______________ checks which cells are referenced in the formula assigned to the active cell. EX89 |
| Best Fit | _______________ means that the width of the column will be increased or decreased so that the widest entry will fit in the column. EX103 |
| Page Layout | _______________ view allows you to create or modify a worksheet while viewing how it will look in printed format. EX110 |
| Debugging | _______________ is the process of finding and correcting errors in the worksheet. EX 115 |
| Paste Options | After you tap or click the Paste button, Excel immediately displays the _______________ button. EX 142 |
| Drag & Drop | Using touch or the mouse to move or copy cells is called _______________. EX 143 |
| F4 | If you insert a single row by using the Insert command on the shortcut menu, you can continue inserting rows by repeatedly press the _______________ key. EX 145 |
| NOW | When assigned to a cell, the _______________ function returns a number that corresponds to the system date and time beginning with December 31, 1899. EX 148 |
| Absolute | A formula using a(n) _______________ cell reference instructs Excel to keep the cell reference constant in the formula as it copies it to the destination area. EX 151 |
| IF | In Excel, you can use the _______________ function when you want to assign a value to a cell based on a logical test. EX 155 |
| Zoom | You can magnify or shrink the appearance of a worksheet or chart by using the _____________ button on the VIEW tab. EX 182 |
| Freeze | Excel allows you to _______________ columns and rows, so that Excel displays their content on the screen, no matter how far down or to the right you scroll. EX 185 |
| What-If | Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called _____________ analysis or sensitivity analysis. EX 187 |
| Goal Seeking | If you know the result you want a formula to produce, you can use _______________ to determine the value of a cell on which the formula depends. EX 188 |
| Chart | A(n) _______________ conveys a visual representation of data. EX 2 |
| Requirements | A(n) _______________ document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for the worksheet, such as charting and web support. Ex 3 |
| Columns | _______________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet. EX 6 |
| Sum | The _______________ function adds all the numbers in a range of cells. EX 14 |
| Fill Handle | The _______________ is the small black square located in the lower-right corner of the heavy border around the active cell. EX 16 |
| Bold | _______________ text has a darker appearance than normal text. EX 26 |
| Surface | A(n) _______________ chart compares data from three columns and/or rows in a three-dimensional manner. EX 37 |
| Exploded | A pie chart with one or more slices offset is referred to as a(n) _______________ pie chart. EX 41 |
| Document Properties | Excel helps you organize and identify your files by using _____________, which are the details about a file such as the project author, title, and subject. |
| Auto Calculate | You easily can obtain a total, an average, or other information about the numbers in a range by using the _______________ area on the status bar. EX 48 |
