Question 1

An argument can be any type of value including text,numbers,cell references,or even other formulas or functions._______________

Accepted Answer

A) True 
 B)False

Question 2

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) C) and D)
F) B) and C)

Question 3

Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

Accepted Answer

A)  EXACT
B)  1
C)  TRUE
D)  FALSEE) A) and C)
F) B) and C) D

Question 4

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

Accepted Answer

A)  Absolute
B)  Relative
C)  Mixed
D)  MatchedE) None of the above
F) B) and C)

Question 5

The Fill Formatting Only option,which is the default,copies both the content and the formatting.______________

Accepted Answer

A) True 
 B)False

Question 6

The ____________________ is the middle value from a sample.

Accepted Answer

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

Question 7

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

Accepted Answer

A)  INT
B)  COUNT
C)  MIN
D)  AVERAGEE) B) and D)
F) A) and B)

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)  formulaE) C) and D)
F) B) and D)

Question 9

Ellen opens Excel 2016 and enters her monthly income for one year beginning with January.To create a series of months,she can ____.

Accepted Answer

A)  Type = Jan-Dec in cell A1 and then press Enter.
B)  Type January in cell A1 and then drag the filll handle.
C)  Type =YEAR in cell A1 and then press Enter.
D)  Type =DATE(Jan, Dec)  in cell A1 and then press Enter.E) B) and D)
F) B) and C)

Question 10

Another name for the middle value is the ____ value.

Accepted Answer

A)  mode
B)  center
C)  median
D)  relativeE) B) and C)
F) A) and D)

Question 11

Use ____ references when you want different formulas to refer to the same cell.

Accepted Answer

A)  mixed
B)  relative
C)  absolute
D)  fixedE) A) and C)
F) All of the above

Question 12

A mixed reference "locks" one part of the cell reference while the other part can change._______________

Accepted Answer

A) True 
 B)False  True

Question 13

Which of the following is not an Excel function category? ____

Accepted Answer

A)  Math & Trig
B)  Algebra
C)  Statistical
D)  TextE) All of the above
F) C) and D)

Question 14

Which of the following is a Statistical function? _____

Accepted Answer

A)  INT
B)  RAND
C)  ROUND
D)  AVERAGEE) B) and C)
F) A) and C)

Question 15

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)  AUTOSUME) B) and D)
F) All of the above B

Question 16

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

Accepted Answer

A) True 
 B)False

Question 17

A constant is a value in a formula that doesn't change._______________

Accepted Answer

A) True 
 B)False

Question 18

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current cell._________________

Accepted Answer

A) True 
 B)False

Question 19

The fill handle copies ____.

Accepted Answer

A)  content only
B)  formats only
C)  content and formats
D)  formats and cell referencesE) C) and D)
F) A) and C)

Question 20

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

Accepted Answer

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

Exam 9: Performing Calculations With Formulas and Functions

An argument can be any type of value including text,numbers,cell references,or even other formulas or functions._______________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

Correct AnswerverifiedD

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

Correct AnswerverifiedShow Answer

The Fill Formatting Only option,which is the default,copies both the content and the formatting.______________

Correct AnswerverifiedShow Answer

The ____________________ is the middle value from a sample.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Ellen opens Excel 2016 and enters her monthly income for one year beginning with January.To create a series of months,she can ____.

Correct AnswerverifiedShow Answer

Another name for the middle value is the ____ value.

Correct AnswerverifiedShow Answer

Use ____ references when you want different formulas to refer to the same cell.

Correct AnswerverifiedShow Answer

A mixed reference "locks" one part of the cell reference while the other part can change._______________

Correct AnswerverifiedTrue

Which of the following is not an Excel function category? ____

Correct AnswerverifiedShow Answer

Which of the following is a Statistical function? _____

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

Correct AnswerverifiedShow Answer

A constant is a value in a formula that doesn't change._______________

Correct AnswerverifiedShow Answer

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current cell._________________

Correct AnswerverifiedShow Answer

The fill handle copies ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

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
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified