Final for CIT 105

Click ____ to move a stacked object toward the top of the stack.

bring forward

Click ____ to move a stacked object toward the top of the stack.

bring to front

Which of the following calculations multiplies 23 by 0.01?

23%

What effect does the Comma Style format have on the selected cells?

Displays cell contents with two decimal places and commas as thousands separators

A ___________ is a specific design with coordinating colors, fonts, and special effects

document theme

A _______ is a prewritten formula that is built into Excel.

function

_________ 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

A _______ is text and graphics that print at the top of each page.

header

A _________ IF function is one in which the action to be taken for the true of false case includes yet another IF function

nested

You can type and format notes in the ____ pane.

notes

You can type comments to yourself in the ____ for a specific slide while working in Normal view.

notes pane

To print a range of cells in the active worksheet, click ________ in the Settings area in the Print gallery.

print selection

A ________ chart provides a simple way to show trends and variations in a range of data within a single cell.

sparkline

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

square brackets [ ]

The _________ introduces the presentation to the audience.

title slide

Which of the following formulas contains an absolute cell reference?

$B$4

WordArt ____ in the interior of a letter can consist of a solid color, texture, picture, or gradient.

fill

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

format

Combining two or more selected cells into one cell is called ____ cells.

merging

Charts can either be embedded in a worksheet or placed in a separate ____.

chart sheet

To order the records in the answer to a query in a particular way, you ____ the records.

sort

A word with a meaning similar to that of another word is called a ____.

synonym

_____ 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 unique identifier is also called a primary key.

true

Form view displays a single record at a time.

true

In Access, the columns in a table are called fields.

true

To omit duplicates from a query, use the property sheet and change the Unique Values property to ________.

yes

The _________ function display the highest value in a range.

MAX

The ____ function is useful when you want to assign a value to a cell based on a logical test.

IF

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ________ on the ribbon, and then click the Report Wizard button.

CREATE

________ is the difference between the darkest and lightest areas of an image.

contrast

In a multilevel bulleted list slide, creating a lower-level paragraph is called ______ the text.

demoting

Which comparison operator means "not equal to"?

<>

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

Press ____ to select the entire worksheet.

CTRL+A

Pressing the ____ keyboard shortcut key(s) selects cell A1.

CTRL+HOME

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

EXTERNAL DATA

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

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

colon (:)

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

colon (:)

__________ effects determine how slide elements first appear on a slide.

entrance

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

false

You can include ____ in calculations to indicate which calculation should be done first.

parentheses ( )

The box on a slide that has a dotted or hatch-mark border and that contains the insertion point is a text ___________.

placeholder

A _______ reference is an adjusted cell reference in a copied and pasted formula.

relative

A field whose data type is ____ can contain any characters.

short text

A slide ____ is a special effect used to progress from one slide to the next in a slide show.

transition