Word Test
Workbooks created in earlier versions of Excel use the file name extension ____ and Excel 2010 workbooks use the extension _____
.xls; .xlsx
The chart's data series, such as a set of columns, represents
A group of related values in the worksheet
What happens when you click the launcher on a ribbon group?
A related dialog box, window, or task pane is displayed
To add a paragraph to a document, surround it with a border, and move the paragraph easily around the document, you can insert:
A text box
How does Excel identify the range of cells from cell A1 to cell C8
A1:C8
If you want to copy a formula that always references the same value in the worksheet, use a(n) _______ in the formula
Absolute reference
To use your keyboard instead of the mouse to select tools on the ribbon, you display the KeyTips by pressing the ____ key
Alt
In Excel, formulas and functions begin with
An equal sign
The table styles gallery on the design tab lets you:
Apply formatting to the entire table
The ______ feature enables you to type several characters that Word replaces with a full word or phrase
AutoCorrect
After opening the ______, you can apply a built- in set of formats to a cell with just one mouse click
Cell Styles menu
How can you display the table tools design tab and layout tab on the ribbon, so that you can make formatting and layout changes to the table?
Click anywhere in the table
To select and display a different worksheet in a workbook, you:
Click its sheet tab
How do you close the current document without closing the Word window
Click the Close command on the Office menu
To restore the state of your worksheet prior to the 3 most recent actions, you can
Click the Undo arrow and select the third action
To add a button to the Quick Access tool bar, you:
Click the arrow next to the toolbar and select a command
To commit data to a cell and keep the cell active, you
Click the enter button
To view additional tabs for working with a graphic object, you must first:
Click the graphic
You can access all formats at once by clicking
Clicking the font, alignment, or number launcher
A dashed border around a cell indicates that is had been cut or copied to the ____and can be ____in another cell
Clipboard; pasted
To incorporate changes from several versions of one document, use the ______ command from the ______ button
Combine: Compare
A small red triangle in the upper right corner of a cell means that the cell contains a (n):
Comment
You can insert a note to the other authors in a document by using the ______ button on the ____ tab
Comment; Reviewing
After selecting text, use the ____ and____ commands to move the text to a different location
Cut; Paste
To calculate the number of days between two dates, use the _____ function
DAYS360
When creating a chart, enter the values represented by the chart in the
Datasheet
To reduce the amount of white space on the right side of a document, you can _____ the _____
Decrease; Right margin
When cell D1 is selected, clicking the delete button in the Home tab:
Deletes cell D1: surround cells are shifted to fill the gap
How can you enter text in the middle of a blank line in your document?
Double- click the location
To automatically size a column fit the longest cell entry
Double- click the right border of the column heading
How can you rename the label on a sheet tab?
Double- click the sheet tab and type the new name
To resize a column or row, you can ______ its border
Drag
To create a hyperlink to another document, you need to select the item to represent the link and then:
Enter the destination using the Insert Hyperlink dialog box
After setting Excel to use Manual calculation, you can calculate the worksheet yourself using the _____ or the _____
F9 Key; Calculate Indicator
A financial function that calculates the total value at the end of a series of payments is the _______ function
FV
Page Break Preview enables you to view the page breaks in a worksheet, but you cannot change the breaks (T/F)
False
The document inspector reviews five areas from extraneous information. you must remove all information that is found before sending (T/F)
False
To apply a different format to a cell, select one of the formats on the Home tab and then click the cell(s) to format (T/F)
False
You can format a document to contain a maximum of 3 newsletter columns (T/F)
False
To open an existing document, access the Open command by clicking the _____, which displays the ______
File tab; File Menu
If you want to display only specific rows of data, such as the highest priced products, use the ______ tool
Filter
A quick way to change all instances of the word beautiful with the word picturesque is to use the __________ feature
Find and Replace
The size of text is a ____ format, and the alignment of text is a ____format
Font; Paragraph
To repeat your company's contact information at the bottom of every document page, start my clicking the ____ button on the Insert tab
Footer
The ______ button on the Home tab displays a menu of options to resize, hide and organize components of your worksheet
Format
The _______ enables you to copy the formats from one cell to another
Format Painter
A quick way to copy the formats from one text selection to another is by using the
Format Painter button in the Clipboard group
You can enter or edit data directly in the active cell or use the:
Formula Bar
To display a document so that it looks like pages in a book, switch to _____ view
Full screen reading
To allow readers of your workbook to click and access a Web page or other file, insert a _____ in a worksheet
Hyperlink
To apply a multilevel Outline Numbered style to a document, the paragraphs must be:
Indented
If you are not sure which function you need to perform a calculation, use the
Insert Function button
Clicking the AutoSum button in the Function Library group:
Inserts the SUM function and automatically enters arguments
The ____ tab on the ribbon contains tools for printing envelops and labels
Mailing
Use tools in the _____ group to apply dollar signs, percent signs, and decimal places to cell contents
Number
When you type new text, _____ mode replaces existing text.
Overtype
When you switch to ______ view, you can add headers and footers by clicking the placeholders
Page Layout
To copy just the value of a formula, so that it does not change if its cell references change, use the _____ command
Paste Special
To control how a document is printed, open the Print dialog box using the _____ command on the File menu's Print submenu
The _____ command, accessible from the Find & Select tool, is used to locate data and then substitute it with different data
Replace
To access a dictionary, thesaurus, and translation options all at once, open the _______ task pane
Research
A _____ enables you to apply different formats to different areas of the document
Section
Clicking the Picture button in the Illustrations group enables you to
Select and insert an existing picture file
Rows 10 and 11 in the worksheet are hidden from view. How do you display these rows?
Select rows 9 and 12 and select unhide from the shortcut menu
One way to create a chart is to _____ and then click a Chart type button on the inter tab
Select the worksheet data
To automatically print just a selected area of the worksheet when you use any Print command, you:
Set print area
To add one of Word's preformatted lines, arrows, or drawings, select one from the _____ menu
Shapes
To e-mail copy of a workbook from within Excel, use the ____ option on the File menu
Share
To create a customized diagram that represents a process or cycle, insert a ____ graphic
SmartArt
If more than one person edits a document using the Track Changes feature, each person's changes are identified by:
Specific color, and the initials of the reviewer
The most common uses of Excel are to create ______, lists, tables and charts
Spreadsheets
You can clear formats or styles from text using the
Style Inspector
To apply a set of font and/or paragraph formats to text, use the ____ gallery or task pane
Styles
After entering information into a table cell, press the ______ key to move the insertion point to the next cell
Tab
The ribbon consists of a series of ______, which contain groups of tools related to a specific task
Tabs
A ______ is a document that provides a preformatted layout for text and graphics, as well as some content
Template
To add a keyword and subject to a document so that it is easy to search for, use:
The Properties feature
When saving a word document as a web page, you can specify the name that will appear on:
The browser's title bar
What value will the formula =Payments!$C$10 display?
The value in cell C10 of the Payments worksheet
What does a green, wavy line under a word or phrase in the document mean?
The word or phrase might contain a grammatical error
To edit a document so that others can view, accept, or reject your changes, turn on the _____feature
Track Changes
After inserting a shape using the Shape button, you can enter text into the shape (T/F)
True
Clicking the new command on the office menu enables you to create a new, blank workbook or select a workbook template (T/F)
True
The Clip Art gallery consists if pictures that come with Word, as well as pictures available from Microsoft Office Online (T/F)
True
The first time you save a new document, you must name the file or use the default name (T/F)
True
The handle on the lower right corner of a cell's selector is used to copy the value in the cell, or create a series of values (T/F)
True
To get help using Word, click the help icon on the ribbon or press the F1 key (T/F)
True
When creating a table using the table button, you can select the number of columns and rows include in the table (T/F)
True
When viewing a document using Print Preview, you can zoom in to the document, edit the document, and make layout changes (T/F)
True
When workbooks are arranged side by side in the Excel window, each has its own title bar containing the Minimize, Maximize and Close buttons (T/F)
True
You can add a tab top by just clicking a location on the Word ruler (T/F)
True
You can use Undo to reverse more than one change (T/F)
True
Freezing a worksheet row is helpful because it keeps headings ______ while scrolling
Visible
Saving a document as a(n) ______ file enables others to view the file in Windows 7's Internet Explorer using the ______ viewer
XPS, XPS
After you enter a formula, the result of the formula is displayed in the _____ and the formula itself is displayed in the _____
cell; formula bar
