Excel Chapter 3 MC Flashcards
The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.
CUBE
The ____ category of Excel functions retrieves and analyzes data.
Database
The ____ category of Excel functions returns (true-false) values
Logical
Which of the following is a Statistical function?
AVERAGE
Which of the following is a Math & Trig function?
RAND( ), ROUND
=MAX(A1:A100)/100 is an example of a(n) ____ function.
Statistical
Which of the following is not a function?
CUBE
After you describe a function in the Insert Function dialog box, click ____.
Go
Every function has to follow ____.
syntax
Which of the following is not a comparison operator?
«
In the following formula: =IF(A1=”YES”, “DONE”, “RESTART”), what happens if A1= “NO”?
The formula returns the text “RESTART”.
Which of the following is not a date function?
And
The PMT function is a(n) ____ function.
Financial
With ____ interest, the borrower always pays more money to the lender the following year.
compound
The FV function stands for ____.
future value
Functions can be ____.
Incorporated as part of larger formulas
Placed inside another function
Nested
The ____ button is equivalent to using the SUM function.
Autosum
The advantage of ____ references is that you can create a “general” formula that you can use again and again in your worksheet.
relative
Absolute references are marked with a ____.
$
When you copy a formula that contains an absolute reference to a new location, the reference
____.
does not change
Which type of references should you use when you want different formulas to refer to the same cell.
Absolute
The most common approach to summarize data is to ____ it.
average
Another name for the middle value is the ____ value.
median
The ____ is most often used with data that has only a few possible values.
mode
____ arguments may provide more control over the returned value.
Optional
Arguments can be ____.
Cell References
Numbers
Text
If an optional argument is not included, Excel assumes a(n) ____ value for it.
default
Excel functions are organized into ____ categories.
11
Which of the following is not an Excel function category?
Algebra
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
COUNT
