Question 1

​ The accompanying figure shows the _____ group on the Home tab in Microsoft Excel 2016.

Accepted Answer

A) Alignment 
B) Editing 
C) Styles 
D) Font 
A) Alignment 
B) Editing 
C) Styles 
D) Font A

Question 2

Asher, a high school student, is learning how to use Excel. He enters a sequence of numbers, 1.0, 1.25, 1.5, …, as data in the first column. Which of the following features of AutoFill should Asher use to continue the pattern of data? ​

Accepted Answer

A) Fill Without Formatting 
B) Flash Fill 
C) Copy Cells 
D) Fill series 
A) Fill Without Formatting 
B) Flash Fill 
C) Copy Cells 
D) Fill series D

Question 3

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

Accepted Answer

Answers will vary. Relative references-use relative references when you want to repeat the same formula with cells in different locations on your worksheet. Relative references are commonly used when copying a formula that sums a column of numbers or that calculates the cost of several items by multiplying the item cost by the quantity being purchased. 
Absolute references-use absolute references when you want different formulas to refer to the same cell. This usually occurs when a cell contains a constant value, such as a tax rate, that will be used in formulas throughout the worksheet. 
Mixed references-mixed 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. Please see the section "Using Relative, Absolute, and Mixed Cell References in Formulas" for more information.

Question 4

Andy, a chess player, wants to change the background of his Excel workbook to make it look like a chessboard. For this purpose, Andy should use the _____ button. ​

Accepted Answer

A) Fill Color 
B) SmartArt 
C) Cell Style 
D) Theme 
A) Fill Color 
B) SmartArt 
C) Cell Style 
D) Theme

Question 5

The dialog box in the accompanying figure of Microsoft Excel 2016 is the _____ dialog box. ​ ​

Accepted Answer

A) Series 
B) Date & Time 
C) Trend 
D) AutoFill 
A) Series 
B) Date & Time 
C) Trend 
D) AutoFill

Question 6

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 7

_____ is the amount of money being loaned. ​

Accepted Answer

A) Principal 
B) Down payment 
C) Interest 
D) Stake 
A) Principal 
B) Down payment 
C) Interest 
D) Stake

Question 8

The MIDPOINT function calculates the middle value of a collection of numbers. ​

Accepted Answer

A) True 
 B)False

Question 9

In the accompanying figure of a feature of Microsoft Excel 2016, the button that Box 1 indicates is used to _____. ​ ​

Accepted Answer

A) collapse the dialog box 
B) calculate the sum of the two cells 
C) add an absolute reference to the cell 
D) indicate an error 
A) collapse the dialog box 
B) calculate the sum of the two cells 
C) add an absolute reference to the cell 
D) indicate an error

Question 10

Miley is using Excel to calculate the value of power. She varies the value of voltage while maintaining a constant value of current. In the final step, she adds a $ in front of the current value in a formula. The formula entered by Miley is composed of _____. ​

Accepted Answer

A) relative references only 
B) absolute references 
C) refined references 
D) mixed references only 
A) relative references only 
B) absolute references 
C) refined references 
D) mixed references only

Question 11

​ $A$7 is a relative cell reference.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is true of the COUNTA( value1 [, value2 , value3 ,...]) function? ​

Accepted Answer

A) It calculates the number of cells that are not empty in ranges. 
B) It calculates the average of a collection of numbers. 
C) It calculates the cells in a range containing numbers. 
D) It calculates the maximum value of a collection of numbers. 
A) It calculates the number of cells that are not empty in ranges. 
B) It calculates the average of a collection of numbers. 
C) It calculates the cells in a range containing numbers. 
D) It calculates the maximum value of a collection of numbers.

Question 13

_________ 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 14

The WEEKDAY function returns the current date and time. ​

Accepted Answer

A) True 
 B)False

Question 15

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...

Question 16

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 17

In the accompanying figure of a feature of Microsoft Excel 2016, _____ points to the value that will be displayed in the active cell. ​ ​

Accepted Answer

A) Box 1 
B) Box 2 
C) Box 3 
D) Box 4 
A) Box 1 
B) Box 2 
C) Box 3 
D) Box 4

Question 18

​ In the accompanying figure of Microsoft Excel 2016, a worksheet named Budget refers to cell B10 on another worksheet named Car Loan Calculator in the same workbook. Which of the following will be the reference to cell B10?

Accepted Answer

A) ='Car Loan Calculator'!B10 
B) ="Car Loan Calculator"!B10 
C) ='Car Loan Calculator'[B10] 
D) ="Car Loan Calculator"[B10] 
A) ='Car Loan Calculator'!B10 
B) ="Car Loan Calculator"!B10 
C) ='Car Loan Calculator'[B10] 
D) ="Car Loan Calculator"[B10]

Question 19

The Fill Color button arrow is located in the _____ group on the Home tab. ​

Accepted Answer

A) Font 
B) Alignment 
C) Styles 
D) Editing 
A) Font 
B) Alignment 
C) Styles 
D) Editing

Question 20

After selecting a function from the list, press the _____ key to insert it into the active cell. ​

Accepted Answer

A) Tab 
B) Shift 
C) F4 
D) Insert 
A) Tab 
B) Shift 
C) F4 
D) Insert

Exam 14: Working With Formulas and Functions

​ The accompanying figure shows the _____ group on the Home tab in Microsoft Excel 2016.

Asher, a high school student, is learning how to use Excel. He enters a sequence of numbers, 1.0, 1.25, 1.5, …, as data in the first column. Which of the following features of AutoFill should Asher use to continue the pattern of data? ​

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

Andy, a chess player, wants to change the background of his Excel workbook to make it look like a chessboard. For this purpose, Andy should use the _____ button. ​

The dialog box in the accompanying figure of Microsoft Excel 2016 is the _____ dialog box. ​ ​

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

_____ is the amount of money being loaned. ​

The MIDPOINT function calculates the middle value of a collection of numbers. ​

In the accompanying figure of a feature of Microsoft Excel 2016, the button that Box 1 indicates is used to _____. ​ ​

Miley is using Excel to calculate the value of power. She varies the value of voltage while maintaining a constant value of current. In the final step, she adds a $ in front of the current value in a formula. The formula entered by Miley is composed of _____. ​

​ $A$7 is a relative cell reference.

Which of the following is true of the COUNTA( value1 [, value2 , value3 ,...]) function? ​

_________ 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

The WEEKDAY function returns the current date and time. ​

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

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

In the accompanying figure of a feature of Microsoft Excel 2016, _____ points to the value that will be displayed in the active cell. ​ ​

​ In the accompanying figure of Microsoft Excel 2016, a worksheet named Budget refers to cell B10 on another worksheet named Car Loan Calculator in the same workbook. Which of the following will be the reference to cell B10?

The Fill Color button arrow is located in the _____ group on the Home tab. ​

After selecting a function from the list, press the _____ key to insert it into the active cell. ​

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Creating a Workbook

Creating an Advanced Workbook

Inserting and Formatting Charts

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Apresentation

Enhancing a Presentation

Integrating Word, Excel, Access and Powerpoint

Filters

The accompanying figure shows the _____ group on the Home tab in Microsoft Excel 2016.

Asher, a high school student, is learning how to use Excel. He enters a sequence of numbers, 1.0, 1.25, 1.5, …, as data in the first column. Which of the following features of AutoFill should Asher use to continue the pattern of data?

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

Andy, a chess player, wants to change the background of his Excel workbook to make it look like a chessboard. For this purpose, Andy should use the _____ button.

The dialog box in the accompanying figure of Microsoft Excel 2016 is the _____ dialog box.

_____ is the amount of money being loaned.

The MIDPOINT function calculates the middle value of a collection of numbers.

In the accompanying figure of a feature of Microsoft Excel 2016, the button that Box 1 indicates is used to _____.

Miley is using Excel to calculate the value of power. She varies the value of voltage while maintaining a constant value of current. In the final step, she adds a $ in front of the current value in a formula. The formula entered by Miley is composed of _____.

$A$7 is a relative cell reference.

Which of the following is true of the COUNTA( value1 [, value2 , value3 ,...]) function?

The WEEKDAY function returns the current date and time.

In the accompanying figure of a feature of Microsoft Excel 2016, _____ points to the value that will be displayed in the active cell.

In the accompanying figure of Microsoft Excel 2016, a worksheet named Budget refers to cell B10 on another worksheet named Car Loan Calculator in the same workbook. Which of the following will be the reference to cell B10?

The Fill Color button arrow is located in the _____ group on the Home tab.

After selecting a function from the list, press the _____ key to insert it into the active cell.