Quiz 7 Excel 3

A constant is a value in a formula that doesn’t change. _______________

True

Optional arguments are always placed first in the argument list. _______________

False

One challenge of nesting functions is to make sure that you include all of the parentheses. _______________

True

An error value begins with a pound sign (#) followed by an error name that indicates the type of error. _______________

True

To display the current date and time, which is updated each time the workbook is reopened, use the TODAY function. _______________

False

The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false. _______________

True

Lookup tables can be constructed for exact match or approximate match lookups. _______________

True

An argument can be any type of value including text, numbers, cell references, or even other formulas or functions. _______________

True

An error value indicates that some part of a function is preventing Excel from returning a calculated value. ________________

False

When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell. _________________

True

The following mixed reference in the formula, $A5, has an absolute column reference and a relative row reference. _________________________

True

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1

False

The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.

True

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. _________________________

True

Which of the following is a Statistical function? _____

AVERAGE

=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.

nested

The numbers, text, or cell references used by the function to return a value are called ____.

arguments

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 ____ function returns the maximum value in the range.

MAX

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.

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

Another name for the middle value is the ____ value.

median

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

default

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

Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____

Information

In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____

The average of the values in the range A1:A100 is calculated.

When you nest functions, you should have ____.

the same number of left and right parentheses

The Insert Function button is in the ____ group.

Function Library

The Insert Function dialog box has a(n) ____ option.

search

The fill handle copies ____.

content and formats

Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.

content

Using AutoFill, what would be the extended series of the initial entry Jan? ___

Feb, Mar, Apr

A logical function is a function that works with values that are either ____.

true or false

In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.

A does not equal B

____ 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.

Mixed

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.

Lookup

If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

#N/A

One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results.

what-if analysis

____________________ is a set of rules which specifies how a function should be written.

Syntax

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Insert Function dialog box

Not all functions have arguments, and some functions have ____________________ arguments, which are not required for the function to return a value, but can be included to provide more control over the returned value.

optional