Question 1

A(n) _________ is a cell reference that contains both an absolute reference and a relative reference. 
A)phantom reference 
B)dangling reference 
C)symbolic reference 
D)pointer reference

Accepted Answer

The answer of A(n) _________ is a cell reference that...

Question 2

A _________ is a line you add along an edge of a cell. 
A)gridline 
B)caption 
C)border 
D)clip

Accepted Answer

The answer of A _________ is a line you add...

Question 3

The _________ option merges each of the rows in the selected range around the columns in the range. 
A)Merge & Centre 
B)Increase Indent 
C)Decrease Indent 
D)Merge Across

Accepted Answer

The answer of The _________ option merges each of the...

Question 4

Case 14-2 Morris, a librarian, wishes to use Microsoft Excel 2016 to manage data on the books in the library. He explores various tabs and buttons in Excel to present the data as intended.
Morris notices the feature shown in the accompanying figure on the Home tab of his worksheet. Morris identifies this feature as the _____ button.
​

A)Orientation
B)Increase Indent
C)Top Align
D)Wrap Text

Accepted Answer

The answer of Case 14-2 Morris, a librarian, wishes to...

Question 5

TODAY function is the most commonly used ________ function. 
A)finalize 
B)time 
C)financial 
D)date

Accepted Answer

The answer of TODAY function is the most commonly used...

Question 6

List and briefly describe the financial functions used for loans and investments in Excel. ​

Accepted Answer

The answer of List and briefly describe the financial functions...

Question 7

If a(n) _________ is not included in a function, Excel assumes a default value for it. 
A)recordset 
B)multitable query 
C)optional argument 
D)endnote

Accepted Answer

The answer of If a(n) _________ is not included in...

Question 8

Briefly describe the different options available under the AutoFill Options button. ​

Accepted Answer

The answer of Briefly describe the different options available under...

Question 9

​ When are relative, absolute, and mixed references used in Excel? Briefly explain.

Accepted Answer

The answer of ​ When are relative, absolute, and mixed...

Question 10

_________ are numbers, text, or cell references used by a function to return a value. 
A)Ribbons 
B)Piconets 
C)Microwaves 
D)Arguments

Accepted Answer

The answer of _________ are numbers, text, or cell references...

Question 11

_________ is an examination of how changing values entered directly in a worksheet affect calculated values. 
A)What-if analysis 
B)Inferential analysis 
C)Exploratory analysis 
D)If-Then-Else analysis

Accepted Answer

The answer of _________ is an examination of how changing...

Question 12

_________ is the amount added to the principal by the lender. 
A)Nominal value 
B)Installment 
C)Interest 
D)Intrinsic value

Accepted Answer

The answer of _________ is the amount added to the...

Question 13

Cell references that remain fixed when a formula is copied to a new location are called _________. 
A)phantom references 
B)relative references 
C)absolute references 
D)pointer references

Accepted Answer

The answer of Cell references that remain fixed when a...

Question 14

The term _________ is defined as the length of time between each loan payment.
A)down payment 
B)loan period 
C)payment period 
D)nominal value

Accepted Answer

The answer of The term _________ is defined as the...

Question 15

A cell reference that is interpreted in relation to the location of the cell containing the formula is called _________. 
A)absolute reference 
B)pointer reference 
C)phantom reference 
D)relative reference

Accepted Answer

The answer of A cell reference that is interpreted in...

Question 16

You can change the color of cells by adding background colors, also known as _________. 
A)fill handle 
B)color palettes 
C)fill colors 
D)flex wrap

Accepted Answer

The answer of You can change the color of cells...

Question 17

A(n) _________ is a function related to monetary calculations, such as loans and payments. 
A)exponential function 
B)financial function 
C)finalize function 
D)library function

Accepted Answer

The answer of A(n) _________ is a function related to...

Quiz 14: Working With Formulas and Functions

A(n) _________ is a cell reference that contains both an absolute reference and a relative reference. A)phantom reference B)dangling reference C)symbolic reference D)pointer reference

A _________ is a line you add along an edge of a cell. A)gridline B)caption C)border D)clip

The _________ option merges each of the rows in the selected range around the columns in the range. A)Merge & Centre B)Increase Indent C)Decrease Indent D)Merge Across

TODAY function is the most commonly used ________ function. A)finalize B)time C)financial D)date

List and briefly describe the financial functions used for loans and investments in Excel. ​

If a(n) _________ is not included in a function, Excel assumes a default value for it. A)recordset B)multitable query C)optional argument D)endnote

Briefly describe the different options available under the AutoFill Options button. ​

​ When are relative, absolute, and mixed references used in Excel? Briefly explain.

_________ are numbers, text, or cell references used by a function to return a value. A)Ribbons B)Piconets C)Microwaves D)Arguments

_________ is an examination of how changing values entered directly in a worksheet affect calculated values. A)What-if analysis B)Inferential analysis C)Exploratory analysis D)If-Then-Else analysis

_________ is the amount added to the principal by the lender. A)Nominal value B)Installment C)Interest D)Intrinsic value

Cell references that remain fixed when a formula is copied to a new location are called _________. A)phantom references B)relative references C)absolute references D)pointer references

The term _________ is defined as the length of time between each loan payment. A)down payment B)loan period C)payment period D)nominal value

A cell reference that is interpreted in relation to the location of the cell containing the formula is called _________. A)absolute reference B)pointer reference C)phantom reference D)relative reference

You can change the color of cells by adding background colors, also known as _________. A)fill handle B)color palettes C)fill colors D)flex wrap

A(n) _________ is a function related to monetary calculations, such as loans and payments. A)exponential function B)financial function C)finalize function D)library function

List and briefly describe the financial functions used for loans and investments in Excel.

Briefly describe the different options available under the AutoFill Options button.

When are relative, absolute, and mixed references used in Excel? Briefly explain.