CMAP 120 Final Exam

Question 1

In Access, a unique identifier in a field is known as a primary key.

Accepted Answer

True

Question 2

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

Accepted Answer

synonym

Question 3

By default, slides in a new presentation are in ____ orientation.

Accepted Answer

Landscape

Question 4

A ____ is a specific design with coordinating colors, fonts, and special effects in a PowerPoint presentation.

Accepted Answer

Document theme

Question 5

A bibliography lists all publication information about the source.

Accepted Answer

True

Question 6

In Access, a(n) ____ contains information about a given person, product, or event?

Accepted Answer

Record

Question 7

Document ____ are the details about a file.

Accepted Answer

Properties

Question 8

PowerPoint's varied themes and ____ help give presentations a unified and aesthetically pleasing look.

Accepted Answer

Layouts

Question 9

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Accepted Answer

26

Question 10

Forcing information to start on the top of the next page in Word is referred to as a ____________.

Accepted Answer

hard page break

Question 11

A background is considered fill.

Accepted Answer

True

Question 12

The equal sign (=) precedes a formula.

Accepted Answer

True

Question 13

A ____ paragraph places the last character of text near the right border of a paragraph.

Accepted Answer

Right aligned

Question 14

A ____ is a named group of formatting characteristics in Word with attributes like color, size and paragraph spacing

Accepted Answer

Style

Question 15

In Word, a paragraph by default is left aligned; turn on __ to have all new paragraphs first line indented a half inch.

Accepted Answer

first line indent

Question 16

In Excel, never retype values that are already in a worksheet; instead use the ____ of a cell.

Accepted Answer

Cell reference

Question 17

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

Accepted Answer

Bring to Front

Question 18

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

Accepted Answer

demoting

Question 19

In PowerPoint, an accompanying ____ gives audience members reference notes and review material for your presentation.

Accepted Answer

Handout

Question 20

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

Accepted Answer

Function

Question 21

You should use a ____ chart to compare items to a portion of the whole

Accepted Answer

Pie

Question 22

To complete more basic mathematical operations like multiplying or subtracting a cell from another, use a ___.

Accepted Answer

Formula

Question 23

The ___ function sums the numbers in a specified range and then divides the sum by the number of cells within the range.

Accepted Answer

AVERAGE

Question 24

The ____ function is useful when you want to add several cells next to each other.

Accepted Answer

SUM

Question 25

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right

Accepted Answer

True

CMAP 120 Final Exam

Questions 25

CMAP 120 Final Exam

Questions 25