COSC 1301 Final Exam
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
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
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
Press the ____ key(s) to erase one character to the left of the insertion point.
BACKSPACE
____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
Character
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
Press the ____ key(s) to erase one character to the right of the insertion point.
DELETE
If you click the Increase Font Size button too many times and make the font size too big, you can click the ____ button until the desired font size is displayed.
Decrease Font Size
To open the Format Cells dialog box with the Alignment sheet active, click the Alignment Settings _____.
Dialog Box Launcher
What effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
Fill Formatting Only
The ____ feature automatically locates specific text and then replaces it with desired text.
Find and Replace
____ changes picture color into black, white, and shades of gray.
Grayscale
___ are the alternate designs that exist for each theme.
Variants
PowerPoint assumes every new slide, except for a blank slide, has ____.
a title
The ____ function is useful when you want to assign a value to a cell based on a logical test.
IF
____ is the process of copying an item from the Office Clipboard into the document at the location of the insertion point.
Pasting
____ adds designs that repeat in rows across a slide.
Pattern fill
To convert a hyperlink to regular text, right-click the hyperlink and then click ____ on the shortcut menu.
Remove Hyperlink
To instruct PowerPoint to confirm each change, click the Find Next button in the ____ dialog box.
Replace
Reading view is similar to ____ view because each slide displays individually, but the slides do not fill the entire screen.
Slide Show
____ view allows you to look at several slides at one time.
Slide Sorter
____ properties are associated with all Microsoft Office files and include author, title, and subject.
Standard
To advance rightward from one cell to the next in a table, press the ____ key.
TAB
____ is/are used to place worksheet, column, and row titles on a worksheet.
Text
When you use the keyboard to scroll to a different position in the document, the ____ automatically moves when you press the desired keys.
insertion point
Using the____, you can choose the arrangement of placeholders on a new slide.
layout gallery
PowerPoint's varied themes and ____ help give presentations a unified and aesthetically pleasing look.
layouts
A ____ paragraph places the first character of a text line near the left border of a placeholder.
left-aligned
Combining two or more selected cells into one cell is called ____ cells.
merging
All of the following are vertical alignment options EXCEPT ____.
middle
The Italic button is located on the ___.
mini toolbar
In the ____ letter style, the date, complimentary close, and signature block are positioned approximately one-half inch to the right of center or at the right margin.
modified block
To increase the font size of selected text, chose the Increase Font Size button, located ____.
on the mini toolbar
The Trim Video feature allows you to trim your clip by time measurements that are accurate to ____ of a second.
one-thousandth
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
The WordArt ____ is the exterior border surrounding each letter or symbol.
outline
Business documents can include all of the following EXCEPT ____.
personal letters
PowerPoint provides a wide variety of ____ shapes that can add visual interest to a slide.
predefined
A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.
presentation
A document theme sets the ___ for a presentation
set layout color scheme font
Adding a ____ to text adds depth and helps the letters display prominently.
shadow
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
Footnote text is _____.
single-spaced, left-aligned, and a smaller font size than the text in the research paper
PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.
slides
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
sparkline
A ____ is a named group of formatting characteristics.
style
A thesaurus can be used to look up a(n) _____, or a word similar in meaning to a given word.
synonym
A word with a meaning similar to that of another word is called a ____.
synonym
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
theme
When you begin creating a new PowerPoint presentation, you need to select a ____.
theme
PowerPoint displays many ____ that are varied and appealing and give you an excellent start at designing a presentation.
themes
Word includes a variety of document ____ to assist you with coordinating visual elements in a document.
themes
A(n) ____ is a book of synonyms.
thesaurus
You can use ____ options to repeat a background image many times vertically and horizontally on a slide.
tiling
Press the ENTER key in all of the following circumstances EXCEPT ____.
when the insertion point reaches the right margin
According to the MLA style, the _____ is a list of sources that are referenced directly in a research paper.
works cited page
_____ refers to cells not wide enough to display the entire entry.
#####
If you use the ___ template, as opposed to a formatted theme, you must make all design decisions.
Blank Presentation
_____ text often provides a strong visual appeal.
Rotated
The shortcut keys used to center a paragraph are ____.
CTRL+E
To move left one word with the keyboard, press the ____ key(s).
CTRL+LEFT ARROW
You can insert a new slide by pressing the ____ keyboard shortcut keys.
CTRL+M
To right-align a paragraph, use the ____ shortcut keys.
CTRL+R
To decrease a font size, use the ____ shortcut keys.
CTRL+SHIFT+<
To move up one paragraph, press the ____ key(s).
CTRL+UP ARROW
____ help one slide flow gracefully into the next during a slide show.
Transitions
____ allows you to see through the background, so that any text on the slide is visible.
Transparency
PowerPoint's ____ feature allows you to set the timing for a video clip.
Trim Video
A ____ is text and graphics that print at the bottom of every page.
footer
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
A ____ is a prewritten formula that is built into Excel.
function
One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide.
graphical elements
Word shades fields ____ on the screen.
gray
An accompanying ____ gives audience members reference notes and review material for your presentation.
handout
Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____.
horizontal ruler
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
indirect
Which of the following keys can you press to run a slide show starting with slide 1?
F5
The _____ feature automatically corrects typing, spelling, capitalization, or grammar errors as you type them.
AutoCorrect
Word, by default, places a tab stop at every ____ mark on the ruler.
.5"
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!
To change a selected shape's height or width to a specific value, type the value in the Height or Width text boxes on the ____.
(DRAWING TOOLS FORMAT tab | Size group)
The path to the Format Painter button is ____.
(HOME tab | Clipboard group)
By default, the Normal style inserts a vertical space equal to ____ line(s) between each line of text.
1.08
Every theme has ____ standard colors.
10
Excel remembers the last ____ actions you have completed.
100
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 Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
Which of the following patterns extends the fill series to 525, 475, 425?
625, 575
By default, the Normal style places ____ points of blank space after each paragraph.
8
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 formulas contains an absolute cell reference?
=$B$4
Which of the following calculations multiplies 23 by 0.01?
=23%
All of the following are valid Excel arithmetic operators EXCEPT ____.
>
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
To display the Color gallery, with the graphic selected, click the Color button in the ____ group on the PICTURE TOOLS FORMAT tab.
Adjust
____ includes special visual and sound effects applied to text or other content.
Animation
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
AutoCalculate
____ determines the overall lightness or darkness of an entire image.
Brightness
Click ____ to move a stacked object to the top of the stack.
Bring to Front
To select nonadjacent items, select the first item as usual, press and hold down the ____ key, and then while holding down the key, select the additional items.
CTRL
The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.
Clipboard
The ____ gallery has a wide variety of preset formatting combinations for coloring pictures.
Color
____ is the difference between the darkest and lightest areas of an image.
Contrast
To print a mailing label, click the Labels button on the MAILINGS tab in the ____ group.
Create
Which of the following keys moves the insertion point to the end of data in a cell?
END
Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.
ENTER
Each time you press the ____ key, Word carries forward custom tab stops to the next paragraph.
ENTER
In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.
ENTER
To enter a blank line into a document, press the ____ key without typing any text on the line.
ENTER
When you press the ____ key without entering any text after the automatic bullet character, Word turns off the automatic bullets feature.
ENTER
If you want to remove the AutoCorrect Options button from the screen, you can press the ____ key.
ESC
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
ESC
Clicking the ____ box completes an entry.
Enter
____ effects determine how slide elements first appear on a slide.
Entrance
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
____ effects determine how slide elements disappear.
Exit
Pressing the ____ key instructs Word to replace a building block name with the stored building block entry.
F3
To save time and avoid formatting errors, you can use the ____ to apply custom formatting to other places in your presentation quickly and easily.
Format Painter
The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Formula
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
Goal
____ is one color shade gradually progressing to another shade of the same color or to another color.
Gradient fill
Word provides a(n) ____ button, which increases the font size of selected text each time you tap or click the button.
Increase Font Size
____ text has a slanted appearance.
Italicized
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
When you click the ____ button for a selected graphic, Word provides options for changing how a graphic is positioned with text in a document.
Layout Options
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
NOW
Having used the Color gallery to change the color of a graphic, with the graphic selected, click ____ in the Color gallery to change a graphic back to its original color.
No Recolor
The default view in Excel is called ____ view.
Normal
You can type and format notes in the ____ pane.
Notes
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout
The default view in Word is ____.
Print Layout view
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Print Selection
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
Qtr2
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
RIGHT ARROW
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
____ effects convert colors in a picture to a wide variety of hues.
Recolor
You can select slide objects in order to delete them simultaneously by pressing the ____ key as you click each object.
SHIFT
When you open a new presentation, a slide with the default ____ layout appears.
Title Slide
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
You use ____ to view an XPS file.
XPS Viewer
____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.
Zooming
Cell references in a formula are called ____.
assumptions
The date you change a file is an example of a(n) ____ property.
automatically updated
The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.
font
In the ____ letter style, all components of the letter begin flush with the left margin.
block
Sepia changes picture colors into ____.
brown, gold, and yellow
A ____ symbol is another name for a dot symbol.
bullet
A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.
bulleted
Color ____ indicates that one color is dominating a picture.
cast
A tag name is an identifier that links a(n) ____ to a source.
citation
A ____ may be composed of a few individual objects or several complex groups of objects.
clip
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
colon (:)
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
constant
With ____ editing, Word automatically displays a Paste Options button near the pasted or moved text.
drag-and-drop
In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.
demoting
The range of cells receiving the content of copied cells is called the ____.
destination area
Using the mouse to move or copy cells is called ____.
drag and drop
Typing text, followed by two hyphens, followed by more text and then a space changes the two hyphens to a(n) ____.
em dash
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
exploded
A(n) ____ is a placeholder for data whose contents can change.
field
Solid ____ is one color used throughout the entire slide.
fill
Document ____ are the details about a file.
properties
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 ____ cell references.
relative
The person or persons requesting the worksheet should supply their requirements in a ____ document.
requirements
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
When you drag a graphic's ____ handle, the graphic moves in either a clockwise or counterclockwise direction.
rotate
In a business letter, the ____, if present, begins two lines below the last line of the inside address.
salutation
Dragging or sizing affects only a ____.
selected object
Which of the following is not a valid format symbol?
semi-colon (;)
The ____ introduces the presentation to the audience.
title slide
A slide ____ is a special effect used to progress from one slide to the next slide in a slide show.
transition
You would make a color in a graphic ____ if you wanted to remove part of a graphic or see text or colors behind a graphic.
transparent
here are ____ standard colors for text in a theme.
two
The first step in creating an effective worksheet is to make sure you ____.
understand what is required