Excel Chapter 3 MC

Question 1

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.

Answer 1

CUBE

Question 2

The ____ category of Excel functions retrieves and analyzes data.

Answer 2

Database

Question 3

The ____ category of Excel functions returns (true-false) values

Answer 3

Logical

Question 4

Which of the following is a Statistical function?

Answer 4

AVERAGE

Question 5

Which of the following is a Math & Trig function?

Answer 5

RAND( ), ROUND

Question 6

=MAX(A1:A100)/100 is an example of a(n) ____ function.

Answer 6

Statistical

Question 7

Which of the following is not a function?

Answer 7

CUBE

Question 8

After you describe a function in the Insert Function dialog box, click ____.

Answer 8

Go

Question 9

Every function has to follow ____.

Answer 9

syntax

Question 10

Which of the following is not a comparison operator?

Answer 10

«

Question 11

In the following formula: =IF(A1=”YES”, “DONE”, “RESTART”), what happens if A1= “NO”?

Answer 11

The formula returns the text “RESTART”.

Question 12

Which of the following is not a date function?

Answer 12

And

Question 13

The PMT function is a(n) ____ function.

Answer 13

Financial

Question 14

With ____ interest, the borrower always pays more money to the lender the following year.

Answer 14

compound

Question 15

The FV function stands for ____.

Answer 15

future value

Question 16

Functions can be ____.

Answer 16

Incorporated as part of larger formulas

Placed inside another function

Nested

Question 17

The ____ button is equivalent to using the SUM function.

Answer 17

Autosum

Question 18

The advantage of ____ references is that you can create a “general” formula that you can use again and again in your worksheet.

Answer 18

relative

Question 19

Absolute references are marked with a ____.

Answer 19

$

Question 20

When you copy a formula that contains an absolute reference to a new location, the reference
____.

Answer 20

does not change

Question 21

Which type of references should you use when you want different formulas to refer to the same cell.

Answer 21

Absolute

Question 22

The most common approach to summarize data is to ____ it.

Answer 22

average

Question 23

Another name for the middle value is the ____ value.

Answer 23

median

Question 24

The ____ is most often used with data that has only a few possible values.

Answer 24

mode

Question 25

____ arguments may provide more control over the returned value.

Answer 25

Optional

Question 26

Arguments can be ____.

Answer 26

Cell References

Numbers

Text

Question 27

If an optional argument is not included, Excel assumes a(n) ____ value for it.

Answer 27

default

Question 28

Excel functions are organized into ____ categories.

Answer 28

11

Question 29

Which of the following is not an Excel function category?

Answer 29

Algebra

Question 30

Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

Answer 30

COUNT