11 RY Quiz

The intersection of a row and a column in a spreadsheet is called a

• cell

• label

• range

• value

Which of the following would MOST likely be placed above a graph?

• Title

• Legend

• Gridline

• Data Label

Spreadsheet formulae uses

• values or labels

• values, labels, or cell addresses

• labels or cell addresses

• values, ranges, or cell addresses

Which of the following functions are performed by spreadsheets?
I.      Applying formulae to numerical data to determine values.

II.   Performing automatic re-calculations when values have been updated.

III. Capturing, displaying, and manipulating text data.

• I and II only

• I and III only

• II and III only

• I, II and III

Which of the following features can be used in a spreadsheet to copy the result across multiple rows in a single column?

• Autofill

• AutoFilter

• Advanced fill

• Automatic filter

The field that uniquely identifies a record in a database is called the

• foreign key

• primary key

• alternate key

• master key

Suppose you wish to count the number of values in a column, select the function that would give this result.

• =RANK(CELL RANGE)

• =COUNT(CELL RANGE)

• =COUNTIF(CELL RANGE)

• COUNTIF(CELL RANGE)

The following formula is in position of B6 of a spreadsheet. = B3+B4 +$B$5 IF the formula is copied to the position located immediately on the left, what would be the resulting formula?

• C3 + C4 + C5

• A3 + A4 + C5

• A3 + A4 + $B$5

• C3 + C4 + $B$5

Which of the following is the first step in performing a Mail Merge?

• Creating the main document

• Preparing the data source

• Inserting merge fields

• Merging the documents

What type of document is the main document in a Mail Merge?

• A spreadsheet

• A database

• A template with merge fields

• A report