Combo with "Excel Chapter 2" and 9 others
____ refers to cells not wide enough to display the entire entry.
# # # # #
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.
#REF!
equal sign (EX 91)
( = ) alerts Excel that you are entering a formula or function and not text
1) Once the document is shaded gray and you want to print it, The gray will ? a) Still be shaded on the printed document b) Will not show on the printed document c) Must remove the gray from the document before printing.
(B)
Which of the following is the path to the Goal Seek button?
(Data tab | Data Tools group)
Which of the following is the path to the Increase or Decrease Indent button?
(Home tab | Alignment group)
Which of the following is the path to the Insert button?
(Home tab | Cells group)
The path to the Format Painter button is ____.
(Home tab | Clipboard group)
Which of the following is the path to the Copy and Paste buttons?
(Home tab | Clipboard group)
Which of the following is the path to the Sum button?
(Home tab | Editing group)
Which of the following is the path to the Comma Style button?
(Home tab | Number group)
Which of the following is the path to the Conditional Formatting button?
(Home tab | Styles group)
Which of the following is the path to the Spelling button?
(Review tab | Proofing group)
Which of the following is the path to the Zoom button?
(View tab | Zoom group)
If the following arithmetic operations all are found in a formula with no parentheses, which one is completed last? + * / ^
+
AutoSum -
- A function that automatically identifies and adds ranges of cells in your worksheet.
Cell Address/Reference -
- The name of the cell is determined by the name of the row and the column intersecting, such as A8.
Word, by default, places a tab stop at every ____ mark on the ruler.
.5"
The file type _____ is a Word 2010 document
.docx
When you decrease the row height to ____, the row is hidden.
0
In Excel, a number can contain the characters ____.
0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e
Excel remembers the last ____ actions you have completed.
100
How many chart types does Excel offer?
11
On most computers, the default font size in Word is _____.
11
With more than ______ predefined color schemes, Word provides a simple way to select colors that work well together.
20
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
20xx
When Excel follows the order of operations, the formula, 8 * 3 + @, equals ____.
26
Which of the following patterns extends the fill series to 575, 550, 525?
625, 600
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type ____.
6E15
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
Which comparison operator means "not equal to"?
< >
Which of the following calculations multiplies 23 by 0.01: =23%, =23, =23 + .01, =24 - .01
=23%
All of the following are valid Excel arithmetic operators except: ^ * % >
>
) To discontinue autocorrection. a) press ctrl+z b)click undo button on quick access toolbar c) Go to autocorrect options d) All of the above
A
1) Everytime you enter a value into a cell in the worksheet Excel automatically does what? a) Recalculates all formulas b) Highlights the value c) Deletes the text
A
2) The entire list of sources is a field that Word __________ updates each time you make a change to one of the sources. a) Automatically b) Sometimes c) Never
A
2. An identifier that links a citation to a source is a... a. Tag Name b. Footnote c. Header d. Source Citation
A
2. When the e-mail message window appears you type what in the TO text box? a. The person you are sending the message to. b. Your e-mail c. The name of the document d. Your name
A
3. If you want to insert and identifier that link a citation to a source you would... a. Insert a Tag Name b. Insert a Cross Reference c. Insert a Hyperlink d. Insert a Footer.
A
3. What is the area called that you type the message in on an e-mail? a. The Body b. The Message Area c. The Attached File d. E-mail
A
A thesaurus is a book of A.synonym B.antonym C. homonym
A
Does word provide synonyms and a thesaurus for your convience A. yes B.no C. maybe
A
In Insert Mode, when you type a character, Excel A. Inserts the character and moves all characters to the right B. Adds and displays the number of words in the Cell C. Automatically calculates the cell value D. Replaces the character at the insertion point with the typed character
A
Q&A 2 - Click the Print Button to display a. the print dialog box b. a preview of the worksheet c. editing options
A
To delete an incorrect character in a document a. click next to the incorrect character then press the BACKSPACE key to erase the left of the insertion point b. click the Office Button then click Open c. triple click the paragraph
A
What is the Ribbon a control center for? a) creating documents b) formatting documents c) saving documents
A
When writing, you may discover that you used the same word in multiple locations or that a word is not used appropriat you will want to look up a A. synonym B. Antonym C. homonym
A
When you click New, Open, Save as, and Print commands, Excel A Displays a dialog box with additional options B Displays uninstall options C Shuts down D Performs the command
A
When you click the New, Open, Save As, and Print commands on the Office Button Menu, a. Excel displays a dialog box with additional options. b. Excel opens your previous document c. you can go ahead and prepare a graph
A
When you copy a cell downward A. Excel adjusts the row portion of the cell references B. Excel adjusts the column portion of the cell references C. Excel adjusts the row and column portion of the cell references D. Excel adjusts the row portion referencing only higher cells
A
While the Ribbon is a control center for creating the documents, the Office Button is a central location for a. managing and sharing documents b. Quick access to the tool bar c. entering text
A
With the range to chart selected to initiate drawing the chart, on the ribbon you click the A. Column button B. Chart button C. Table button D. Quick Parts button
A
• The Office Button is A) a central location for managing and sharing documents. B) Adds other commands from the toolbar. C) used to set up a screen tip
A
Worksheet -
A "page" within an Excel workbook that contains columns, rows, and cells.
Cell references
A cell's column letter and row number.
theme
A collection of design elements, graphics, and colors that help items such as documents, presentations, and Web pages maintain a consistent image
Formula-
A combination of numbers and symbols used to express a calculation.
Formula Bar -
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
File-
A document that is stored on your computer. In Excel, a file is also known as a workbook.
Function -
A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.
Fill Down -
A feature that allows you to copy information in an active cell to another cell or range of cells selected vertically.
Fill Right -
A feature that allows you to copy information in an active cell to another cell or range of cells you have selected horizontally.
AutoFill -
A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
footnote
A note reference mark signals that an explanatory note exists at the bottom of the page as a(n) ____, as shown in Figure 2-1.
field
A placeholder for data whose contents can change
worksheet
A single sheet contained in an excel workbook
citation
A tag name is an identifier that links a(n) ____ to a source.
Worksheet
A workbook contains one or more sheets (spreadsheets)..
Spreadsheet
A workbook contains one or more sheets called worksheets.
thesaurus
A(n) ____ is a book of synonyms.
field
A(n) ____ is a placeholder for data whose contents can change.
hanging indent
A(n) ____________________ is a type of paragraph formatting in which the first line extends to the left of the rest of the paragraph.
To start a new line in a cell, press the ____ keys.
ALT + ENTER
To move to the bottom of a document window, press the _____ key(s).
ALT+CTRL+PAGE DOWN
To move to the top of a document window, press the ____ key(s).
ALT+CTRL+PAGE UP
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
AVERAGE
works cited page
According to the MLA style, the _____ is a list of sources that are referenced directly in a research
left margin
According to the MLA style, the first line of each entry on the works cited page begins at the________________.
The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
Accounting number format
One way to add a correctly spelled word to the custom dictionary is to click the ___________ button in the spelling and Grammar dialog box.
Add to Dictionary
________ are types of changes that occur when text has been omitted from a document and must be inserted later.
Additions
Sheet tab
Allow you to move from one worksheet to another
Quick Access Toolbar (QAT)
Allows users to quickly find commands.
point and click method
Allows you to point and click each cell in a formula rather than typing cell references
same basic information
Although many different styles of documentation exist for report preparation, each style requires the __________.
horizontal ruler
Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____.
Workbook-
An Excel file that contains individual worksheets. Also called a spreadsheet file.
Workbook
An Excel file.
Formula
An equation that begins with an equal sign (=) and includes values or cell references.
workbook
An excel document which contains three worksheets by default but can have more than three
smart tags
An icon which appears automatically when performing certain actions such as pasting in text or with AutoCorrection
tag name
An identifier that links a citation to a source
draw layer
An invisible layer atop each worksheet which holds charts, diagrams, pictures, buttons, and other objects.
character
Any letter, number, symbol, or puctuation mark
Row
Appears horizontally and is identified by numbers on the left side of the worksheet window
Fill handle
Appears in the lower-right corner of the active cell or range, and is used to fill cells
ScreenTip
Appears to show you the button's name.
Formula Bar
Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value
Column
Appears vertically and is identified by letters at the top of the worksheet window
Sheet tabs
Are pages inside your workbook.
Values used with a function are called ___.
Arguments
division
Arithmetic operatir that divides numbers
Percentage
Arithmetic operator that multiplies by 0.01
automatic page breaks soft page breaks
As documents that exceed one page are typed, Word automatically inserts page breaks like those in Figure 2-4, called ____________________, when it determines the text has filled
header
As shown in Figure 2-2, a(n) ____________________ is text printed at the top of each page in a document.
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
Which of the following Option buttons gives options for filling cells following a fill operation: Auto Fill Options, AutoCorrect Options, Insert Options, Paste Options.
Auto Fill Options
The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
AutoCalculate
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
When the ______ is clicked, Word displays a menus that allows a correction to be undone or changes how Word handles feature automatic correction of this type.
Autocorrect Options Button
To change the color of text back to black, you can select the text, click the Font Color button arrow, and then click ____ on the Font Color gallery.
Automatic
paper size line spacing margin settings
Automatic page breaks like the one in Figure 2-4 are determined by ____.
The ___ function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range.
Average
1. The commands to insert a chart are located on the... a. References Tab b. Insert Tab c. Links Tab d. Quick Parts Drop Down
B
1. What is a tag name? a. A tag name is the name of the file. b. A tag name is an identifier that links a citation to a source. c. A tag name is an endnote that references the file name and location on computer. d. A tag name is none of the above.
B
2. The Page Setup dialog box is viewed after pressing the _______________. a. Change font size button b. Page Setup button c. Choose style preference button d. Edit text button
B
2. The area on the worksheet where the chart appears is called the... a. Clustered Column b. Chart Location c. Selected Range d. Illustrations
B
In Excel when you enter a two digit year less than 30, excel changes it to a four digit year A. In the 20th century B. It starts the year with '20' C. It starts the year with '20' only if the month is after June D. It prompts you for the century
B
To delete an incorrect character in a document a. close the document and start again b. click next to the incorrect character then press the BACKSPACE key to erase the left of the insertion point c. click next to the incorrect character then press CTRL+END and hold down the CTRL key
B
What happens when you click the New, Open, Save as, and Print Commands command on the Office Button menu? a) Nothing b) Word displays a dialog box with additional options c) It automatically saves the document
B
When you click the New, Open, Save As, and Print commands on the Office Button Menu, a. Excel begins to autocorrect any errors in your work b. Excel displays a dialog box with additional options. c. you are able to run spell check on your document
B
When you copy a cell horizontally A. Excel adjusts the row portion of the cell references B. Excel adjusts the column portion of the cell references C. Excel adjusts the row and column portion of the cell references D. Excel adjusts the row portion referencing only higher cells in the workbook
B
While the Ribbon While the Ribbon is a control center for creating the documents ,the Office Button is a central location for a. editing a paragraph b. managing and sharing documents c. changing the theme colors on a document
B
You can change to ________ recalculation by clicking the Calculations Options button. a) Automatic b) Manual c) Occasional
B
• When you click on the New, Open, Save as... A) Word displays the Office Button menu. B) Word displays dialog box with additional options. C) A quick access toolbar appears.
B
To close the ________ view, click File not the Ribbon or click the preview of the document in the Info gallery to return the document window
Backstage
background repagination
Because page repagination is performed between keystrokes, Word refers to the task of creating automatic page breaks like the one shown in Figure 2-4 as ____________________.
manual page break hard page break
Because the works cited are to display on a separate numbered page, a(n) ____________________ must be inserted at a specific location following the body of a research paper.
When Excel automatically sets the width of a column based on the widest entry in the column, it is called ___.
Best Fit
____ means that the width of a column will be increased or decreased so the widest entry will fit.
Best Fit
To remove a border from a paragraph, position the insertion point in the paragraph, click the _____________on the Home tab, and then click the No Border button in the Bord
Border button arrow
When using the MLA style, position in-text parenthetical references either at the __________, as in the figure
Bottom of the page as footnotes or at the end of the paper as endnotes.
Cell
Boxes organized into horizontal rows and vertical columns.
A(n)_________ paragraph is a paragraph that begins with a dot or other symbol
Bulleted
Command
Buttons organized in logical groups that relate to a specific activity.
gray
By default, Word shades fields ____ on the screen to help you identify them.
1.15
By default, the Normal style inserts a vertical space equal to ____ line(s) between each line of text.
10
By default, the Normal style places ____ points of blank space after each paragraph.
. While the Ribbon is a control center for creating the documents, the Office Button is a central location for a. deleting an incorrect character or word b. inserting text in an existing document c. managing and sharing documents
C
3) Why does Word, by default, shades field gray on the screen? a) To make it easier to read b) For fun c) To help you identify them
C
3. The ___________ button allows you to zoom in and out of your page in the Preview window. a. Track b. Change c. Zoom d. Clipboard
C
For the commands that do not display a box when clicked you, A can point to the command to display submenu B can click the HELP button C Both A & D D Can point to the arrow to display submenu
C
If the top of a set of characters or a graphical image is chopped off, you can set the line spacing to: A. Adjust B. Associate C. Exactly D. Contour
C
In manual calculation mode, You press what key to instruct Excel to recalculate all formulas? a) F5 b) F8 c) F9
C
The Ribbon is a control center for creating documents what is the central location for managing and sharing documents A The word pad B Help and support C The office button D The tool bar
C
The Ribbon is a control center for creating documents what is the central location for managing and sharing documents? A The toolbar B The gallery C The Office button D The internet button
C
The area on the worksheet where the chart appears is called the A. Chart focus area B. Chart insert area C. Chart location D. Chart definition area
C
To delete an incorrect character in a document a. click the Redo button on the Quick Access Toolbar b. click somewhere in the word and click the underline button c. click next to the incorrect character then press the BACKSPACE key to erase the left of the insertion point
C
When in manual calculation mode, to recalculate, press the A. f8 B. Enter C. f9 D. f10 function key
C
When you click the New, Open, Save As, and Print commands on the Office Button Menu, a. Excel reminds you to run a spell check and save your document. b. Excel will prompt you to shut down your computer. c. Excel displays a dialog box with additional options
C
When you click the Office Button, located in the ___________ corner of the window, Word displays the office button menu. a) upper right b) lower left c) upper left
C
When you copy a cell diagonally A. Excel adjusts the row portion of the cell references B. Excel adjusts the column portion of the cell references C. Excel adjusts the row and column portion of the cell references D. Excel adjusts the row portion referencing only higher cells in the workbook
C
• To select a command you must A) point to the arrow on the right when you Save As B) Print C) Both above
C
If you want to select the first and third rows in the table in the accompanying figure, you select the first row, and then hold down the ____ key while selecting the third row.
CTRL
To select multiple cells, rows, or columns in a table that are not adjacent to one another, select the first cell and then hold down the ____ key while selecting the next cell, r
CTRL
To select nonadjacent items, select the first item as usual, press and hold down the ________ key, select the additional items.
CTRL
You can open the Format Cells dialog box by pressing the ____ keys.
CTRL + 1
You can press the ____ keys to open the Format Cells dialog box.
CTRL + 1
You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
CTRL + B
To copy cell contents, you can select the cell and then press the ____ keys.
CTRL + C
To paste copied cell contents, you can press the ____ keys.
CTRL + V
Yu can select a word by using the ______ key(s).
CTRL+ SHIFT+LEFT ARROW
You can select a document by using the ______ key(s).
CTRL+A
To move down one paragraph, press the _____ key(s).
CTRL+DOWN ARROW
The shortcut keys used to center a paragraph are __________.
CTRL+E
To move to the end of the document, press the _______ key(s).
CTRL+END
The shortcut keys used to left-align a paragraph are ___________.
CTRL+L
To move to the left one word with the keyboard, press the _____ key(s).
CTRL+LEFT ARROW
To increase a paragraph indent, use the __________ shortcut keys.
CTRL+M
To right-align a paragraph, use the ___________ shortcut keys.
CTRL+R
You can select a paragraph by using the ______key(s).
CTRL+SHIFT+DOWN ARROW
You can select multiple paragraphs by using the _______ key(s) repeatedly.
CTRL+SHIFT+DOWN ARROW
You can select multiple words by using the _____ key(s) repeatedly.
CTRL+SHIFT+RIGHT ARROW
To decrease a font size, use the _________ shortcut keys.
CTRL+Shift+<
The _______ shortcut keys underline words, and not spaces
CTRL+Shift+W
The ________ shortcut keys remove character formatting.
CTRL+Spacebar
To move up one paragraph, press the ______ key(s).
CTRL+UP ARROW
_______ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
Character
____ is a part of the complete mailing address that should appear on a letterhead.
City State Postal code
The __________ feature can be used to format and enter text, graphics, and other items
Click and Types
Select All
Click this button in the worksheet area to select all of the cells in the table.
Merge and Center
Click this button to merge selected cells and center data within the merged cells.
____ is a predefined graphic.
Clip art
The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer's memory.
Clipboard
The Office _______ is a temporary storage area.
Clipboard
Letters
Columns in a worksheet are labeled with these.
Button
Commands organized in a logical group that relates to a specific activity.
Save, Undo, and Redo
Commands that appear by default in the Quick Access toolbar.
Formatting that appears only when the value in a cell meets specific conditions is called ____.
Conditional Formatting
Ribbon
Contains all the buttons that you can use in Excel.
Group
Controlled by buttons.
1. How can the recipient use the attached workbook? a. They can double click to open it. b. They can Open it in Excel c. They can save it to a disk and work on it later. d. All of the Above
D
If the top of a set of characters or a graphical image is chopped off, you can set the line spacing to: A. 1.0 B. 1.5 C. 1.15 D. Any of the above
D
In Overlay Mode, when you type a character, Excel A. Inserts the character and moves all characters to the right B. Adds and displays the number of words in the Cell C. Automatically calculates the cell value D. Replaces the character at the insertion point with the typed character
D
The Ribbon is a control center for creating documents what is the central location for managing and sharing documents? A The printer B The menu C The shortcut menu D The office button
D
The Ribbon is a control center for creating documents what is the central location for managing and sharing documents? A The printer B The menu C The shortcut menu D The office button
D
To type a number such as 6,000,000,000,000,000 you can type A 6A15 B 6W15 C 6P15 D 6E15
D
When Excel enters the Edit mode, Excel's in A. Overlay Mode B. Print Mode C. Edit Mode D. Insert Mode
D
To delete the contents of a cell, select the cell contents by pointing to the left edge of the cell and clicking when the mouse pointer changes direction, and then press the
DELETE
Formula Bar
Data being typed in a cell displays in the cell as well as here
________ is required information for a citation for a Web site in MLA style.
Date viewed, title of Web site, and Web site publisher or sponsor.
____ is the process of finding and correcting errors in a worksheet.
Debugging
One way to delete a note is to click immediately to the left of the note reference mark in the document text and then press the _________ key twice.
Delete
To delete an incorrect character in a document, simply click next to the incorrect character and then press the _____ key(s) to erase to the left of the insertion point.
Delete
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ____.
Dialog Box Launcher
vertical ruler
Displays along the left edge of the Word window
Tab
Displays buttons (or commands) organized in local groups that relate to a specific activity.
What effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
What effect does the Accounting Number format have on the selected cells?
Displays cell contents with two decimal places that align vertically
trace error button
Displays next to a cell in which a formula error occurs
Title bar
Displays the Excel file name
name box
Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.
print button
Displays the print dialog box that is used to print the worksheet
Status bar
Displays various messages as well as the status of the Num Lock, Caps Lock, and Scroll Lock keys. Also shows summary information about the range of cells that is selected.
____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
Double-click
With _________ editing, Word automatically displays a Paste Option button near the pasted or moved text.
Drap and drop
Which of the following keys moves the insertion point to the end of data in a cell: HOME, DELETE, END, BACKSPACE?
END
An alternative to clicking the Paste button is to press the ____ key.
ENTER
Each time you press the ____ key, Word carries forward custom tab stops to the next paragraph.
ENTER
When ____ is pressed after entering an e-mail address or Web address, Word automatically formats the address as a hyperlink, that is, colored blue and underlined.
ENTER SPACEBAR
If you want to remove the Autocorrect options button from the screen, you can press the _________ key.
ESC
To cancel an entire entry before entering it into the cell, press the ____ key.
ESC
ENTER
Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.
Clicking the ____ box completes an entry.
Enter
The paragraph mark as shown in the figure is a formatting marker that indicates where the _______ was pressed.
Enter key
CTRL + Enter
Enter the same data (text, values, formulas) into multiple selected cells all at once.
An ___ alerts Excel that you are entering a formula or function and not text.
Equal Sign
To alert Excel that you are entering a formula and not text, type an ___ preceding the formula.
Equal Sign
endnote
Explanatory note that exists at the end of a document
Endnote
Explanatory note that exists at the end of a document.
. After you change the name of the file, if you click the Save button the Save As dialog box apears?
F
. If I want to print multiple copies of a document I select Quick Print from the Office Button Print submenu
F
1. You click the 1-click word indicator will show how many words you have typed
F
14 points equal to about 1/5 of an inch T/F
F
2. The formatting mark will indicate where the document is.
F
2. The insertion point gives you a web site
F
2. The left align in excel align to the right?
F
3. Once text is entered, the aligned cannot be changed
F
3. The insertion point gives you pictures
F
3. The left align in excel align to the bottom of the page
F
3. The nonprinting character will determine where your document is
F
3. When you press the enter key, Word goes directly to the next line in the paragraph without leaving a blank space.
F
As you type the insertion point moves to the left
F
Click size dialog box launcher on insert tab
F
Enter graphic height and width in shape height and shape width text boxes in sizing group in tools tab.
F
Enter graphic width only on format tab
F
Excel includes prewritten formulas called arguments to help
F
Excel includes prewritten formulas called average functions to help
F
The insertion point moves downward to the beginning of the next line
F
When you copy a cell diagonally the cell references Excel adjusts the row portion referencing only higher cells in the workbook
F
When you copy a cell horizontally Excel adjusts the row portion of the cell references
F
Pressing the ____ key instructs Word to replace a building block name with the stored building block entry.
F3
You can select a range using the keyboard, just press the ___ then use the arrow keys to select the desired range.
F8 Key
A blank cell in Excel has the numeric value of -1. T/F
False
A resume allows you to elaborate on positive points in your cover letter.
False
In Word there are only dotted underlines available to use.
False
In Word you CAN NOT acces both decorative underlines and change the color of underlines in the underline gallery.
False
In Word, a paragraph can be both left-aligned and right-aligned at the same time.
False
In the formula =4*6-8, the subtraction operation is completed before the multiplication operation. T/F
False
Magnifying the page shown in print preview in the accompanying figure does affect the printed document.
False
The order of operations is from right to left. T/F
False
The ____ Auto Fill Options that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
Word can be instructed to indent the first line of a paragraph, called _________ as shown in the figure, using the horizontal ruler.
First line indent
The ________ is the top triangle at the 0" mark on the horizontal ruler shown in the figure.
First line indent marker
To assign a dollar sign to appear immediately to the left of the first digit with no spaces, us a ___.
Floating dollar sign
With a graphic selected, click the Recolor button on the ____ tab to display the Recolor gallery shown in the accompanying figure.
Format
As an alternative to using the Recolor button on the Format tab to display the Recolor gallery shown in the accompanying figure, you can right-click the graphic, click ____ on th
Format Picture
A(n) ________ is a character, like the ones in the accompanying figure, that Word displays on the screen but is not a visible on a printed document.
Formatting mark
______________, such as the end-of-cell mark, do not print on a hard copy.
Formatting marks
reference
From within Word, you can search through various forms of ______________ information.
_________ is/are required information for a citation for a buck in MLA style.
Full name of author(s), Edition (if available), and Publication of city
A ___ is a prewritten formula that is built into Excel.
Function
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
Goal
_________ computing involves reducing the environmental waste generalized when using a computer.
Green
Word provides a(n) ____ button, which increases the font size of selected text each time you click the button.
Grow Font
The __________ is the bottom triangle at the 0" mark on the horizontal ruler, shows in the figure.
Hanging Indent Marker
current date page number current time
Headers (as shown in Figure 2-2) and footers can include text and graphics, as well as the _____.
one-half
Headers print in the top margin ____ inch from the top of every page.
The text in a flyer is organized into the following areas:
Headline, signature, body copy
Folder
Helps you organize your files so you can find them quickly.
active cell
Highlighted worksheet cell that is ready for data entry
conditional formatting
Highlights worksheet data by changing the look of cells that meet a specified condition
To change the color of entered text if the Mini toolbar is not displayed, use the Font Color button arrow on the ____ tab.
Home
The ____ function is useful when you want to assign a value to a cell based on a logical test.
IF
#
If a number entered in a cell is too long to fit inside the cell, the number is changed to this.
ALT+CLICKED
If the Research task pane shown in Figure 2-5 does not display a dictionary entry for an ______ word, click the Search for box arrow and then click All Reference Books.
Exactly
If the top of a set of characters is chopped off, then line spacing may be set to ____.
automatic page breaks
If you add text, delete text, or modify text on a page, Word recomputes the location of ___________________ and adjusts them accordingly.
Quick Access Toolbar
If you do not want to keep a change automatically made by Word and you immediately notice the automatic correction, you can undo the change by clicking the Undo button on the ___
Align Text Left
If you have a right-aligned paragraph and you want to make it left-aligned, click the _________ button.
checking spelling
If you have multiple custom dictionaries, you can specify which one Word should use when _________________.
ESCAPE
If you want to remove the AutoCorrect Options button from the screen, you can press the ____ key.
If a flagged word is spelled correctly, right-click it and then click ________ on the shortcut menu to instruct Word not to flag occurrences of the same word in this document.
Ignore All
Row -
In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.
Column -
In a worksheet, the vertical spaces with headings A, B, C, and so on.
optional explanatory
In the MLA style, notes are used only for ________________ notes.
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
Insert
Clicking the ____ opens the Insert Function dialog box shown in the accompanying figure.
Insert Function box on the formula bar
formula
Instructs the software to perform a calculation
Work book
Is like a file that keep all your sheet tabs in one place.
Scroll Lock
Keyboard option that allows a user to scroll through a worksheet without changing the active cell.
____ characters often are used in a table of contents to precede page numbers.
Leader
The small square at the 0" mark on the horizontal ruler shows in the figure is the ________, which can be used to change the entire left margin
Left indent marker
border button
Located on the ribbon and used to show the borders gallery
The ____ function displays the highest value in a range.
MAX
The ___ function is used to determine the lowest number in a given range.
MIN
The ____ function determines the lowest number in a range.
MIN
ALT + Enter
Manually start a new line in a cell.
Use the ___ function to display the highest value in a range.
Max
32,000
Maximum number of characters a cell can contain.
16384
Maximum number of columns in an Excel 2007 spreadsheet.
1,048,576
Maximum number of rows in an Excel 2007 spreadsheet.
The ____, which automatically appears based on certain tasks you perform, contains commands related to changing the appearance of text in a document.
Mini toolbar
When you move the mouse pointer into the transparent ____, it changes to a bright toolbar.
Mini toolbar
To search for formatting or a special character, click the __________ button to expand the Find Dialog box.
More
Dialog box
More commands located within the groups.
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
NOW
To display the New Document dialog box, click the Office Button and then click ___________.
New
17,179,869,184
Number of cells in an Excel 2007 worksheet.
15
Number of digits up to which Excel is precise.
The ____________________ shown in the accompanying figure is a temporary storage area that can hold up to 24 items (text or graphics) copied from any Office application.
Office clipboard
DELETE
One way to delete a note is to click immediately to the left of the note reference mark in the document text and then press the ____ key twice.
The order in which calculations are performed in a formula is called the _____.
Order of Operations
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout
________ is the process of changing the appearance of a paragraph.
Paragraph formatting
The ________ displays when you drag and drop text and allow you to change the format of the text that was moved.
Paste Options button
________ is the process of copying an item from the Office Clipboard into the document at the location of the insertion point.
Pasting
You should use a ____ chart to show the relationship or proportion of parts to a whole.
Pie
___ allows you to select cells for use in a formula by using the mouse.
Point Mode
Shift + tab
Press these keys on the keyboard to move the insertion point to the previous cell.
F1
Press this function key to display the Excel Help window.
Tab
Press this key on the keyboard to move the insertion point to the next cell.
In Word, you can create electronic image files through the ________ tan in the Backstage view.
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery, as shown in the accompanying figure.
Print Selection
To print a mailing label, click the Labels tab in the Envelopes and Labels dialog box, type the delivery address in the Address box, and then click the ______ in the dialog box
Print button
If you do not want to keep a change automatically made by a Word and you immediately notice the automatic correction, you can undo the changes by clicking the Undo button on the _________ toolbar.
Quick Access Toolbar
QAT
Quick Access Toolbar
To move to the right one word, press the _______ key(s).
RIGHT+ARROW
An easy way to verify that a formula references the cells that you want it to reference is to use Excel's _____.
Range Finder
You can ensure correctness in your formulas by carefully checking them using ____.
Range Finder
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
To convert a hyperlink e-mail address to regular text, right-click the e-mail address and then click ____ on the shortcut menu.
Remove Hyperlink
CTRL + Backspace
Returns to the active cell when scroll lock is on.
Home
Ribbon tab that consists of the Clipboard, Fonts, Alignment, Number, Styles, Cells, and Editing groups.
Formulas
Ribbon tab that consists of the Function Library, Defined Names, Formula Auditing, and Calculation groups.
Data
Ribbon tab that consists of the Get External Data, Connections, Sort & Filter, Data Tools, and Outline groups.
Review
Ribbon tab that consists of the Proofing, Comments, and Changes groups.
Insert
Ribbon tab that consists of the Tables, Illustrations, Charts, Links, and Text groups.
Page Layout
Ribbon tab that consists of the Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange groups.
View
Ribbon tab that consists of the Workbook Views, Show/Hide, Zoom, Window,and Macros groups.
____ text often provides a strong visual appeal.
Rotated
Numbers
Rows in a worksheet are labeled with these
Press ____ to create a line break, which advances the insertion point to the beginning of the next physical line, ignoring any paragraph formatting instructions.
SHIFT+ENTER
You can select characters by using the ______key(s).
SHIFT+RIGHT ARROW
To move from the second cell in the table in the accompanying figure back to the previous cell, press ____.
SHIFT+TAB
Some ___________ available in the Research task pane, as shown in the figure, include a dictionary and, if you are connected to the Web, a search engine and other Web sites.
Services
Using word, you can easily can change the _______ of text.
Shape, color, and size
Formula bar
Shows a cell's contents.
If you click the Grow Font button too many times and make the font size too big, you can click the ____ button until the desired font size is displayed.
Shrink Font
To see the height and width of the currently graphics, as shown in the figure, look in the ________ group on the Picture Tools Format Tab.
Size
currency authority accuracy
Sources should be evaluated for ____.
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
Sparkline
To search for a special character, use the _________ button in the expanded Find dialog box.
Special
Excel has a ___ you can use to check the worksheet for spelling errors.
Spell Checker
When you begin typing text, the _________ appears on the status bar with an animated pencil wiring on paper that indicates Word is checking for spellings and grammar errors.
Spelling and Grammar check icon
____ properties are associated with all Microsoft Office documents and include author, title, and subject.
Standard
. I am able to select the Quick print option in the Print submenu multiple times to print multiple copies of my document?
T
. The insertion point is a blinking vertical bar that indicated where text, graphics, and other items will be inserted.
T
. To save the file with a different file name or on different media, display the Save As dialog box?
T
1. In Excel, if you enter text in a cell it will automatically become aligned to the left.
T
1. The insertion point is a blinking vertical bar
T
1. The left align in excel automatically align to the left?
T
1. To indicate where in a document you press the enter key or spacebar
T
1. True or False: Each time you press the enter key, Word creates a new paragraph.
T
2. Excel treats all characters as text
T
2. The 1-click word indicator will show you how many paragraphs
T
4. In Excel, if you enter text in a cell it will automatically become aligned to the left.
T
Each time you press the enter key, Word inserts blank space between the two paragraphs.
T
Excel includes prewritten formulas called functions to help.
T
The default row height in a blank worksheet is 15 points T/F
T
To diplay the Save As dialog box, click the Office Button in the top left hand corner of the screen?
T
To print multiple copies of a document, click Print in the Office Button submenu and increase the number in the number of copies box?
T
When you copy a cell downward Excel adjusts the row portion of the cell references
T
You can change the width of columns or height of the rows at anytime
T
the values that you use with a function are called arguments.
T
To advance rightward from one cell to the next in a table, press the ____ key.
TAB
Sheet Tabs -
Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook
____ is/are used to add worksheet, column, and row titles on a worksheet.
Text
header
Text and graphics that prints at the top of each page in a document
left alignment
Text is lined up against the left margin.
Number
The Accounting Number Format button is located in this group in the Home tab.
double-space
The MLA documentation style requires that you ____________________ the entire research paper; that is, one blank line should display between each line of text.
alphabetical order
The MLA style requires that the works cited be listed in _________________ by the author's last name or, if the work has no author, by the work's title.
parenthetical citations
The MLA style uses in-text ____________________ instead of noting each source at the bottom of the page or at the end of the paper.
works cited
The MLA style uses the term ____________________ for the bibliographical list of sources.
lines characters paragraphs
The Word Count button on the Review tab displays the number of words as well as the number of _____ in the current document.
Clipboard
The ____ is a temporary Windows storage area.
CTRL+SPACEBAR
The ____ shortcut keys remove character formatting
CTRL+SHIFT+W
The ____ shortcut keys underline words, and not spaces.
Paste Options button
The ____________________ displays when you drag-and-drop text and allows you to change the format of the text that was moved.
Click and Type
The ____________________ feature can be used to format and enter text, graphics, and other items.
hanging indent marker
The ____________________ is the bottom triangle at the 0" mark on the horizontal ruler.
First Line Indent marker
The ____________________ is the top triangle at the 0" mark on the horizontal ruler shown in Figure 2-3.
works cited
The bibliographic list of sources at the end of an MLA-styled research paper
Active Cell -
The cell in your worksheet that has been selected. It will have bolder gridlines around it.
an introduction a conclusion the body sources
The first draft of a research paper should include ____.
row height
The height of a row in a table, measured in inches.
Gridlines
The horizontal and vertical lines that define the cells in a worksheet area are referred to as this.
Headings -
The identifying letters and numbers for columns and rows. Columns are identified with letters, rows with numbers.
Label -
The identifying name that reflects the information contained in a column or row in a worksheet, such as name or date.
Cell
The intersection of a row and a column
Cell Grid -
The lines on your worksheet that separate the columns and rows.
Cell -
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.
when you copy a formula with relative cell references down a row, ___
The row references change in the formula
one
The rule is to press the SPACEBAR ____ time(s) after periods, colons, and other punctuation marks
superscript
The shortcut keys for the _____ character formatting are CTRL+SHIFT+PLUS SIGN.
CTRL+E
The shortcut keys used to center a paragraph are ____.
CTRL+L
The shortcut keys used to left-align a paragraph are ____.
Left Indent marker
The small square at the 0" mark on the horizontal ruler shown in Figure 2-3 is the ____________________, which can be used to change the entire left margin.
Autofill
This feature will automatically insert words, numbers, or formulas in a series.
Fill handle
This is the name of the small black square that displays in the bottom right corner of the active cell.
Right-click
To add any option from the Office button or the Ribbon to the QAT.
CTRL+SHIFT+<
To decrease a font size, use the ____ shortcut keys.
CTRL+M
To increase a paragraph indent, use the _____ shortcut keys.
cut-and-paste
To move text, you first select the text to be moved and then use drag-and-drop editing or the ___________ technique to move the selected text.
page number
To place your name to the left of the page number, as shown in Figure 2-2 and as required by the MLA style, you must create a header that contains the __________.
CTRL+R
To right-align a paragraph, use the ____ shortcut keys.
Special
To search for a special character, first click the More button in the Find dialog box and then use the ____ button.
SHIFT
To select a block of text, click at the beginning of the selection, scroll to the end of the selection, position the mouse pointer at the end of the selection, hold down the ____
CTRL
To select a sentence, press and hold down the ____ key and then click the sentence.
Ctrl
To select nonadjacent columns using the mouse, hold down this key on the keyboard while clicking the column headers.
document
To use Click and Type, you double-click a blank area of the _____________ window.
The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
A condition for a cell can only be true or false. T/F
True
Each time the ENTER key is pressed, any custom tab stops are carried forward to the next paragraph.
True
Hiding cells is a technique you can use to hide data that you do not want others to see. T/F
True
Point mode allows you to create formulas using the mouse. T/F
True
Pressing the F9 key instructs Excel to recalculate all formulas. T/F
True
To use Range Finder to verify that a formula contains the intended cell reference, double-click the cell containing the formula you want to check. T/F
True
When an error occurs in a formula in a cell, Excel displays the Trace Error button next to the cell, and places a green triangle in the upper left of the cell. T/F
True
Word has many different decorative underlines.
True
The ____ button is located on the Quick Access Toolbar, as shown in the accompanying figure.
Undo
Sum button
Use this button in the Editing group in the Home tab to insert a formula in a cell.
parenthetical citations
Used in MLA style instead of noting each source at the bottom of the page
Click and Type
Used to format and enter text, graphics, and other items
shortcut keys
Used to format text as you type it
writer's name
Using the MLA style of documentation, the title of the paper is centered one double-space below the ________ and course information.
Many word processing documents use _______ character fonts, where some characters are wider than others.
Variable
shortcut keys
When fingers are already on the keyboard, it often is more efficient to use ____________________, or keyboard key combinations, to format text as it is typed.
AutoCorrect Options button
When the ____________________ is clicked, Word displays a menu that allows a correction to be undone or changes how Word handles future automatic corrections of this type.
synonym
When the same word is used in multiple locations or a word is used that was not quite appropriate, a thesaurus can be used to look up a(n) _____, or a word similar in meaning
Hanging Indent
When you drag the ______________ marker, the Left Indent marker moves with it.
services
When you install Word, it selects a series of ____ through which it searches when you use the Research task pane shown in Figure 2-5.
Drag -
When you move the mouse while holding down the mouse button (usually the left) to select a range of cells.
menu
When you point to an icon on the Select Browse Object menu, Word displays the associated command name at the top of the ____________.
Sheet Tab
Where each worksheet name appears.
map memo letter
Which of the following is a bibliographic source?
proofreading
While ____________________, you review a document to look for grammatical errors and spelling errors.
drag-and-drop
With ____ editing, the selected item is moved to the new location and then inserted there.
You can enter functions
With the keyboard or mouse The sum menu And the Insert Function box in the formula bar
Average function
With this function, a range of cells is added together and then divided by the number of cell entries
note reference mark
Word automatically numbers notes sequentially by placing a(n) ____________________ in the body of the document and also to the left of the note text.
first-line indent
Word can be instructed to indent the first line of a paragraph, called ____________________, using the horizontal ruler shown in Figure 2-3.
autocorrect
Word feature that fixes errors as you type them in a document.
AutoCorrect
Word feature that fixes errors as you type them in the document
AutoCorrect
Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct.
AutoCorrect
Word provides a(n) ____________________ feature that automatically corrects some typing, spelling, capitalization, or grammar errors as they are typed in a document.
AutoComplete
Works only within contiguous cells. If a row is blank, it identifies only the cell contents below the blank row.
Spelling and Grammar
You can use the Ignore All button in the ______________ dialog box.
set tab stops change page margins adjust column widths
You can use the rulers to ____.
Date viewed Title of Web site Web address
____ is required information for a citation for a Web site in MLA style.
Pasting
____ is the process of copying an item from the Clipboard into the document at the location of the insertion point.
Full name of author(s) Edition (if available) Publication city
____ is/are required information for a citation for a book in MLA style.
line spacing
____________________ is the amount of vertical space between lines of text in a document.
metaphysics
a branch of philosophy tha tinvestigates the ultimate nature of reality
relative cell reference
a cell reference based on the relative position of the cell that contains the formula and the cells refered to
column heading
a column letter above the grid that identifies each column
data marker
a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point
chart layout
a combination of chart elements, which can include a title, legend, labels for the columns, and the table of charted cells
alloy
a combination; a mixture of two or more metals
Formula
a combo of cell references, operators, values, and/or functions used to perform a calculation
satyr
a creature that is half-man, half beast, with the horns and legs of a goat
cell style
a defined set of formatting characteristics, such as font, font size, font color, cell borders and cell shading
Workbook
a file containing related worksheets
syllogism
a form of deductive reasoning with a major premise, a minor premise, and a conclusion
encomium
a formal expression of praise
AutoSum
a function that automatically adds the values in the cells directly above or to the left of the active cell
Autosum
a function that automatically adds the values in the cells directly above or to the left of the active cell
chart
a graphic representation of data in a worksheet
Range-
a group of cells
series
a group of things that come one after another in succession
row
a horizontal group of cells
odyssey
a long, adventurous voyage; a quest
fracas
a loud quarrel; brawl
nexus
a means of connection; a center
row heading
a number at the far-left side of a row that can be clicked to select the entire row of cells
value
a number that represents a quantity or an amount
blank cell
a numerical value of zero
fresco
a painting done on plaster
conscript
a person compulsorily enrolled for military service
factotum
a person who does all sorts of work; a handyman
shard
a piece of broken glass or pottery
Field
a placeholder for data whose contents can change.
usury
a practice of lending money at exorbitant rates
rounding
a procedure that determines which digit at the right of the number will be the last digit displayed and then increases it by one if the next to its right is 5-9
Output area
a range of cells containing results based on manipulating the variables
Input area
a range of cells containing values for variables used in formulas
Range
a rectangular group of cells
Fill handle
a small green square at the bottom-right corner of a cell
smart tag indicator
a small purple triangle in a cell that indicates that a smart tag is available
microcosm
a small system having analogies to a larger system
clique
a small, exclusive group
argot
a specialized vocabulary used by a group
gerneral format
a specific way in which Excel displays numbers, the default number format
Worksheet
a spreadsheet that contains formulas, functions, values, text & visual aids
asterisk
a star-shaped character * used in printing
asterisk
a star-shaped character * used in printing also used in multiplication formulas
elixir
a sustance believed to have the power to cure ills
a system of world-wide electronic communication in which a computer user can compose a message at one terminal that is generated at the recipient's terminal when it logs in
hieroglyphics
a system of writing in which pictorial symbols represent meanings or sounds; wirting or symbols that are difficult to decipher
hiding cells
a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want to see otherwise
apothegm
a terse, witty saying
label
a text value
torque
a turning or twisting force
data point
a value that originates in a worksht cell
menagerie
a variety of animals kept together
column
a vertical group of cells in a worksheet
cataclysm
a violent upheaval that causes great destruction and change
spreadsheet
a worksheet, one page in a workbook with rows and columns
solvent
able to meet financial obligations
Borders may be added ____ a paragraph.
above below
anarchy
absence of government; state of disorder
categorical
absolute; without exception
recondite
abstruse, profound
copious
abundant; plentiful
credence
acceptance of something as true
digression
act of straying from the main point
transgression
act of trespassing or violating a law or rule
Word provides a means of canceling your recent _______.
actions, commands
Autofit
adjusts the width of a column to fit the cell content of the widest cell in the column
estimable
admirable; possible to estimate
gustatory
affecting the sense of taste
truculence
aggressiveness, ferocity
amenable
agreeable; cooperative; suited
tryst
agreement between lovest to meet, rendez-vous
Essential business letter elements include the ____.
all of the above
mitigate
alleviate; to become less severe
Page Layout View
allows you to create or modify a worksheet while viewing how it will look in printed format
Point mode
allows you to select cells for use in a formula by using the mouse
reparation
amends, compensation
aggregate
amounting to a whole; total
thespian
an actor or actress
herbivorous
an animal that feeds mainly on plants
formula
an equation that performs mathematical calculations on values in your worksheet
canon
an established set of principles; a basis or standard for judgment; a group of literary works
Tag name
an identifier that links a citation to a source.
denizen
an inhabitant; a regular visitor
function
an input-output relationship that has exactly one output for each input
fauna
animals of a period o region
caste
any of the hereditary social classes in Hindu society; social stratification
phoenix
anything that is restored after suffering great destruction
cell content
anything you type in a cell; most common values are text values and number values
simian
apelike, relating to apes
visage
appearance, aspect
floating dollar sign
appears immediately to the left of the first digit with no spaces, use the Currency Style in the Format Cell dialog box
Accounting number format
applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis when negative numbers are present
fiat
arbitray order; authorization
addition
arithmetic operator that adds contents of cells
subtraction
arithmetic operator that subtracts contents of cells
exponentiation
arithmetic operator used to raise to a power
stratified
arranged in layers
treatise
article treating a subject systematically and thoroughly
collage
artistic composition of materials pasted over a surface; an assemblage of diverse elements
iconoclastic
attacking cherished traditions
The _______ feature automatically corrects typing, spelling, capitalization, or grammar errors, as you type them.
autocorrect
Word provides a (n) ____________ feature that automatically corrects some typing, spelling, capitalization, or grammar errors as they are typed in a document.
autocorrect
homeostasis
automatic maintenance by an organism in balance with itself
As documents that exceed one page are typed, Word automatically inserts a page breaks like those in the figure, called __________, when it determines the text has filled one page according to paper size, margin settings, line spacing, and other settings.
automatic page breaks, soft page breaks
sentient
aware, concious, able to preceive
Beach page repagination is performed between key strokes, Word refers to the task of creating automatic page breaks, like the one shown in the figure, as___________.
background repagination
spectrum
band of color, broad range of related ideas or objects
fallacious
based on a false idea or fact; misleading
ethnocentric
based on the attitude tha one's group is superior
mendicant
beggar
fledging
beginner; novice
sedition
behaviour prompting rebellion
tenet
belief, doctrine
suppliant
beseeching
nonplussed
bewildered
diatribe
bitter verbal attack
necromancy
black magic
A ____ cell in Excel has a numerical value of zero.
blank
In the ____ letter style, all components of the letter begin flush with the left margin.
block style
The most popular background color is _____.
blue
The _______ copy in a flyer consists of all text between the headline and the signature line.
body
audacious
bold; daring
brazen
bold; shameless
tome
book, usually large and academic
In Word, a solid line, called a(n) ____________________, can be drawn at any edge of a paragraph.
border
blase
bored because of frequent indulgence; unconcerned
When using the MLA style, position explanatory notes either at the _____, as shown in Figure 2-1.
bottom of the page as footnotes or at the end of the paper as endnotes
epistemology
branch of philosophy tha texamines the nature of knowledge
compendium
brief, comprehensive summary
luminous
bright; brilliant; glowing
lucid
bright; clear; intelligible
refulgent
brightly shining, resplendent
If the same text is used frequently, the text can be stored in a(n) ____________________ and then the stored entry can be used throughout the open document, as well as in future
building block
Useful when you use the same text or graphic frequently.
building block
A(n) ____ is a dot or other symbol positioned at the beginning of a paragraph.
bullet
A(n)___________ list is a series of paragraphs, each beginning with a bulleted characters.
bulleted
onerous
burdensome
caustic
burning; stinging; causing corrosion
center button
button on the ribbon used to center text in a cell
placid
calm
halcyon
calm and peaceful; happy; golden; prosperous
Comma style format
can be assigned to a range of cells by clicking the Comma style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths
malleable
capable of being shaped by pounding; impressionate
prehensile
capable of grasping
punctilious
careful in observing rules fo behavior
wary
careful, cautious
inadvertenly
carelessly; unintentionally
etiology
causes or origins
In a Word table, the intersection of a row and a column is called a(n) ____________________, and is filled with text.
cell
The intersection of a row and column.
cell
To enter data in a cell, you must first select or activate the ____.
cell
On the horizontal ruler, an upside down T indicates a ____ tab stop.
centered
When a headline is _________ it is positioned horizontally between the left and right margins on the page.
centered
metamorphosis
change; transformation
______ is the process of changing the way characters appear on the screen and in print.
character formatting
bucolic
characteristic of the countryside; rustic; pastoral
The Word Count dialog box displays the number of words as well as the number of _________ in the current document.
characters, lines, paragraphs
talisman
charm to bring good luck and avert misfortune
A(n) ____ is a separate sheet in a workbook that contains only a chart.
chart sheet
alacrity
cheerful willingness; eagerness; speed
geniality
cheerfulness; kindliness; sociability
A tag name is an identifier that links a _________ to a source.
citation
In Word the term, ____________________, refers to returning the formatting to the Normal style.
clear formatting
limpid
clear; transparent
When a custom tab stop is set, Word ____.
clears all default tab stops to the left of the custom tab stop
To remove an embedded chart, you should ____ it and press the DELETE key.
click
A predefined graphic.
clip art
raiment
clothing
gauche
coarse and uncouth; clumsy
implode
collapse inward violently
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
colon (:)
You can drag a(n) ____________________, which is the border to the right of a column, until the column is the desired width.
column boundary
banal
commonplace; trite
analogous
comparable
simile
comparison of one thing with another using "like" or "as"
imbroglio
complicated situation; an entanglement
homogeneous
composed of identical parts; uniform in composition
equanimity
composure; calmness
celestial
concerned with sky or heavens; sublime
metereological
concerned with the weather
solicitous
concerned, attentive, eager
olfactory
concerning the sense of smell
coda
concluding part of a literary or musical composition; something that summarizes or concludes
inveterate
confirmed; long standing
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
constant
discrete
constituing a separate thing; distinct
introspective
contemplating one's own thoughts and feelings
A(n) ____ contains instructions for filling areas of a template.
content control
Contains instructions for filling areas of a template.
content control
propriety
correct conduct, fitness
debauchery
corruption
mettle
courage; endurance
A(n) ____________________ enables you to elaborate on positive points in your resume, and to show a potential employer your writing skills.
cover letter
Enables you to elaborate on positive points in your resume.
cover letter
hirsute
covered with hair
craven
cowardly
pusillanimous
cowerdly
bovine
cowlike
machiavellian
crafty; double-dealing
fissure
crevice
exigency
crisis; urgent requirements
Headers (as shown in the figure) and footers can include text and graphics, as well as the _____________.
current date, page number, and current time
imprecation
curse; damnation
convex
curved outward
concave
curving inward
sardonic
cynical, scornfully mocking
stygian
dark and gloomy, hellish
displayed value
data that displays in a cell
underlying value
data that displays in the formula bar
underlying valueu
data that displays in the formula bar
In a business letter, the ____________________, which consists of the month, day, and year, is positioned two to six lines below the letterhead.
date line
internecine
deadly to both sides
profound
deep, not superficial
In Word, the _______ font usually in Calibri.
default
Elysian
delightful; blissful
megalomania
delusions of power or importance
pathological
departing from normal condition
effete
depleted of vitality; overrefined; decadent
empirical
derived from observation or experiment
covetous
desiring something owned by another
If the e-mail address shown in the accompanying figure had just been pasted into the cover letter shown, that would make this letter the ____ document.
destination
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ____.
destination area (or paste area)
resolve
determination, firmness of purpose
resolution
determination, resolve
Which of the following is a suggested decision to make when you plan a workbook?
determine the necessary functions and formulas needed
MIN function
determines the lowest number in the range
execrable
detertable; abhorrent
aberrant
deviating from what is normal
piety
devoutness
discrepancy
difference between
sedulous
diligent, assiduous
assiduous
diligent; hard-working
The total number of rows and columns required in a table.
dimension
When inserting a table, the total number of rows and columns required must be specified, which is called the ____________________ of the table.
dimension
dissonance
discord; lack of harmony
mendacious
dishonest
dissolution
disintegration;debauchery
antipathy
dislike; hostility
contumacious
disobedient; rebellious
Ctrl+` is used to...
display cell formulas
sheet tab scrolling buttons
display sheet tabs that are not in view when there are numerous sheet tabs
vertical ruler
displays along the left edge of the Word Window.
Chart styles gallery
displays an array of predefined chart styles
Accounting Number Format
displays numbers with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, an displays numbers to the nearest cent (hundredths place)
Formula bar
displays the content (text. value, date, or formula) in the active cell
status bar
displays the current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average
MAX function
displays the highest value in a range
Sheet tab
displays the name of a worksheet within a workbook
name box
displays the name of the selected cell, table, chart or object
vivisection
dissection, surgery, or painful experiments performed on a living animal for the purpose of scientific research
maverick
dissenter
disparate
dissimilar
multifarious
diverse
Some compound words should not be ______at the end of a line.
divided
dichotomy
division into two usually contradictory parts
vertigo
dizziness
doctrinaire
dogmatic; unyielding
latent
dormant; potential not apparent
Fill handle -
dot at bottom right of each cell; used to copy information from cell to cell
You should ____ a function name in the Formula AutoComplete list to select the function.
double-click
The MLA documentation style requires that you ___________ the entire research paper; that is, one blank line should display between each line of text
double-space
Using the mouse to move or copy cells is called ____.
drag and drop
With __________ editing, you select the text to be moved and then drag the selected item to the new location and then insert it there.
drap-and-drop
terrestrial
earthly, commonplace
irascible
easily angered
gullible
easily deceived
efficacy
effectiveness; efficiency
panegyric
elaborate praise; formal hymn of praise
Typing text, followed by two hyphens, followed by more text and then a space changes the two hyphens to a(n) ____.
em dash
A(n) ____ chart is drawn on the same worksheet as the data.
embedded
vacuous
empty, void, lacking intelligence
levee
en embankment that prevents a river from overflowing
flourish
en embellishment or ornamentation
Auto fill
enables you to copy the contents of a cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells
Each cell in a Word table has a(n) ____________________, which is a formatting mark that assists with selecting and formatting cells.
end of cell mark
Each time ________ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.
enter
To enter a blank line into a document, press the _______ key without typing any text on the line.
enter
substantive
essential
If the top of a set of characters is chopped off, then line spacing may be set to _______
exactly
plethora
excess; overabundance
rococo
excessively ornate
egotistical
excessively self-centered; conceited
ebullient
exhilarated; overly enthusiastic
concomitant
existing concurrently
feral
existing in a wild or untamed state
salutary
expecting an improvement, favorable to health
connoisseur
expert in matters of taste; expert knowledge or training
expository
explanatory
A Pie chart with one or more slices offset is called a(n) ____.
exploded Pie chart
reverent
expressing deep respect, worshipful
distill
extract the essential elements
penury
extreme poverty
arduous
extremely difficult; laborious
harrowing
extremely distressing; terrifying
stentorian
extremely loud
lilliputian
extremely small
physiognomy
facial features
perfidious
faithless; disloyal; untrustworthy
calumny
false and malicious accusation; slander
canard
false; deliberately misleading story
kudos
fame; glory; honor
whimsical
fanciful, unpredictable
captious
faultfinding; intended to entrap, as in an argument
trepidation
fear and anxiety
euphoria
feeling of extreme happiness
capricous
fickle
A __________ is a placeholder for data whose contents can change.
field
sordid
filthy, contemptible and corrupt
squalor
filthy, wretched condition
inherent
firmly established by nature or habit
In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a ____ dollar sign.
fixed
toady
flatterer, yes-man
blandishment
flattery
pique
fleeting feeling or hurt pride
flux
flowing; a continuous moving
glib
fluent in an insincere way; offhand
jocose
fond of joking; jocular
affinity
fondness; liking; similarity
The ________, or typeface, defines the appearance and shape of letters, numbers, and special characters.
font
fatuous
foolishly self-satisfied
A note reference make signals that an explanatory note exists at the bottom of the page as a _________ as in the figure
footnote
precursor
forerunner; predecessor
premonition
forewarning; presentiment
oligarchy
form of government in which power belongs to only a few leaders
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
onomatopeia
formation or use of words that imitate sounds of the actions they refer to
Wrap text
formatting that enables a label to appear on mult. lines within the current cell
redoubtable
formidable, arousing fear
disabuse
free from a misconception
guileless
free of cunning or deceit; artless
repine
fret, complain
In a business letter, the inside address usually contains the addressee's ____.
full geographical address
mettlesome
full of courage and fortitude
porous
full of holes; permeable to liquids
square function
function used to raise to a power
rationale
fundamental reason
obsequy
funeral ceremony
dirge
funeral hymn
meretricious
gaudy; specious; flasely attractive
Auto Fill
generates and extends a series of values into adjacent cells based on hte value of other cells
magnaminity
generosity; nobility
saturnine
gloomy
theocracy
government by priests representing a god
Files containing ____ are available from a variety of sources.
graphics
ardor
great emotion or passion
avarice
greed
junta
group of people united in political intrigue
accretion
growth in size or increase in amount
artless
guileless; natural
indolent
habitually lazy; idle
A (n) ____________ is a type of paragraph formatting in which the first line extends to the left if the rest of the paragraph.
hanging indent
esoteric
hard to understand; known only to a few
inured
hardened; accustomed; used to
innocuous
harmless
astringent
harsh; severe
jaundiced
havind a yellowish discoloration of the skin; affected by envy
fetid
having a bad smell
incarnate
having bodily form
tortuous
having many twists and turns, highly complex
stolid
having or showing little emotion
existential
having to do with existence
A (n) __________, like the figure, is text printed at the top of each page in a document.
header
salubrious
healthful
covert
hidden; secret
eulogy
high praise to a death person
hallowed
holy; sacred
To move to the beginning of a line with the keyboard, press the _____ key(s).
home
facetious
homorous
probity
honesty; high-mindness
Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the _____________.
horizontal ruler
cornucopia
horn overflowing with fruit and grain; state of abundance
behemoth
huge creature; anything very large and powerful
juggernaut
huge froce destrying everything in its path
Name box
identifies the address of the current cell
idolatry
idol worship; blind or excessive devotion
morose
ill-humored; sullen
saturate
imbue througout, soak thoroughly
peremptory
imperative; leaving no choice
inchoate
imperfectely formed or formulated
ramification
implication, consequence
implicit
implied; understood but not stated
Web query
import data stored on a website using this
impermeable
impossible to permeate
atavism
in biology, the reappearance of a characteristic in an organism after several generations of absence; individual or a part that exhibits atavism; return of a trait after a period of absence
extant
in existence; not lost
dormant
inactive
lethargic
inactive
quiescent
inactive, still
distrait
inattentive; preoccupied
impervious
incapable of being affected; impossible to penetrate
immutable
inchangeable
penchant
inclination
propensity
inclination, tendency
text
includes letters, numbers, symbols & spaces
expand formula bar button
increases the height of the formula bar to display lengthy cell content
expand horizontal scroll bar button
increases the width of the horizontal scroll bar
untenable
indefensible
apathy
indifference
insouciant
indifferent; lacking concern or care
futile
ineffective; useless; fruitless
implacable
inflexible; incable of being pleased or calmed down
cognizant
informed; conscious; aware
endemic
inherent; belonging to an area
The default typing mode in Word is _________ mode.
insert
In ___________, as a character is typed Word inserts the character and moves all the characters to the right of the typed character one position to the right.
insert mode
The ____ is a blinking vertical line that indicates where the next typed character will appear.
insertion point
When you use the keyboard to scroll to a different position int he document, the _______automatically moves when you press the desired keys.
insertion point
Comma stye
inserts thousand comma separators where appropriate and applies two decimal places
inconsequencial
insgnificant; unimportant
cant
insincere talk; language of a particular group
insuperable
insurmountable; unconquerable
subversive
intended to undermine or underthrow, especially an established government
equivocate
intentionally use vague language
interregnum
interval between reigns; gap in continuity
sinuous
intricate, complex
incorporate
introduce something into another thing already in existence
causal
involving a cause
sporadic
irregular
anomalous
irregular; deviating from the norm
cantankerous
irritable; ill-humored
vexation
irritation, annoyance
relative cell references
is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location
In the accompanying figure, the split double arrow mouse pointer ____.
is the result of moving the mouse pointer to the boundary between column heading A and column heading B
artifact
item made by human craft
Microsoft Office Word 2007
j
patois
jargon; a regional dialect
Merge & Center
joins selected cells into one larger cell and centers the contents in the new cell
Business documents can include all of the following EXCEPT ____.
journals
warranted
justified
_________ are words or phrases that describe a document.
keywords
beneficent
kindly; doing good
category labels
labels that display along the bottom of the chart to identify the category of data; category axis or the x-axis
pallid
lacking color or liveliness
insipid
lacking in flavor; dull
disjointed
lacking order or coherence; dislocated
salacious
lascivious, lustful
To center a page's contents vertically between the top and bottom margins, click the Page Setup Dialog Box Launcher, click the ________ tab, click the vertical alignment box arrow, click center in the list, and then click the OK button.
layout
erudite
learned; scholarly
When you first create a table it is left-aligned; that is, flush with the____________ .
left margin
litigation
legal proceedings
In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet.
legend
litany
lengthy recitation; repetitive chant
torpor
lethargy, dormancy, sluggishness
lassitude
lethargy; sluggishness
Preprinted on stationery that everyone in the company uses for correspondence.
letterhead
levity
light manner or attitude
avuncular
like an uncle, benevolent and tolerant
labile
likely to change
invidious
likely to provoke ill will
modicum
limited quantity
qualified
limited, restricted
A ____ is a formatting mark at the end of a line that moves the insertion point to the beginning of the next physical line.
line break character
________ is the amount of vertical space between lines of text in a documents.
line spacing
soliloquy
literary or dramatic speech by one character, not adressed to others
To move a custom tab stop, drag the tab marker to the desired _______on the ruler.
location
harangue
long, pompous speech; tirade
tirade
long, violent speech, verbal assault
strident
loud, harsh, unpleasantly noisy
fidelity
loyalty; exact correspondence
lascivious
lustful
supine
lying in the back, marked by lethargy
All of the following are guidelines about the appearance of letterhead elements EXCEPT ____.
make the font size of your name the same size as the rest of the text in the letterhead
Because the works cited are to display on a separate numbered page, a (n) ________ must be inserted at a specific location following the body of a research paper.
manual page break, hard page break
motley
many colored; made up of many parts
Bibliographic sources
map, memo, and letter
stigma
mark of disgrace or inferiority
staccato
marked by abrupt, clear-cut sounds
intimate
marked by close acquaintance
striated
marked with thin, narrow grooves or channels
quagmire
marsh, difficult situation
normal view
maximizes the number of cells visible on your screen and keeps the column letters and row numbers closer
prattle
meaningless, foolish talk
best fit
means that the width of the column will be increased or decreased so the widest entry will fit in the column
analgesic
medication that reduces or eliminates pain
nostrum
medicine or remedy of doubtful effectiveness
alchemy
medieval chemical philosophy based on changing metal into gold; a seemingly magical power or process of transmutation
plaintive
melancholy; mournful
formidable
menacing; threatening
venal
mercenary, corruptible
euthanasia
mercy killing
Combining two or more selected cells into one cell is called ____ cells.
merging
In a business letter, the complimentary close displays two lines below the last line of the____________ .
message
__________ is another term for document properties
metadata.
workbook-level buttons
minimize, close, or restore the previous size of the displayed workbook
abject
miserable; pitiful
errant
mistaken; straying from the proper course
miscellany
mixture of writtings on various subjects
paragon
model of perfection or excellence
abstemious
moderate in appetite
lucre
money or profits
reprobate
morally unprincipled person
centrifugal
moving away from a center
undulating
moving in waves
centripetal
moving or directed toward a center
turbid
muddy, opaque, in a state of great confusion
uncanny
myterious, strange
ingenous
naive and trusting; lacking sophistication
appellation
name
insularity
narrow-mindedness; isolation
sextant
navigation tool that determines latitude and longitude
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
nested
neologism
new word or expression
defunct
no longer existing
clamor
noisy outcry
Press CTRL+SHIFT+HYPHEN to enter a(n) ____________________, which is a special type of hyphen that prevents two words separated by a hyphen from splitting at the end of a line.
nonbreaking hyphen
Press CTRL+SHIFT+SPACEBAR to enter a(n) ____________________, which is a special space character that prevents two words from splitting if the first word falls at the end of a li
nonbreaking space
reticent
nor speaking freely, reserved, reluctant
disingenuous
not candid, crafty
imperturbable
not easily disturbed
intractable
not easily managed
extraneous
not essencial
unfeigned
not false, genuine
untoward
not favorable, troublesome, unruly
discordant
not in tune
extrinsic
not inherent of essential
intangible
not material
ineluctable
not to be avoided or escaped; inevitable
heterodox
not widely accepted
Word automatically numbers notes sequentially by placing a __________ in the body of the document and also to the left of the note text.
note reference mark
subpoena
notice ordering someone to appear in court
neophyte
novice; beginner
quorum
number of memeber necessary to conduct a meeting
tractable
obedient, yielding
A letterhead should contain all of the following EXCEPT ____.
objective
bawdy
obscene
cardinal
of foremost importance
carnal
of the flesh or body; related to physical appetities
value axis
on the left of the chart, excel includes a numerical scale on which the charted data is based; y-axis
legend
on the right, identifies the tterns or colors that are assigned to the categories in the chart
The rule is to press the Spacebar _______ time(s) after periods, colons, and other punctuation marks.
one
supplicant
one who asks humbly and earnestly
clairvoyant
one who can predict the future; psychic
skeptic
one who doubts
misanthrope
one who hates humanity; one who dislikes others
misogynist
one who hates women
zealot
one who is fanatically devoted to a cause
ascetic
one who practices self-denial
libertine
one without moral restraint
Headers print in the top margin _________ inch from the top of every page.
one-half
partisan
one-sided; committed to a party, group or cause
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
context sensitive
options are related to the current task
etymology
origin an history of a word
primordial
original; existing from the beginning
amulet
ornament worn as a charm against evil spirits
frieze
ornamental band on a wall
arabesque
ornate design featuring intertwined curves; a ballet position in which one leg is extended in back while the other supports the weight of the body
denouement
outcome; unraveling of the plot of a play or work of literature
gregarious
outgoing; sociable
guise
outward appearance; false appearance
conciliatory
overcoming distrust or hostility
complaisant
overly polite; willingness to comply with the wishes of others
obsequious
overly submissive
portrait orientation
page orientation in which data prints across the narrower portion of a page
landscape orientation
page orientation in which data prints across the wider portion of the page
Automatic page breaks, like the one in the figure, are determined by ___________.
paper size, line spacing, and margin settings.
The MLA style use in-text _________ instead of noting each source at the bottom of the page or at the end of the paper.
parenthetical reference
travesty
parody, exaggerated imitation, caricature
translucent
partially transparent
At a minimum, your resume should present all of the following EXCEPT ____.
past salaries earned
forbearance
patience
permeable
penetrable
pungent
penetrating, caustic, to the point
discerning
perceptive; exhibiting keen insight and good judgement
tangential
peripheral, irrelevant, digressing
dissident
person who disagrees about beliefs
recluse
person who lives in seclusion and often in solitude
spendthrift
person who spends money recklessly
valedictory
pertaining to a farewell
linguistic
pertaining to language
conjugal
pertaining to marriage agreement
demotic
pertaining to people
bacchanalian
pertaining to riotous or drunken festivity; pertaining to revelry
sartorial
pertaining to tailors
minutia
petty details
pixels
picture element, a point of light measured in dots per square inch
asylum
place of refuge or shelter
juxtapose
place side by side
When three hyphens, underscores, equal signs, asterisks, tildes, or number signs are typed and then the ENTER key is pressed, the AutoFormat feature ____.
places a border above a paragraph
fixed dollar sign
places a dollar sign to the left of the cell leaving spaces between it and the cell numbers
flora
plants of a region or era
banter
playful conversation
piquant
pleasantly pungent; attractive
plasticity
pliability; condition of being able to be shaped or formed
machinations
plots or schemes
fallow
plowed but not sowed; uncultivated
elegy
poem or song expressing lamentation
poseur
poerson who affects an attitude to impress others
bard
poet
perigee
point in an orbit that is closest to the earth
grandiloquent
pompous; bombastic
bombastic
pompous; using inflated language
doggerel
poor verse
impecunious
poor; having no money
problematic
posing a problem; doubtful
indigence
poverty
puissant
powerful
viable
practicable, capable of developing
pragmatic
practical
convention
practice widely observed in a group; custom; accepted technique or device
laud
praise
approbation
praise, approval
antediluvian
prehistoric
preamble
preliminary statement
perennial
present throughout the years; persistent
overweening
presumptuous; arrogant
affected
pretentious; phony
vogue
prevailing fashion or practice
precept
principle; law
To see exactly how a document will look when it is printed, it can be displayed in ____________ as shown in the accompanying figure.
print preview
____________________, as shown in the accompanying figure, displays an entire document on reduced size on the Word screen.
print preview
A(n)________ is information that exists on a physical medium such as paper
printout
debugging
process of finding and correcting errors in the worksheet
secrete
produce and release substance into organism
igneous
produced by fire; volcanic
vendetta
prolonged feud marked by bitter hostility
While ________, you review a document to look for grammatical errors and spelling errors.
proofreading
decorum
proper behavior
commensurate
proportional
rubric
protocol, title or heading
provident
providing for future need, frugal
opprobium
public disgrace; contempt
castigation
punishment; chastisement; criticism
hyperbole
purposeful exaggeration for effect
dismiss
put away from consideration; reject
rebu
puzzle in whic pictures or symbols represent words
discretion
quality of showing self-restraint in speech or actions
contentious
quarrelsome; causing quarrels
fractious
quarrelsome; unruly; rebellious
query
question
desultory
random; disconnected; rambling
A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
range
precipitate
rash; hasty; sudden; done without deliberation
mnemonic
realated to memory; assisting memory
log
record of a voyage; record of daily activities
absolute cell reference
refers to a cell by its fixed position in the worksheet
rarefied
refined
rue
regret
demographic
related to population balance
sylvan
related to the woods or forest
aesthetic
relating to beauty or the arts
seismic
relating to earthquakes
histrionic
relating to exaggerated emotional behavior calculated for effect; theatrical acts or performances
somatic
relating to or affecting the body, corporeal
schematic
relating to or in the form of an outline or diagram
occult
relating to practices connected with supernatural phenomena
sensuous
relating to the senses
sensual
relating to the senses, gratifying the physical (sexual) senses
sidereal
relating to the stars
A ____ reference is an adjusted cell reference in a copied and pasted formula.
relative
The adjusted cell references in a copied and pasted formula are called ____ references.
relative
apropos
relevant
succor
relief, help in time of distress or want
forswear
renounce; repudiate
reprise
repetition, especially of a piece of music
The person or persons requesting the worksheet should supply their requirements in a ____ document.
requirements
recalcitrant
resisting authority or control
________ includes both enlarging and reducing the size of a graphic, as shown in the figure.
resizing
deference
respect; regard for another's wish
A(n) ____________________ usually contains an applicant's educational background and job experience, in addition to some personal information.
resume
Usually contains the applicant's educational background and job experience.
resume
riposte
retaliatory action or retort
recant
retract a statement of opinion
conundrum
riddle; puzzle with no solution
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
circuitous
roundabout
itinerary
route of a traveler's journey
You can drag a(n) ____________________, which is the border at the bottom of a row, until the row is the desired height.
row boundary
florid
ruddy; reddish; flowery
churlish
rude; boorish
presumptuous
rude; improperly bold
boorish
rude; insensitive
petulant
rude; peevish
order of precedence
rules that control the sequence in which Excel performs arithmetic operations
In a business letter, the ____, if present, begins two lines below the last line of the inside address.
salutation
dearth
scarcity
paucity
scarcity
literati
scholarly of learned persons
taxonomy
science of classification
cartography
science of making maps
ornithologist
scientist who studies birds
As more lines of text are typed than Word can display in the document window, Word ________ the top or bottom portion of the document off the screen.
scrolls
avocation
secondary occupation
reviewing the worksheet
see exactly how it will look without generating a printout
fawning
seeking flavor by flattering
specious
seeming to be logical and sound, but not really so
Point mode allows you to ____, as shown in the accompanying figure below.
select cells for use in a formula using the mouse pointer
eclectic
selecting from various sources
A selected graphic, shown in the figure, appears surrounded by a (n) ________, which has small squares and circles around its edges.
selection rectangle
select all box
selects all the cells in a worksheet
continence
self-control; abstention from sexual activity
autonomous
self-governing; independent
complacent
self-satisfied
Which of the following is not a valid format symbol: semi colon (;), percent sign (%), dollar sign ($), comma (,).
semi-colon (;)
nostalgia
sentimental longing for a past time
sobriety
seriousness
homily
sermon; tedious moralizing lecture
tutelary
serving as a guardian or protector
You can sue the rulers to _______.
set tab stops, change page margins, and adjust columns width.
asperity
severity; harshness; irritability
libido
sexual desire
When you __________ text, as shown in the figure, Word colors the rectangular area behind any text or graphics.
shade
effrontery
shameless boldness; presumptuousness
gossamer
sheer; light and delicate; like cobwebs
lustrous
shining
ephemeral
short-lived; fleeting
When fingers are already on the keyboard, it of tens more efficient to use ______, or keyboard key combinations, to format text as it is typed.
shortcut keys
impassive
showing no emotion
pedantic
showing off learning
formulas version
shows the actual formulas you have entered, rather than the resulting values
values version
shows the results of the formulas you have entered, rather than the actual formulas
ostentatious
showy; pretentious
scaling
shrinks the width (or height) of the printed worksheet to fit a maximum number of pages, and is convient for printing formulas
diffidence
shyness; lack of confidence
In a business letter, type the ____ at least four blank lines below the complimentary close, allowing room for the author to sign his or her name.
signature block
tacit
silently understood, implied
congenial
similar in tastes and habits; friendly; suited to
constant value
simply a value, a number or letter that does not change based on other cell content
Footnote text is _____.
single-spaced, left-aligned, and a smaller font size than the text in the research paper
Footnote is a __________.
single-spaced, left-aligned, and a smaller font size than the text in the research paper.
The small squares and circles around a selected graphic, as shown in the figure, are called ______ handles.
sizing
aspersion
slander; false rumor
soporific
sleep producing
Fill Handle
small rectangle on the bottom right corner of a cell used to copy formulas
caucus
smaller group within an organization
fulsome
so excessive as to be disgusting
prohibitive
so high as to prevent the purchase or use of, forbidding
convivial
sociable
plutocracy
society ruled by the wealthy
monolithic
solid and uniform; constituing a single, unified whole
virtuoso
someone with master skills, expert musician
adjunct
something added, attached, or joined
ambrosia
something delicious; the food of the gods
derivative
something derived; unoriginal
anachronism
something out of the proper time
anodyne
something that calms or soothes pain
catalyst
something that causes change
antecedent
something that comes before
complement
something that completes or makes up a whole
deterrent
something that discourages or hinders
amenity
something that increases comfort
stricture
something that restrains, negative criticism
paean
song of joy or triumph; a fervent expression of joy
placate
soothe; pacify
emollient
soothing; mollifying
Items like the phone number in the accompanying figure are copied from a(n) ____ document.
source
Word automatically corrects misspelled words and displays the corrected word when you press the ______ or type a punctuation mark.
spacebar
platonic
spiritual; theoretical
horizontal window split box
splits the worksheet into two horizontal views of the same worksheet
vertical window split box
splits the worksheet into two vertical views of the same worksheet
pervasive
spread throughout every part
platitude
stale; overused expression
desuetude
state of disuse
effervescence
state of high spirits or liveliness; process of bubling as gas escapes
incongruity
state of not fitting
1st step in planning an effective worksheet
state the purpose of the worksheet
credo
statement of belief or principle; creed
dogmatic
stating opinions without proof
equable
steady; unvarying; serene
austere
stern; unadorned; simple
apposite
strikingly appropriate and relevant
obdurate
stubborn
refractory
stubborn, resisting ordinary methods of treatment
froward
stubbornly contrary; obstinately disobedient
intransigence
stubbornness; refusal to compromise
eugenics
study of factors that influence the hereditary qualities of the human race and ways to improve those qualities
paleonthology
study of past geological eras through fossil remains
cosmology
study of the universe as a totality; theory of the origin and structure of the universe
servile
submissive, obedient
qualm
sudden feeling of faintness or nausea
incursion
sudden invasion
autocomplete
suggests text to inset quickly into your document
felicitous
suitable expressed; wee-chose; appropiate
AVERAGE function
sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range
perfunctory
superficial; performed really as a duty
preternatural
supernatural; beyond the normal use of nature
The shortcut keys for the __________ character formatting are CTRL+Shift+Plus sign.
superscript
tumid
swollen, distended
turgid
swollen, pompous
operators
symbols with which you can specify the type of calculation you want to perform in a formula
When the same word is used in multiple locations or word is used that was not quite appropriate, a thesaurus can be used to look up a(n) ____________, or a word similar to meaning.
synonym
When the TAB key is pressed, a(n) ____________________ formatting mark appears in the empty space between tab stops.
tab character
A(n) ____________________ is a location on the horizontal ruler that tells Word where to position the insertion point when the TAB key is pressed.
tab stop
When a custom tab stop is set, the tab marker on the ruler reflects the alignment of the characters at the location of the _____________ .
tab stop
A Word ____________________ is a collection of rows and columns.
table
axiomatic
taken for granted; self-evident truth
loquacious
talkative
A separate window that enables you to carry out some Word tasks more efficiently.
task pane
A(n) ____ is a separate window that enables you to carry out some Word tasks more efficiently.
task pane
vapid
tasteless, dull
A(n) ____________________ is similar to a form with prewritten text; that is, Word prepares the requested document with text and/or formatting common to all documents of this nat
template
Similar to a form with prewritten text.
template
abeyance
temporary suppression or suspension
transient
temporary, fleeting
evocative
tending to call to mind or produce a reaction
volatile
tending to vary frequently, fickle
Header
text and graphics that prints at the top of each page in a document.
data
text or numbers in a cell
Formula bar (mult. choice)
the Excel interface item that displays the address of the current cell
To move from the first cell in the table in the accompanying figure to the next cell, press ____.
the TAB key
supposition
the act of assuming to be true or real
abscission
the act of cutting; the natural separation of a leaf or other part of a plant
extrapolation
the act of estimation by projecting known information
detraction
the act of taking away
Fill color
the background color appearing behind data in a cell
works cited
the bibliographic list of sources at the end of an MLA styled research paper.
normal View
the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane
abstinence
the giving up of certain pleasures
apex
the highest point
Column width
the horizontal measurement of a column
arguments
the information necessary to calculate the answer
cell reference
the intersecting column letter and row number; cell address
Cell
the intersection of a column & row
order of operations
the order in which operations in an expression to be evaluated are carried out. 1. parentheses 2. exponets 3. multiplication and divison 4. addition and subtraction
chart styles
the overall visual look of the chart in terms of its colors, backgrounds and graphic effects such as flat or beveled columns
apogee
the point in an orbit most distant from the body being orbited; the highest point
Alignment
the position of data between the cell margins
allure
the power to entice by charm
condition
the procedure that is varied in order to estimate a variable's effect by comparison with a control condition
spell checker
the process of checking the spelling of words in a document against a dictionary of known words and offering advice on how to make corrections
chivalry
the qualities idealized by knighthood such as bravery and gallantry toward women
range finder
the referenced cells are displayed in color and bordered with the same color; useful for verifying formulas because it visually indicates which workbook cells are included in a formula calculation
suffrage
the right to vote
entomology
the scientific study of insects
fill handle
the small black square in the lower right corner of a selected cell, lets you copy cell contents or continue a series of data into a range of selected cells
pixel
the smallest discrete component of an image or picture on a CRT screen (usually a colored dot)
ambivalence
the state of having conflicting emotional attitudes
archeology
the study of material evidence of past human life
arithmetic operators
the symbols used to perform basic mathematical operations
egoism
the tendency to see things in relation to oneself; self-centeredness
Row height
the vertical measurement of a row
A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
theme
Word includes a variety of document _________ to assist you with coordinating these visual elements in a document.
themes
A (n) _________ is a book of synonyms
thesaurus
viscous
thick, syrupy
callous
thick-skinned; insensitive
coagulate
thicken; congeal
emaciated
thin and wasted
sodden
thoroughly soaked, saturated
minatory
threatening; menacing
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
three
frugality
thrift
hermetic
tighly sealed; magical
sparklines
tiny charts embedded in a cell and give a visual trend summary alongside your data
accrue
to accumulate; grow by additions
venerate
to adore, honor, respect
embellish
to adorn; enhance
aver
to affirm; declare to be true
exacerbate
to aggravate; make worse
converge
to approach; come together; tend to meet
sanction
to approve, ratify, permit
quibble
to argue over insignificant and irrelevant details
contend
to assert
expiate
to atone for
fulminate
to attack loudly; denounce
impute
to attribute the fault to; relate to a particular cause or source
confound
to baffle; perplex; mix up
jibe
to be in agreement
stint
to be sparing
cadge
to beg; sponge
disparage
to belittle
fetter
to bind; confine
vaunt
to boast, drag
appease
to calm, pacify, placate
rescind
to cancel
negate
to cancel out; nullify
coalesce
to cause to become one
precipitate
to cause to happen; throw down from a height
engender
to cause; produce
admonish
to caution or reprimand
exculpate
to clear of blame; vindicate
amalgamate
to combine into a unified whole
grouse
to complain
proscribe
to condemn, forbid, outlaw
cloister
to confine; seclude
relegate
to consign to an inferior position
refute
to contradict, disprove
belie
to contradict; misrepresent; give a false impression
chasten
to correct by punishment or reproof; to restrain or subdue
adulterate
to corrupt or make impure
inundate
to cover with water, overwhelm
quail
to cower, lose heart
impair
to damage; injure
dupe
to deceive; trick
consecrate
to declare sacred
abate
to decrease; reduce
champion
to defend or support
gainsay
to deny; dispute; oppose
abscond
to depart secretly
inveigh
to disapprove; protest vehemently
daunt
to discourage; intimidate; dishearten
discredit
to dishonor; disgrace
perturb
to disturb greatly; make uneasy or anxious
gerrymander
to divide an area into voting districts in a way that favors a political party
bifurcate
to divide into two parts
limn
to draw, describe
bedizen
to dress in a vulgar, showy manner
flag
to droop; grow weak
desiccate
to dry completely
stupefy
to dull the senses of, stun, atonish
savor
to enjoy, have a distinctive flavor or smell
regale
to entertain
plumb
to examine deeply; determine the depth
distend
to expand; swell out
exorcise
to expel evil spirits; free from bad influences
explicate
to explain;interpret;clarify
demur
to express doubt; question or oppose
default
to fail to act
plummet
to fall; plunge
malinger
to feign illness to escape duty
reproach
to find fault with, blame
carping
to find fault; complain
interdict
to forbid; prohibit
exact
to force the payment of; demand and obtain by authority
presage
to foretell; indicate in advance
gambol
to frolic; leap playfully
bolster
to give a boost to; prop up; support
abdicate
to give up a position, right, or power
renege
to go back on one's word
burgeon
to grow and flourish
finesse
to handle with a deceptive or evasive strategy; refined in performance
impede
to hinder; block
mesmerize
to hypnotize
emulate
to imitate; copy
stultify
to impair or reduce to uselessness
vitiate
to impair the quality of, corrupt morally
ameliorate
to improve
foment
to incite; arouse
subsume
to include, incorporate
proliferate
to increase rapidly
enhance
to increase; improve
apprise
to inform
interpolate
to insert; change by adding new words or material
concoct
to invent
allay
to lessen; ease; soothe
essay
to make an attempt; subject to a test
divulge
to make known something that is secret
aggrandize
to make larger or greater
facilitate
to make less difficult
assuage
to make less severe
discomfit
to make uneasy; disconcert
obviate
to make unnecessary; to anticipate and prevent
defame
to malign; harm someone's reputation
broach
to mention for the first time
cozen
to mislead by trick or fraud; decieve
deride
to mock
oscillate
to move back and forth
remonstrate
to object or protest
condone
to overlook voluntarily; forgive
burnish
to polish
dissemble
to pretend; disguise one's motives
forestall
to prevent; delay
goad
to prod; urge on
purport
to profess, suppose, claim
tout
to promote or praise energetically
enunciate
to pronounce clearly
document
to provide with written evidence to support
elicit
to provoke; draw out
prevaricate
to quibble; evade the truth
buttress
to reinforce; support
repudiate
to reject as having no authority
abjure
to reject; abandon formally
supersede
to relace, especially to displace as inferior or antiquated
alleviate
to relieve; improve partially
supplant
to replace, substitute
delineate
to represent or depict
extirpate
to root up; to destroy
beatify
to sanctify; to bless; to ascribe a virtue to
satiate
to satisfy
rail
to scold with bitter or abusive language
expatriate
to send into exile
subside
to settle down, grow quiet
evince
to show plainly; be an indication of
occlude
to shut; block
founder
to sink; fail; colapse
denigrate
to slur someone's reputation
mollify
to soothe
malign
to speak evil of
expatiate
to speak or write at length
stipulate
to specify as an essential condition
diffuse
to spread out
disseminate
to spread; scatter; disperse
stanch
to stop or check the flow of
arrest
to stop; to seize
impinge
to strike; encroach
divest
to strip; deprive; rid
insinuate
to suggest; say indirectly; imply
preempt
to supersede; appropiate for oneself
substantiate
to support with proof or evidence
strut
to swagger, display to impress others
codify
to systematize
appropriate
to take possession of for one's own use; confiscate
prate
to talk idly; chatter
gouge
to tear out; scoop out; overcharge
lambaste
to trash verbally or physically
flout
to treat scornfully
exhort
to urge by strong appeals
diverge
to vary; go in different directions from the same point
vacillate
to waver, oscillate
attenuate
to weaken
enervate
to weaken
inveigle
to win over by flattering or coaxing
propitiate
to win over, appease
militate
to work against
liberal
tolerant; broad-minded
officious
too helful; meddlesome
contiguous
touching; neighboring; connecting without a break
When the Mini toolbar appears, it initially is_______________ .
transparent
You can make one color in a graphic ____, that is, removing its color.
transparent
pellucid
transparent; easily understood
diaphanous
transparent; vague; insubstancial
tremulous
trembling, frugal, timid
ruse
trick, crafty stratagem
chicanery
trickery; fraud
nugatory
trifling; invalid
veracious
truthful, accurate
convoluted
twisted; complicated
In general, use no more than ____ font types in a worksheet.
two
When working with a large worksheet, you can split the window into ____ panes.
two or four
range
two or more cells on a worksheet that are adjacent or nonadjacent`
inert
unable to move; sluggish
precarious
uncertain
indeterminate
uncertain; indefinite
ambiguous
unclear or doubtful in meaning
adamant
uncompromising; unyielding
insensible
unconscious; unresponsive
___________ text prints with an underscore below each character.
underlined
The first step in creating an effective worksheet is to make sure you ____.
understand what is required
compunction
uneasiness caused by guilt
phlegmatic
unemotional; calm in temperament
fusion
union; synthesis
singular
unique, extraordinary, odd
implausible
unlikely; unbelievable
tautology
unnecessary repetition
cacaphonous
unpleasant or harsh-sounding
disinterested
unpredujiced; objective
extemporaneous
unrehearsed
irresolute
unsure of how to act; weak
pristine
untouched; uncorrupted
With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ____.
use Excel to create the worksheet
euphemism
use of agreeable or inoffensive language in place of offensive language
filibuster
use of obstructive tactics in a legislature to block passage of a law
parenthetical references
used in MLA style instead of noting each source at the bottom of the page
click and type
used to format and enter text, graphics, and other items
Shortcut keys
used to format texts as you type it.
column chart
useful for illustrating comparisons among related numbers
Range Finder
useful for verifying formulas or quickly positioning the insertion point within the cell to perform editing dierctly in the cell
laconic
using few words
vituperative
using or containing harsh, abusive censure
wistful
vaguely longing, sadly thoughtful
variegated
varied, marked with different colors
sundry
various
vindictive
vengeful, unforgiving
invective
verbal abuse
abysmal
very bad
meticulous
very careful; picky; fastidious
minuscule
very small
contrite
very sorrowful for a wrong; seeking forgiveness
garrulous
very talkative; wordy
miscreant
villain; criminal
Graph -
visual representation of data within a spreadsheet
timbre
voice tone color
welter
wallow or roll, toss about, be in turmoil
peregrination
wandering from place to place
itinerant
wandering from place to place; unsettled
fervor
warmth and intensity of emotion
dross
waste; worthless matter
prodigal
wasteful; extravagant; lavish
chart types
ways you can display data in a way that is meaningful to the reader; e.g. column charts, pie charts, and line charts
tenuous
weak, insubstantial
sinecure
well-paying job that requieres little or no work
vortex
whirpool, center of turbulence
maelstrom
whirpool; turmoil
sage
wise
raconteur
witty, skillful storyteller
coquette
woman who flirts
verbose
wordy
travail
work, especially arduous work
The MLA style uses the term _________ for the bibliographic list of sources.
works cited
According to the MLA style, the ____________ is a list of sources that are referenced directly in a research paper.
works cited page
An Excel ____ allows data easily to be summarized and charted.
worksheet
mundane
worldy as opposed to spiritual; concerned with the ordinary
compliant
yielding
page layout view
you can see the edges of the paper of multiple pages, the margins, and the rulers
chart layout gallery
you can select a predesigned chart layout
