The ___ category of Excel function returns (true-false) values.
question
AVERAGE
answer
Which of the following is a Statistical function?
question
INT
answer
Which of the following is a Math & Trig function?
question
Nested
answer
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.
question
Go
answer
After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.
question
Arguments
answer
The numbers, text, or cell references used by the function to return a value are called ____.
question
<<
answer
Which of the following is NOT a comparison operator?
question
The formula returns the text "RESTART".
answer
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?
question
AND
answer
Which of the following is NOT a date function?
question
MAX
answer
The ___ function returns the maximum value in the range.
question
Relative
answer
One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.
question
$
answer
Absolute references are marked with a ___.
question
Does not change
answer
When you copy a formula that contains an absolute reference to a new location, the reference ____.
question
Absolute
answer
Use ___ references when you want different formulas to refer to the same cell.
question
Median
answer
Another name for the middle value is the ___ value.
question
Optional
answer
____ arguments may provide more control over the returned value.
question
The general syntax of all functions
answer
FUNCTION(argument1, argument2, ...) is ____.
question
Default
answer
If an optional argument is not included, Excel assumes a ___ value for it.
question
11
answer
Excel functions are organized into ___ categories.
question
Algebra
answer
Which of the following is not an Excel function category?
question
COUNT
answer
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
question
Cell references
answer
In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ____.
question
Information
answer
Which category of Excel functions returns information about the format, location, or contents of worksheet cells?
question
The average of the values in the range A1:A100 is calculated.
answer
In the formula =INT(AVERAGE(A1:A100)), which would occur first?
question
The same number of left and right parentheses
answer
When you nest functions, you should have ____.
question
Function Library
answer
The Insert Function button is in the ___ group.
question
Search
answer
The Insert Function dialog box has a ___ option.
question
Contents and formats
answer
The fill handle copies ___.
question
Content
answer
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.
question
Feb, Mar, Apr
answer
Using AutoFill, what would be the extended series of the initial entry Jan?
question
True or False
answer
A logical function is a function that works with values that are either ____.
question
A1 does not equal B1
answer
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.
question
Mixed
answer
____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.
question
a blank cell
answer
=IF(G22="x", SUM(H22:J22), " ") with display ______ if G22 is not equal to "x".
question
Lookup
answer
___ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.
question
#N/A
answer
If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.
question
What-if analysis
answer
One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results.
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy