Exam 3: Working With Formulas and Functions

Using AutoFill is ____ than copying and pasting.

In the figure above,the total number of payments can be found as follows: ____

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

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

The Insert Function button is in the ____ group.

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

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

In "SUM(number1 [,number2,number3,...])",number 1,number 2,and number 3 may be numbers or ____.

Optional arguments are in ____ type.

Which of the following is not a comparison operator? ____

Case-Based Critical Thinking Questions Case 3-2 Pamela is getting ready to purchase her first condominium.To get ready for the mortgage process,she gathers her Excel spreadsheets that contain all of her financial information. -Pamela is ready to figure out what her monthly loan payment will be.She uses the PMT function in the ____ category.

You can build decision-making capability into a formula through the use of a logical function.

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

The ____ category of Excel functions returns (true-false)values

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A function inside another function

PMT (rate, nper, $p v,[f v=0] \quad[t y p e=0])$ -In the figure above,nper stands for the ____.

FUNCTION(argument1,argument2,... )is ____.

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

For more complex patterns,you can use the ____________________ dialog box instead of the AutoFill feature.

AutoFill can recognize some patterns if you plug in a minimum of at least two values,such as "Monday,Tuesday."