Semester 1 - Final Review Computer Apps 1
Workbooks created in earlier versions of Excel use the file name extension ____ and Excel 2010 workbooks use the extension ____.
.xls, .xlsx
What happens when you click the launcher on a ribbon group?
A related dialog box, window, or task pane is displayed.
If more than one person edits a document using the Track Changes feature, each person's changes are identified by:
A specific color, and the initials of the reviewer.
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
To use your keyboard instead of the mouse to select tools on the ribbon, you display the KeyTips by pressing the ( ) key.
Alt
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
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 add a button to the Quick Access toolbar, you:
Click the arrow next to the toolbar and select a command.
How do you close the current document without close the Word window?
Click the close command on the office menu.
To view additional tabs for working with graphic object, you must first:( ).
Click the graphic
After selecting text, use the ( ) and ( ) commands to move the text to a different location.
Cut, Paste
When creating a chart, enter the values represented by the chart in the:( ).
Datasheet
To calculate the number of days between two dates, use the _____ function.
Days360
To reduce the amount of white space on the right side of a document, you can ( ) the ( ).
Decrease, Right Margin
How can you enter text in the middle of a blank line in your document?
Double-click the location.
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
To open an existing document, access the Open command by clicking the ( ), which displays the ( ).
FIle tab, FIle Menu
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.
False
The Document Inspector reviews five areas for extraneous information. You must remove all information that is found before sending.
False
You can format a document to contain a maximum of 3 newsletter columns.( ).
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.
Fasle
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 a text is a ( ) format.
Font,Paragraph
To repeat your company's contact information at the bottom of every document page, start by clicking the ( ) button on the insert tab.
Footer
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 apply a multi level Outline numbered style to a document, the paragraphs must be:( ).
Indented
When you type a new text, ( ) mode replaces existing text.
Overtype
To control how a document is printed, open the Print dialog box using the ( ) command on the File menu's Print submenu.
To access a dictionary, thesaurus, and translation options all at once, open the ( ) task pane.
Research
You can insert a note to other authors in a document by using the (comment ) button on the ( ) tab.
Reviewing
A ( ) enables you to apply different formats to different areas of the document.
Section
Rows 10 and 11 of the worksheet are hidden from view. How do you display these rows?
Select rows 9 and 12 and select unhide from the shortcut menu.
To add one of Word's preformatted lines, arrows, or drawings, select one from the ( ) menu.
Shapes
You can clear the 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 plane.
Styles
After entering information into a table cell, press the ( ) key to move the insertion point to the.
Tab
The ribbon consists 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 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.
True
Clicking the New command on the Office menu enables you to create a new, blank workbook or select a workbook template.
True
The Clipart gallery consists of pictures that come with Word, as well as pictures available from Microsoft Office Online.( ).
True
The first time you save a new document, you must name the file, or use the default name.( ).
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.
True
To get help using Excel click the Help icon on the ribbon or press the F1 key.
True
To get help using Word, click the Help icon on the ribbon or press the F1 key( )
True
When creating a table using the Table button, you can select the number of columns and rows to include in the table.( ).
True
When viewing a document using Print Preview, you can zoom in to the document, edit the document, and make layout changes.
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.
True
You can Undo to reverse more than one change( ).
True
You can add a tab stop by just clicking a location on the Word ruler.( ).
True
Saving a document as a(n) ( ) file enables others to view the file in Windows 7's Internet Explorer using the ( ) Viewer.
XPS,XPS
The chart's data series, such as a set of columns, represents:
a group of related values in the worksheet.
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 Key Tips by pressing the ______ key.
alt
In Excel, formulas and functions begin with:
an equal sign.
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
To select and display a different worksheet in a workbook, you:
click its sheet tab.
To add a button to the Quick Access toolbar, 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 restore the state of your worksheet prior to the 3 most recent actions, you can:
click the undo arrow and select the third action.
You can access all formats at once by:
clicking the font, alignment, or number launcher.
A dashed border around a cell indicates that it has 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
When cell D1 is selected, clicking the delete button in the Home tab:
deletes cell D1;surrounding cells are shifted to fill the gap.
To automatically size a column to fit the longest cell entry:
double-click the right border of the column heading.
If you want to display only specific rows of data, such as the highest priced products, use the _____ tool.
filter
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
To allow readers of your workbook to click and access a Web page or other file, insert a _____ in a worksheet.
huperlink
After opening the _____, you can apply a built
in set of formats to a cell with just one mouse click. - cell styled menu
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:
insert the sum function and automatically enters arguments.
The () tab on the ribbon contains tools for printing envelopes and labels.
mailing
Use tools in the _____ group to apply dollar signs, percent signs, and decimal places to cell contents.
number
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.
pasted special
The ____ command, accessible from the Find & Select tool, is used to locate data and then substitute it with different data.
replace
Clicking the Picture button in the Illustrations group enables you to:
select and insert an existing picture file.
One way to create a chart is to _____ and then click a Chart type button on the Insert tab.
select the worksheet data
To automatically print just a selected area of the worksheet when you use any Print command, you:
set a print area.
To email a 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
The most common uses of Excel are to create ________, lists, tables, and charts.
spreadsheets
The ribbon consists of a series of ________, which contain groups of tools related to a specific task.
tabs
What value will the formula =Payments!$C$10 display?
the value in cell C10 of the payments worksheet.
Freezing a worksheet row is helpful because it keeps headings ____ while scrolling.
visible
