COSC 1301 Final Exam

Ace your homework & exams now with Quizwiz!

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


Related study sets

Completing the Application, Underwriting, and Delivering Policy

View Set

ACCT 3306: Chapter 5: Cost-Volume-Profit Relationships

View Set

Nutrition in Health: Chapter 11: Water and Major Minerals.

View Set

predicting weather and climate change

View Set

Health Promotions and Psychosocial

View Set

NCLEX Book questions Lung Cancer

View Set