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 |