click below

click below

Normal Size Small Size show me how

# CTS 130 EM03

### Excel Module 3

Question | Answer |
---|---|

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 |

=INT(AVERAGE(A1:A100)) is an example of a(n) ____ function. | nested |

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

Every function has to follow ____. | syntax |

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

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

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 |

The amount of money being loaned is known as the ____. | principal |

If you were to see ##### in cell B10, the ____ is too small to view the entire value. | column width |

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 |

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

One of the most common statistical approaches is to ____ the sample data. | 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 |

FUNCTION(argument1, argument2, ...) is ____. | general syntax of all functions |

Arguments can be ____. | cell references, numbers, or text |

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

Excel functions are organized into ____ categories | eleven |

Lookup & Reference is ____. | an excel function category |

The ____ function category retrieves data from multidimensional databases involving online analytical processing or OLAP. | cube |

In “SUM(number1 [, number2, number3, ...])”, number 1, number 2, and number 3 may be numbers or ____. | cell references |

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

Functions can be ____. | incorporated as part of larger formulas or placed inside another function |

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

When you nest functions, you should have ____. | same number of left and right parentheses |

The Insert Function button is in the ____ group. | function library |

Optional arguments are in ____ type. | normal |

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

Most Recently Used is a ____. | category in the Insert Function Arguments dialog box |

The fill handle copies ____. | content and formats |

Using AutoFill is ____ than copying and pasting. | faster |

Blue, Accent1, Light 60% is an example of cell ____. | formatting |

Another way to copy a formula is to use the Fill button on the ____ group. | editing |

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, etc. |

For most loan and investment calculations, you need to enter the annual interest rate ____ the number of times the interest is compounded during the year. | divided by |

As you drag the fill handle, you will see ____. | screen tips |

A logical function is a function that works with values that are either ____. | true or false |

>= is a(n) ____ operator. | comparison |

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

Part of effective formula writing is knowing when to use relative, absolute, and ____ references. | mixed |

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