Question 1

In the Function Arguments dialog box,Pamela enters the number of payments for the ____ argument.

Accepted Answer

A)  pv 
B)  nper 
C)  nv 
D)  np 
A)  pv 
B)  nper 
C)  nv 
D)  np

Question 2

The Logical button is part of the Comparison Library group._________________________

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  mortgage 
B)  principal 
C)  loan amount 
D)  proposed principal 
A)  mortgage 
B)  principal 
C)  loan amount 
D)  proposed principal

Question 4

Optional arguments are always placed last in the argument list.

Accepted Answer

A) True 
 B)False

Question 5

A(n)____________________ operator is a symbol that indicates the relationship between two values.

Accepted Answer

The answer of A(n)____________________ operator is a symbol that indicates...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is a Statistical function?

Accepted Answer

A)  INT 
B)  RAND 
C)  ROUND 
D)  AVERAGE 
A)  INT 
B)  RAND 
C)  ROUND 
D)  AVERAGE

Question 8

Use relative references when you want to repeat the same formula with different cells._________________________

Accepted Answer

A) True 
 B)False

Question 9

Which function is used to change 3,162.50 to 3,163? ____

Accepted Answer

A)  RAND 
B)  ROUND 
C)  DROP 
D)  ROUNDUP 
A)  RAND 
B)  ROUND 
C)  DROP 
D)  ROUNDUP

Question 10

When you copy a formula that contains an absolute reference to a new location,the reference ____.

Accepted Answer

A)  is updated automatically 
B)  does not change 
C)  becomes bold 
D)  has a dotted outline in its cell 
A)  is updated automatically 
B)  does not change 
C)  becomes bold 
D)  has a dotted outline in its cell

Question 11

For more complex patterns,you can use the Fill Series dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 12

In the Function Arguments dialog box,required arguments are in bold type.

Accepted Answer

A) True 
 B)False

Question 13

When the data includes a few extremely large or extremely small values,it might be best to use the median value from the sample._________________________

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is not a function? ____

Accepted Answer

A)  AVERAGE 
B)  SUM 
C)  CUBE 
D)  MEDIAN 
A)  AVERAGE 
B)  SUM 
C)  CUBE 
D)  MEDIAN

Question 15

One of the most common statistical approaches is to ____ the sample data.

Accepted Answer

A)  record 
B)  average 
C)  count 
D)  organize 
A)  record 
B)  average 
C)  count 
D)  organize

Question 16

When you nest functions,you should have ____.

Accepted Answer

A)  the equal sign 
B)  the same number of left and right parentheses 
C)  at least two functions 
D)  the correct number of brackets 
A)  the equal sign 
B)  the same number of left and right parentheses 
C)  at least two functions 
D)  the correct number of brackets

Question 17

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

Accepted Answer

A)  Location 
B)  Information 
C)  Reference 
D)  Description 
A)  Location 
B)  Information 
C)  Reference 
D)  Description

Question 18

Case-Based Critical Thinking Questions
Case 3-1
Charles is a recent college graduate.He is paying rent for the first time,as well as utility bills,such as cable,electric,and telephone.He also has some hefty school loan payments.Charles has a good paying job and knows that even though he has lots of expenses,it is critical for him to save money each month,too.He decides to create a budget for himself in Excel 2010.
-Charles wants to find out what his average cable bill is.As he types the letter "A" in order to type the function AVERAGE ____.

Accepted Answer

A)  the Insert Function dialog box appears 
B)  a list of functions that begin with the letter A appear 
C)  the Format Painter appears 
D)  a list of operators that begin with the letter A appear 
A)  the Insert Function dialog box appears 
B)  a list of functions that begin with the letter A appear 
C)  the Format Painter appears 
D)  a list of operators that begin with the letter A appear

Question 19

Which of the following is not a date function? ____

Accepted Answer

A)  Year 
B)  Now 
C)  And 
D)  Today 
A)  Year 
B)  Now 
C)  And 
D)  Today

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Equal to a percentage of principal for each period that the money has been lent

Accepted Answer

A) NOW 
B) PMT function 
C) Principal 
D) Simple interest 
E) fv
F)<
G)F4
H)Absolute references
I)nested
J)mixed
K)Mon,Tues,Wed,Thurs,Fri
L)Median 
A) NOW 
B) PMT function 
C) Principal 
D) Simple interest 
E) fv
F)<
G)F4
H)Absolute references
I)nested
J)mixed
K)Mon,Tues,Wed,Thurs,Fri
L)Median

In the Function Arguments dialog box,Pamela enters the number of payments for the ____ argument.

The Logical button is part of the Comparison Library group._________________________

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

Optional arguments are always placed last in the argument list.

A(n)____________________ operator is a symbol that indicates the relationship between two values.

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

Which of the following is a Statistical function?

Use relative references when you want to repeat the same formula with different cells._________________________

Which function is used to change 3,162.50 to 3,163? ____

When you copy a formula that contains an absolute reference to a new location,the reference ____.

For more complex patterns,you can use the Fill Series dialog box._________________________

In the Function Arguments dialog box,required arguments are in bold type.

When the data includes a few extremely large or extremely small values,it might be best to use the median value from the sample._________________________

Which of the following is not a function? ____

One of the most common statistical approaches is to ____ the sample data.

When you nest functions,you should have ____.

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

Which of the following is not a date function? ____

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Equal to a percentage of principal for each period that the money has been lent

Getting Started With Excel

Formatting a Workbook

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 3: Working With Formulas and Functions

In the Function Arguments dialog box,Pamela enters the number of payments for the ____ argument.

The Logical button is part of the Comparison Library group._________________________

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

Optional arguments are always placed last in the argument list.

A(n)____________________ operator is a symbol that indicates the relationship between two values.

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

Which of the following is a Statistical function?

Use relative references when you want to repeat the same formula with different cells._________________________

Which function is used to change 3,162.50 to 3,163? ____

When you copy a formula that contains an absolute reference to a new location,the reference ____.

For more complex patterns,you can use the Fill Series dialog box._________________________

In the Function Arguments dialog box,required arguments are in bold type.

When the data includes a few extremely large or extremely small values,it might be best to use the median value from the sample._________________________

Which of the following is not a function? ____

One of the most common statistical approaches is to ____ the sample data.

When you nest functions,you should have ____.

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

Which of the following is not a date function? ____

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Equal to a percentage of principal for each period that the money has been lent

Getting Started With Excel

Formatting a Workbook

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters