Question 1

The Insert Function button is in the ____ group.

Accepted Answer

A)   Calculation
B)   Function Library
C)   Sort & Filter
D)   HomeE) C) and D)
F) None of the above

Question 2

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.

Accepted Answer

A)   Banking
B)   Financial
C)   Math & Trig
D)   InterestE) None of the above
F) B) and D)

Question 3

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

Accepted Answer

A)   letters
B)   cell references
C)   symbols
D)   operatorsE) B) and C)
F) B) and D)

Question 4

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

Accepted Answer

A)   functions
B)   content
C)   cell references
D)   left-alignsE) All of the above
F) C) and D)

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)   total number of payment periods required to pay off the loan
B)   total number of payment periods required to pay off the interest
C)   number of payments per year
D)   number of interest payments per year E) A) and B)
F) All of the above

Question 8

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

Accepted Answer

The answer of A(n)____________________ reference contains both relative and absolute...

Question 9

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

Accepted Answer

A)   the syntax of writing optional arguments
B)   an example of a formula
C)   the general syntax of all functions
D)   the general syntax of all formulasE) None of the above
F) C) and D)

Question 10

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

Accepted Answer

A)   uary
B)   Feb,Mar,Apr
C)   Kan,Lan,Man,Nan
D)   Jan1,Jan2,Jan3,E) A) and B)
F) A) and C)

Question 11

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

Accepted Answer

A)   Information
B)   Statistical
C)   Logical
D)   Math & TrigE) A) and D)
F) A) and C)

Question 12

Optional arguments are in ____ type.

Accepted Answer

A)   Bold
B)   Italic
C)   Normal
D)   RedE) None of the above
F) All of the above

Question 13

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

Accepted Answer

A)   default
B)   generic
C)   static
D)   absoluteE) A) and C)
F) A) and B)

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Using AutoFill is ____ than copying and pasting.

Accepted Answer

A)   slower
B)   faster
C)   safer
D)   riskierE) A) and B)
F) B) and D)

Question 16

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

Accepted Answer

A)  NOW
B)  PMT function
C)  Principal
D)  Simple interest
E)  fvF) G) F4H) Absolute referencesI) nestedJ) mixedK) Mon,Tues,Wed,Thurs,FriL) MedianM) D) and K)
N) B) and L)

Question 17

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

Accepted Answer

A)   Go
B)   Select
C)   Insert
D)   NextE) All of the above
F) None of the above

Question 18

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

Accepted Answer

A)   =B4*B6
B)   =B4/B6
C)   =B6*B4
D)   =B6/B4E) All of the above
F) A) and D)

Question 19

Which of the following is not a comparison operator? ____

Accepted Answer

A)   =
B)   
C)   
D)   E) C) and D)
F) A) and D)

Question 20

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

Accepted Answer

The answer of For more complex patterns,you can use the...

Exam 3: Working With Formulas and Functions

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Optional arguments are in ____ type.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Which of the following is not a comparison operator? ____

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The Insert Function button is in the ____ group.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Using AutoFill is ____ than copying and pasting.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 3: Working With Formulas and Functions

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Optional arguments are in ____ type.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is not a comparison operator? ____

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The Insert Function button is in the ____ group.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Using AutoFill is ____ than copying and pasting.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified