Computer Final Exam Review
In the formula =(G15-G14)*$M$3/4, which mathematical operation is preformed first?
(G15-G14)
How do you center the text vertically in each table cell?
. Click the Select button in the Table group, click Select Table, then click the Align Center Left button in the Alignment group.
When text is ____ both the left and right edges of the paragraph are flush with the left and right margins.
. justified
The default file extension for an Excel 2013 workbook is_____
.xlsx
The Excel operator for division is ______
/
You select the type of document you want to create in step ____ of the mail merge process
1
The Office Clipboard can hold up to how many items?
24
Which of the following is a complex formula?
=(B4/B8)*10
How can the order if the precedence in this formula , =C12+C13*F4, can be changed so that C12+C13 is added together as the first operation to occur?
=(C12+C13)*F4
What formula would you use to calculate the total of the values in cells A1 through A4?
=SUM(A1:A4)
Which of the following is not a Quick Parts item?
A Quick Style set
With PowerPoint, you can import text, photographs, numerical data, and facts from files created in such programs as ____.
All of the above
Excel recognizes an entry as a value if it is a number or it begins with ________
All of the above.
Which of the following items can you import into a presentation?
All of the above.
Which command do you use to display two open documents at the same time?
Arrange All
. Double-clicking the column line to the right of a column activates the ____ feature for the column.
AutoFit
When you are typing in a text placeholder, which feature decreases the font size in order to fit the text in the placeholder?
AutoFit Options button
A text building block can be saved to the ____ gallery
AutoText
All of the following are placeholders you can add EXCEPT ____.
Background
In ____ view, you have the option of saving your presentation to your computer or SkyDrive
Backstage
____ are the reusable pieces of formatted content or document parts that are stored in galleries, including headers and footers, cover pages, and text
Building blocks
You can quickly center a table on a page by clicking the ____ button in the Paragraph group on the HOME tab
Center
Which command in the Adjust group allows you to change one picture for another but retain the original picture's size and formatting?
Change Picture
You can click ____ in the gallery of table styles to remove all borders, shading, and other style elements from the selected table.
Clear
Which sequence of steps do you perform to add a shadow or outline to text?
Click the Text Effects button, and then select the desired text effect.
How do you delete an individual item from the Office Clipboard?
Click the list arrow next to the item, and then click Delete.
The Format Painter button is found in the ____ group on the HOME tab of the Ribbon.
Clipboard
____ formatting is automatically updated if you change data in the worksheet.
Conditional
You use the ____ dialog box to enter a unique name and description for a building block, and to specify the gallery where you want it to appear
Create New Building Block
The Colors list arrow is on the ____ tab.
DESIGN
Themes are found on the ____ tab.
DESIGN
Which of the following contains the unique information for each individual or item
Data source
The ____ commands found on the Align list evenly space objects horizontally or vertically relative to each other or the slide.
Distribute
If you want to quickly make all the columns in a table the same width, which command do you use?
Distribute Columns
f you created a main document based on an existing document entitled "Confirmation Letter," what default filename would Word give the main document?
Document
What tool helps you detect and remove private or confidential information from a document?
Document Inspector
You can use the ____ to delete ink annotations.
Document Inspector
One way to assign or update a document property is by typing in the ____ Panel.
Document Properties
If a document window has been split into two panes, how can you restore the window to a single pane?
Double-click the split bar
____ the Format Painter button allows it to remain active until you turn it off.
Double-clicking
Which of the following is a Drop Cap option?
Dropped
Right-click a slide in the Thumbnails pane and then click ____ to create an exact copy of a slide.
Duplicate Slide
When working with a table, press ____ to move to the next line within the same cell.
Enter
Which key do you press to create a new bullet?
Enter
The file extension .xltx indicates what type of Excel file
Excel template
To which of the following does the Research task pane NOT provide access
Find and Replace
To change the formatting of text from Calibri to Arial, which tool should you use?
Font Style list arrow
You can apply styles and alignment using the ____ dialog box
Format Cells
You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.
Format Cells
Which button allows you to copy the formatting from one graphic to another?
Format Painter
Which feature allows you to copy multiple format settings at once?
Format Painter
You can apply the formatting of one graphic to another using the ____.
Format Painter
The Find & Select button is found in the Editing group on the ____ tab on the Ribbon
HOME
The Font Color button is on the ____ tab.
HOME
The New Slide button is in the Slides group on the ____ tab.
HOME
To replace specific text in a presentation, click the ____ tab on the Ribbon, then click the Replace button in the Editing group.
HOME
You can apply font styles and alignment options using the ____ tab of the ribbon
HOME
Which tab and group will allow the intersection of rows and columns in a worksheet
HOME tab, Cells group
To add a hyperlink to a slide, use the Hyperlink button in the Links group on the ____ tab.
INSERT
The Shapes command is in the ____ group
Illustrations
You change a floating graphic to an inline graphic by changing the text wrapping style to ____.
In Line with Text
When you move the pointer to the left of two existing rows, a(n) ____ appears outside the table.
Insert Control
In the ____ window you can search for online pictures in Office.com, through Bing search engine or on your skydrive
Insert Pictures
2. Use the ____ Table menu command to create a table with any number of columns and rows and then select an AutoFit behavior.
Insert Table
What kind of items can be stored on the Office Clipboard?
Items collected from any Office program.
The Position tab, in the ____ dialog box, allows you to specify an exact position for a graphic relative to some aspect of the document, such as a margin, column, or paragraph.
Layout
Which of the following opens when you click the launcher in the Size group on the Ribbon?
Layout dialog box
As you move the pointer over font names in the font list, the text on the slide displays a ____ of the different font choices.
Live Preview
Which of the following is NOT an option in the Paste Options menu?
Match Formatting
Which of the following would you NOT find in the data source?
Merge fields
When the Microsoft Translator analyzes text, the ____ may also appear.
Mini toolbar
"Drag and drop" describes what operation?
Moving text using the mouse
The Header and Footer dialog box has which of the following tabs?
Notes and Handouts
Other than the Slide pane, where can you enter slide text?
Outline view
To view available cover pages, click the Cover Page list arrow in the ____ group on the INSERT tab.
Pages
Which dialog box do you use to embed fonts?
PowerPoint Options
How do you resize a graphic object horizontally while keeping the center position fixed?
Press [Ctrl] and drag a side sizing handle.
All of the following are theme color options EXCEPT ____.
Primary colors
Which element of the Word program window contains buttons for saving a document and for undoing, redoing, and repeating a change?
Quick Access toolbar
A date placeholder is an example of a ____.
Quick Part
You save an item as a building block using the ____ command
Quick Parts
What are sets of styles that use common fonts, colors, and formats called?
Quick Styles
Which Table menu command should you use to insert a preformatted table template?
Quick Tables
To begin checking the spelling in your presentation, click the ____ tab on the Ribbon and then click the Spelling button in the Proofing group.
REVIEW
Which Word view displays document text so it is easy to read on screen?
Read Mode
To remove a cover page from a document, click the Cover Page list arrow in the Pages group and then click
Remove Current Cover Page
The ____ button resets slide placeholders to their default position, size, and text formatting.
Reset
To restore a document to the default theme for the template on which the document is based, click the Themes button, and then click ____.
Reset to Theme from Template
. Which command is used to create a duplicate copy of a file, while leaving the original file intact?
Save As
The first time you save a document, which screen appears?
Save As screen
The _____ option helps fit the data on a single page without making changes to individual margins
Scale to Fit
How do you insert multiple rows at the same time?
Select the number of rows you want to insert, then use an Insert Control or use the buttons on the Ribbon
_________ fonts have a small stroke at the ends of the characters
Serif
You can format a text box by clicking the More button in the ____ group
Shape Styles
In addition to the Text Box button, what other button can you use to create a text box?
Shapes
_____ below the worksheet grid let you switch from sheet to sheet in a workbook
Sheet tabs
To select an unselected text object, press [____], click the text object, and then release [____].
Shift
Which button do you click to show formatting marks in a document?
Show/Hide ¶ button
____ view displays your presentation on the whole computer screen.
Slide Show
A ____ graphic is a professional-quality diagram that visually illustrates text.
SmartArt
Which tab in the Properties dialog box shows information about revisions to the document as well as the number of pages, word, lines, paragraphs, and characters in the file?
Statistics
You can radically change how a SmartArt graphic looks by applying a SmartArt ____.
Style
To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the HOME tab, and then click a style in the gallery.
Styles
To turn gridlines off or on, you should click the View Gridlines button in the ____ group on the TABLE TOOLS LAYOUT tab.
Table
The Shading list arrow is in the ____ group
Table Styles
A SmartArt graphic consists of two parts: the SmartArt graphic itself and a(n) ____ pane.
Text
Which of the following does NOT happen when you copy an item to the Office Clipboard?
The Clipboard task pane automatically opens.
Which feature can you use to highlight all instances of a word in a document?
The Find command in the Navigation pane
What happens when you click Print in the FILE tab?
The Print screen opens in Backstage view.
What happens when you click the Zoom level button?
The Zoom dialog box opens
Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items tat are copied or cut
The clipboard automatically deletes the oldest item on the clipboard.
When cells are copied using Excel's copy function, what happens to the data in the copied cells
The data remains in its original location.
What happens when you click an item on the Office Clipboard?
The item is pasted in the document at the location of the insertion point.
Which of the following does NOT happen when you add a 25th item to the Office Clipboard?
The last item you collected is deleted.
. Which feature can you use to find and insert a synonym for an overused word?
Thesaurus
Which gallery shows available shapes for WordArt text?
Transform
____ a word selects the entire paragraph, including the paragraph mark
Triple-clicking
Which of the following is NOT a way to add the selected text to the Clipboard?
Use the mouse to drag the text to the Clipboard
The information in the Author property control is based on the user name entered in the ____ dialog box.
Word Options
You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet
Zoom
Pressing [Ctrl] + ____ changes the current pointer during a slide show back to the arrow key.
[A]
Press ____ as you drag a border to display the column width or row height measurements on the ruler.
[Alt]
You can press ____ to decrease the indent level.
[Alt][-]
To move one screen to the left press ______
[Alt][Page Up]
What keyboard shortcut selects an entire document?
[Alt][S]
Which key is used to remove the character before the insertion point?
[Backspace]
To quickly jump to the first cell in an worksheet press _____
[Ctrl][Home]
What is the keyboard shortcut for pasting text?
[Ctrl][V]
What is the keyboard shortcut for cutting text?
[Ctrl][X]
The ____ keyboard command erases an annotation drawing.
[E]
Which key is pressed to go to the last slide in a slide show?
[End]
Which key is used to move the insertion point to the start of the next line?
[Enter]
Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell reference for a formula
[F4]
During a slide show, which key is pressed to pause the slide show?
[S]
To copy noncontiguous slides, open Slide Sorter view, click the first slide thumbnail, press and hold ____, click each additional slide thumbnail, release the key, and then click the Copy button.
[Shift]
To quickly jump to the last cell in a worksheet press _____
[Shift][Down]
The Excel operator for exponent is _____
^
What appears on the screen when you place the mouse pointer under text that was corrected by AutoCorrect?
a blue box
Which type of cell reference preserves the exact cell address in a formula
absolute
You can change the ____ of labels and values in cells to be left, right, or center
alignment
By default, as you type Word will automatically create a hyperlink to ____.
an e-mail address
All functions begin with the formula prefix_____
arguments
Which of the following can you press to move an object in small increments?
arrow keys
You can save a piece of content, such as a company's mission statement, as a
building block
Using ____ computing, you can take advantage of Microsoft Office Web apps to do your work in a virtual environment.
cloud
Use ____ colors for slide background and text to make the text readable.
contrasting
A shape color's red, green, and blue (RGB) values are also known as its ____.
coordinates
You can use a spreadsheet to _____ by using variable values to investigate & sample different outcomes
create what-if data scenarios
Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT _____ in the template
data
A collection of related data points is called a ____.
data series
WordArt is a drawing object that contains ____ text.
decorative
User-defined details about a document that describe its contents and origin are known as ____.
document properties
In the PowerPoint rulers, the current location of the cursor is identified by a small ____ in the ruler.
dotted red line
You can change, or _____, the contents of an active cell at any time
edit
All Excel formulas begin with the _____
equal sign (=)
Which of the following is an exception to copyright protection?
fair use
When you save a document, what is the name you give it called?
filename
The ____ size is the physical size of the text
font
The ______ of a cell determines how the labels and values look
format
A(n) _____ is a built-in formula that uses arguments to calculate information
function
In Excel, MAX and AVERAGE are examples of _____
functions
The WordArt text styles and effects include ____.
glows
The x-axis and y-axis are, respectively, the ____.
horizontal and vertical axes
You can insert a chart using the Insert Chart button in the ____ group, on the INSERT tab.
illustrations
Where is the Show/Hide ¶ button?
in the Paragraph group on the HOME tab
When you embed fonts, the size of your presentation ____.
increases
The ____ indicates where text appears as you type
insertion point
By default, how is text aligned?
left-aligned
Which method of entering a function requires the user to know the name and initial characters of a function
manually typing the function
Animation tags identify the ____ in which objects are animated during slide show.
order
Which of following is NOT a Paste list arrow option
pasting cell selectors
A(n) ____ is an example of a data series marker.
pie wedge
An Excel user should use a relative cell reference when it is important to ______
preserve the relationship to the formula location
A(n) ____ control is a content control that contains document property information, such as title, company, or author.
property
Each style set includes styles for titles, subtitles, headings, and ___
quotes
A small, ____ triangle appears in the upper-right corner of a cell containing a comment.
red
A(n) _____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary
relative
Which pointer selects a line or lines of text and appears when you point to the left edge of a line of text?
right-pointing arrow pointer
When a graphic is selected, a white ____ appears at the top of the graphic
rotate handle
What should you change in order to make characters narrower and give text a tall, thin appearance?
scale
Which element of the Word program window is used to display different parts of the document in the document window?
scroll bars
You can use _____ to move around in a document that is too large to fit on the screen at once
scroll bars
After selecting the document type for a mail merge, the next step is to ____
select the starting document
Instead of changing individual attributes, you can apply a Quick Style to a ____.
shape
It is a good idea to limit each slide to six words per line and ____ lines per slide.
six
Which Word feature causes red and green wavy lines to appear under words as you type?
spelling and grammar checking
Which element of the Word program window displays information about the current document, such as number of pages, and also includes the view and Zoom buttons?
status bar
A presentation with a clear message that reads like a ____ and is illustrated with appropriate visual aids will have the greatest impact on your audience.
story
You can use predesigned, formatted files called _____ to create new worksheets quickly
templates
. What are shadows and outlines examples of? a. text effects c. f
text effects
Which of the following removes only the contents of a selected row or column?
the [Delete] key
5. Which button is not on the Mini toolbar?
the button to spell text
A ____ is a set of unified design elements.
theme
The accompanying figure shows examples of ____.
themes
A default Accounting number format adds dollar signs and _____ decimal places to the data
two
Functions can be entered for formulas using all of the following methods except______
typing the function argument
The Check Compatibility feature searches for ____.
unsupported features
In Presenter view, the next slide in the presentation appears in the ____ corner of the screen.
upper-right
Where in the Word program window can you find the top and bottom margins?
vertical ruler
Every chart has a corresponding ____ that contains the numerical data displayed by the chart.
worksheet