Question 1

With ____ interest,the borrower always pays more money to the lender the following year.

Accepted Answer

A)  principal 
B)  simple 
C)  compound 
D)  maximum 
A)  principal 
B)  simple 
C)  compound 
D)  maximum

Question 2

A logical function is a function that works with values that are either ____.

Accepted Answer

A)  right or wrong 
B)  absolute or relative 
C)  positive or negative 
D)  true or false 
A)  right or wrong 
B)  absolute or relative 
C)  positive or negative 
D)  true or false

Question 3

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

Accepted Answer

Insert Fun

Question 4

____________________ copies content and formats from a cell or range into an adjacent cell or range.

Accepted Answer

The answer of ____________________ copies content and formats from a...

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains absolute and relative references

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 6

Using the AutoFill feature is more efficient than copying and pasting.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  A is equal to B 
B)  A does not equal B 
C)  A1+B1 is equal to C1 
D)  none of the above 
A)  A is equal to B 
B)  A does not equal B 
C)  A1+B1 is equal to C1 
D)  none of the above

Question 8

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

Accepted Answer

A)  column width 
B)  row height 
C)  both a.and b. 
D)  neither a.nor b. 
A)  column width 
B)  row height 
C)  both a.and b. 
D)  neither a.nor b.

Question 9

Arguments can be ____.

Accepted Answer

A)  cell references 
B)  numbers 
C)  text 
D)  all of the above 
A)  cell references 
B)  numbers 
C)  text 
D)  all of the above

Question 10

Which of the following is a Math & Trig function? ____

Accepted Answer

A)  INT 
B)  COUNT 
C)  MIN 
D)  AVERAGE 
A)  INT 
B)  COUNT 
C)  MIN 
D)  AVERAGE

Question 11

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.

Accepted Answer

A)  OLAP 
B)  CUBE 
C)  Logical 
D)  Text 
A)  OLAP 
B)  CUBE 
C)  Logical 
D)  Text

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-To calculate payments for any type of loan

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 13

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

Accepted Answer

A)  The average of the values in the range A1:A100 is added to the integer. 
B)  The average of the integer value is calculated. 
C)  The average of the values in the range A1:A100 is calculated. 
D)  The integer portion of the value is extracted. 
A)  The average of the values in the range A1:A100 is added to the integer. 
B)  The average of the integer value is calculated. 
C)  The average of the values in the range A1:A100 is calculated. 
D)  The integer portion of the value is extracted.

Question 14

Functions can be incorporated as part of larger formulas.

Accepted Answer

A) True 
 B)False

Question 15

You can open the Insert Function dialog box by clicking the Insert Function button on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 16

When you copy and paste a formula with mixed reference to a new location,the absolute portion of the cell reference remains fixed and the relative portion shifts._________________________

Accepted Answer

A) True 
 B)False

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A date and time function

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 18

The ____________________ is the middle value from a sample.

Accepted Answer

The answer of The ____________________ is the middle value from...

Question 19

-Referring to the figure above,the last entry shown in Column N is 7,200.There is a black "plus sign" on the lower right edge of the cell that is the ____.

Accepted Answer

A)  fill handle 
B)  Auto Fill Options button 
C)  formula finder 
D)  function finder 
A)  fill handle 
B)  Auto Fill Options button 
C)  formula finder 
D)  function finder

Question 20

The ____________________ function is a logical function that returns one value if the statement is true and returns a different value if the statement is false.

Accepted Answer

The answer of The ____________________ function is a logical function...

With ____ interest,the borrower always pays more money to the lender the following year.

A logical function is a function that works with values that are either ____.

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

____________________ copies content and formats from a cell or range into an adjacent cell or range.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains absolute and relative references

Using the AutoFill feature is more efficient than copying and pasting.

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

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

Arguments can be ____.

Which of the following is a Math & Trig function? ____

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To calculate payments for any type of loan

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

Functions can be incorporated as part of larger formulas.

You can open the Insert Function dialog box by clicking the Insert Function button on the Ribbon.

When you copy and paste a formula with mixed reference to a new location,the absolute portion of the cell reference remains fixed and the relative portion shifts._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A date and time function

The ____________________ is the middle value from a sample.

-Referring to the figure above,the last entry shown in Column N is 7,200.There is a black "plus sign" on the lower right edge of the cell that is the ____.

The ____________________ function is a logical function that returns one value if the statement is true and returns a different value if the statement is false.

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

With ____ interest,the borrower always pays more money to the lender the following year.

A logical function is a function that works with values that are either ____.

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

____________________ copies content and formats from a cell or range into an adjacent cell or range.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains absolute and relative references

Using the AutoFill feature is more efficient than copying and pasting.

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

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

Arguments can be ____.

Which of the following is a Math & Trig function? ____

The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To calculate payments for any type of loan

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

Functions can be incorporated as part of larger formulas.

You can open the Insert Function dialog box by clicking the Insert Function button on the Ribbon.

When you copy and paste a formula with mixed reference to a new location,the absolute portion of the cell reference remains fixed and the relative portion shifts._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A date and time function

The ____________________ is the middle value from a sample.

-Referring to the figure above,the last entry shown in Column N is 7,200.There is a black "plus sign" on the lower right edge of the cell that is the ____.

The ____________________ function is a logical function that returns one value if the statement is true and returns a different value if the statement is false.

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