Question 1

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

Accepted Answer

A)  search 
B)  formatting 
C)  find and replace 
D)  expand/collapse 
A)  search 
B)  formatting 
C)  find and replace 
D)  expand/collapse A

Question 2

To insert a function,click the ____________________ tab on the Ribbon.

Accepted Answer

Formulas

Question 3

To copy only the formats or only the formulas,click the Copy Options button and select the appropriate option._________________________

Accepted Answer

A) True 
 B)False  False

Question 4

The ____________________ dialog box organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Accepted Answer

The answer of The ____________________ dialog box organizes all of...

Question 5

Excel functions are organized into ____ categories.

Accepted Answer

A)  8 
B)  10 
C)  11 
D)  13 
A)  8 
B)  10 
C)  11 
D)  13

Question 6

To enter a mixed reference,type $ after either the row or column reference.

Accepted Answer

A) True 
 B)False

Question 7

What is the relationship between the Function Arguments dialog box and the Insert Function dialog box?

Accepted Answer

The relationship between the Function Ar

Question 8

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.

Accepted Answer

A)  cell 
B)  relative 
C)  absolute 
D)  formula 
A)  cell 
B)  relative 
C)  absolute 
D)  formula

Question 9

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

Accepted Answer

A)  SUM 
B)  COUNT 
C)  COUNTA 
D)  AUTOSUM 
A)  SUM 
B)  COUNT 
C)  COUNTA 
D)  AUTOSUM

Question 10

$B$8 is a(n)relative reference to cell B8._________________________

Accepted Answer

A) True 
 B)False

Question 11

COUNT is a Statistical function.

Accepted Answer

A) True 
 B)False

Question 12

The ____ function returns the maximum value in the range.

Accepted Answer

A)  TOP 
B)  FIRST 
C)  MAX 
D)  MOST 
A)  TOP 
B)  FIRST 
C)  MAX 
D)  MOST

Question 13

TODAY is an example of a(n)____________________ function.

Accepted Answer

The answer of TODAY is an example of a(n)____________________ function....

Question 14

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.

Accepted Answer

A)  added to 
B)  subtracted from 
C)  multiplied by 
D)  divided by 
A)  added to 
B)  subtracted from 
C)  multiplied by 
D)  divided by

Question 15

A(n)____________________ function is a function that works with values that are either true or false.

Accepted Answer

The answer of A(n)____________________ function is a function that works...

Question 16

If a formula contains several functions,Excel starts with the outermost function and then moves inward.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-AutoFill pattern

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

Question 19

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Those that are fixed

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

Question 20

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 has been told by one bank that if approved,she will have to pay a compound interest.This means that ____.

Accepted Answer

A)  interest paid is equal to a percentage of principal for each period that the money has been lent 
B)  interest paid is calculated on the principal and any previous interest payments that have been added to that principal 
C)  interest paid is equal to a .05 percent of principal for each period that the money has been lent 
D)  interest paid is calculated on the principal and any late fees that have been added to that principal 
A)  interest paid is equal to a percentage of principal for each period that the money has been lent 
B)  interest paid is calculated on the principal and any previous interest payments that have been added to that principal 
C)  interest paid is equal to a .05 percent of principal for each period that the money has been lent 
D)  interest paid is calculated on the principal and any late fees that have been added to that principal

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

To insert a function,click the ____________________ tab on the Ribbon.

To copy only the formats or only the formulas,click the Copy Options button and select the appropriate option._________________________

The ____________________ dialog box organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Excel functions are organized into ____ categories.

To enter a mixed reference,type $ after either the row or column reference.

What is the relationship between the Function Arguments dialog box and the Insert Function dialog box?

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.

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

$B$8 is a(n)relative reference to cell B8._________________________

COUNT is a Statistical function.

The ____ function returns the maximum value in the range.

TODAY is an example of a(n)____________________ function.

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.

A(n)____________________ function is a function that works with values that are either true or false.

If a formula contains several functions,Excel starts with the outermost function and then moves inward.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -AutoFill pattern

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Those that are fixed

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

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

To insert a function,click the ____________________ tab on the Ribbon.

To copy only the formats or only the formulas,click the Copy Options button and select the appropriate option._________________________

The ____________________ dialog box organizes all of the functions by category and allows you to search for functions that perform particular calculations.

Excel functions are organized into ____ categories.

To enter a mixed reference,type $ after either the row or column reference.

What is the relationship between the Function Arguments dialog box and the Insert Function dialog box?

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.

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

$B$8 is a(n)relative reference to cell B8._________________________

COUNT is a Statistical function.

The ____ function returns the maximum value in the range.

TODAY is an example of a(n)____________________ function.

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.

A(n)____________________ function is a function that works with values that are either true or false.

If a formula contains several functions,Excel starts with the outermost function and then moves inward.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -AutoFill pattern

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Those that are fixed

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