| A | B |
| To remove or display rulers, click on the ribbon to display the _____ tab and then click the View Ruler check box. (WD 5) | View |
| To enter a blank line in a document, _____. (WD 7) | press the ENTER key without typing any text on the line |
| ____ allows you to type words in a paragraph continually without pressing the ENTER key at the end of each line. (WD 8) | Wordwrap |
| A _____ underline indicates the text may be incorrect grammatically. (WD 9) | Green Wavy |
| A document _____ is a set of unified formats for fonts, colors, and graphics. (WD 14) | Theme |
| Characters that are somewhat thicker and darker than others are called _____. (WD 29) | Bold |
| To see the entire page on the screen at once, click VIEW on the ribbon to display the VIEW tab | Zoom group, and click the _____ button. (WD 30) | One Page |
| A selected graphic appears surrounded by a selection rectangle, which has small circles and squares, called _____. (WD 35) | Sizing Handles |
| To return a graphic to its original size, click the Size Dialog Box Launcher, click the Size tab, and click the _____ button. (WD 37) | Reset |
| The little white circle attached to the top of a selected graphic is called a _____ . (WD 38) | Rotate Handle |
| A _____ is a named group of formatting characteristics, including font and font size. WD 70 | Style |
| _____ is the amount of vertical space between lines of text in a paragraph. WD 72 | Line Spacing |
| A ____ is text and/or graphics that print at the top of each page in a document. WD 74 | Header |
| Word has an _____ feature, where it predicts some words or phrases as you are tying and displays its prediction in a ScreenTip. WD 78 | Auto Complete |
| If you do not want to keep a change automatically made by Word, you can undo the change by clicking the Undo button on the Quick Access Toolbar, or by pressing _____. WD 87 | CTRL+Z |
| Because Word documents use variable character fonts, the rule is to _____ after periods, colons, and other punctuation marks. WD 88 | press the spacebar only once |
| A superscript is used as a(n) _____ to signal that a note exists either at the bottom of the page or at the end of a document. WD 92 | Note Reference Mark |
| You can look on the _____to see the total number of words in a document. WD 100 | Status Bar |
| A _____ page break is one that you force into a document at a specific location. WD 105 | Manual |
| _____ is the process of placing items on the Office Clipboard, while leaving the item in the document. WD 111 | Copying |
| A _____ is a graphic that you create using Word. WD 142 | drawing object |
| When the mouse pointer changes to a(n) _____, you can drag from the upper-left corner to the lower-right corner to form the desired location and size of a shape. WD 143 | Crosshair Pointer |
| An ______ chart is one that is on a worksheet. | embedded |
| With a graphic selected, you would click the _____ button to remove all formatting. WD 154 | Reset Picture |
| When you type an email address, Word’s _____ As You Type feature automatically formats it as a hyperlink. WD 163 | Auto Format |
| To remove all tab stops, click the _____ button in the Tabs dialog box. WD 169 | Clear All |
| A(n) _____ is a special space character that prevents two words from splitting if the first word falls at the end of a line. WD 173 | Nonbreaking Space |
| In a Word table, the intersection of a row and a column is called a(n) _____. WD 174 | Cell |
| The table resize handle is a _____ that appears when you point to a corner of a table. WD 178 | Small Square |
| You can press the _____ key to move to the next cell in a table. WD 179 | Tab |
| If you use Point mode to enter a formula or select a range, you must press the ______key to complete the entry. | ENTER |
| You can rotate text counterclockwise by entering a number between 1 degree and ____ degrees on the Alignment sheet in the Format Cells dialog box. | 180 |
| Press the __ key to lock in place the cell reference in an Excel formula. | F7 |
| A formatting mark is a character that Word displays on the screen but is ______ on a printed document. | not visible |
| ______ is the small black square located in the lower-right corner of the heavy border around the active cell. | Fill handle |
| In Word, the default tabs are places at _____ intervals on the ruler. | one half inch |
| There are _____ that are used to create resumes. | templates |
| Selected placeholder text automatically is _____ when you begin typing. | deleted |
| To center cell entries across columns, highlight the cells, press ______. | merge/center button |
| To Format Numbers in the Worksheet with a Floating Dollar Sign, Highlight the cells to be formatted, right-click_____. | Click format cells |
| The _________ function sums the number in the range and then divides the sum by the number of cells in the range. | AVERAGE |
| A ________ is a specific location on a storage medium. | Folder |
| An alias used with a password to grant access to accounts and websites. | Username |
| On a column chart, the ________ identifies the colors assigned to each bar in the chart. | legend |
| Use a(n) _______________ in a cell to enter numbers as text. | apostrophe |
| How many times do you return after the dateline in a letter? | Four Times |
| Excel opens a new workbook with ____________ worksheets. | one |
| When copying a range of cells using the drag and drop method, you first point to the border of the selected range so that the mouse pointer changes to a(n)_________. | cross hair |
| When Excel automatically sets the width of a column based on the widest entry in the column, it is called ______. | best fit |
| To enter column titles that appear on two lines within a cell, type the first word, press _____ and type second word. | Alt + Enter |
| The _____, called the primary tab, contains the more frequently used tools. | Home Tab |
| When a red wave appears under a word is means the word is | incorrect |
| ____ is an example of an alignment | Center |
| The keyboard shortcut for SELECT ALL is ____ | CTRL + A |
| The keyboard shortcut for PASTE is ___ | CTRL + V |
| The keyboard shortcut for COPY is ____ | CTRL + C |
| A ______ is text and graphics that print at the bottom of every page. | Footer |
| A research paper is ______ spaced. | double |
| In the header when writing a research paper, your last name and the page number should be _____. | Right-aligned |
| To insert a new citation you must be on the ______ ribbon | References |
| A __________ is the coordinates of the intersection of a column and a row; for example A1. | Cell Reference |
| __________ involves creating a single cell by combining two or more selected cells. | Merging Cells |
| A _________ is a prewritten formula that is built into excel. | Function |
| _____ is the first thing that needs to be done to add a chart in to Excel? | Select a range of data |
| An Excel _____ allows data to be summarized and charted easily. | worksheet |
| The _____ box displays the active cell reference. | Name |
| The _____ feature of Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell. | AutoCorrect |
| When you enter numeric data in a cell, Excel recognizes the values as numbers and _____ the values. | right-aligns |
| A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells. | range |
| A preceding _____ alerts Excel that you are entering a formula or function and not text. | equal sign |
| Font size is gauged by a measurement system called _____. | points |
| The _____ command on the Clear menu is the only command that clears both the cell entry and the cell formatting. | Clear All |
| If the following arithmetic operations ( +, *, /, ^) all are found in a formula with no parentheses, which one is completed last? | plus |
| When you copy a formula with a relative cell reference down a row, the row references _____ in the formula. | change |
| The _____ function is used to determine the lowest number in a given range. | MIN |
| To assign a dollar sign to appear immediately to the left of the first digit with no spaces, use a _____ dollar sign. | floating |
| Greater than is a _____ conditional formatting operator found in the New Formatting Rule dialog box. | valid |
| Excel includes a(n) _____ you can use to check a worksheet for spelling errors. | spell checker |
| A(n) _____ is text and graphics that print at the bottom of each page. | footer |
| _____ are values in cells that you can change to determine new values for formulas. | Assumptions |
| The _____ is a temporary storage area in the computer’s memory that allows you to collect text and graphics from an Office document and then paste them into almost any other type of document. | Office Clipboard |
| _____ format symbols include all of the following symbols -- dollar sign, comma, and percent sign. | valid |
| A _____ shows the date a workbook, report, or other document was created or the time period it represents. | date stamp |
| A formula using the _____ cell reference B4 instructs Excel to adjust the cell reference as it copies it to the destination area. | relative |
| Excel displays the following _______ ##### in cells that are not wide enough to display entire entry. | error message |
| The _____ feature evaluates the selected data and makes suggestions regarding which chart types will provide the most suitable representation. | Recommended Charts |
| When you _____ a worksheet, Excel enlarges the view of the characters on the screen, but displays fewer columns and rows. | magnify |
| When working with a large worksheet, you can split the window into two or four _____ to view different parts of the worksheet at the same time. | panes |