Excel Tut 3

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

Optional arguments are always placed first in the argument list.

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

Functions are organized in the Function Library group on the FORMULAS tab.

A mixed reference "locks" one part of the cell reference while the other part can change.

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

By default, AutoFill copies only the content not the formatting of the original range to the selected range.

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

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.

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

A Statistical function that calculates the middle value of a collection of numbers

A date and time function

Used to cycle through reference types

Function counts the number of nonblank cells in the specified range

References that are fixed

A comparison operator

AutoFill pattern

Indicate that some part of formula is preventing Excel from returning a calculated value.

A function inside another function

Contains both relative and absolute references.

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

Which of the following is a Statistical function?

Which of the following is a Math & Trig function? ____

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

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

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

Use ____ references when you want different formulas to refer to the same cell.

____ arguments may provide more control over the returned value.

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

Which of the following is not an Excel function category? ____

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

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

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

When you nest functions, you should have ____.

The Insert Function button is in the ____ group.

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

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

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

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

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

Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

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

A(n) ____________________ reference contains both relative and absolute references.

The ____________________ function is a logical function that returns one value if the statement is true and returns a different value if the statement is false.

An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.