Question 1

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

Accepted Answer

Answers will vary. A financial function

Question 2

Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range? ​

Accepted Answer

A) Alt+R 
B) F4 
C) Shift+PgDn 
D) F1 
A) Alt+R 
B) F4 
C) Shift+PgDn 
D) F1

Question 3

Case 14-1 Jenny, a programmer, uses Microsoft Excel 2016 to generate data required for the programs she develops. She uses various functions in Excel to perform the required calculations.
Jenny is coding a security program to generate numerical passwords in Excel. Jenny should use the _____ function to generate the numerical portions of the passwords arbitrarily.

Accepted Answer

A) SUM() 
B) RAND() 
C) ROUND() 
D) INT() 
A) SUM() 
B) RAND() 
C) ROUND() 
D) INT()

Question 4

The _____ button can be used to see a more precise interest rate per period for loans. ​

Accepted Answer

A) Increase Decimal 
B) Middle Align 
C) Sort & Filter 
D) Trace Precedents 
A) Increase Decimal 
B) Middle Align 
C) Sort & Filter 
D) Trace Precedents

Question 5

You cannot apply styles to a cell and its contents in Excel. ​

Accepted Answer

A) True 
 B)False

Question 6

Case 14-1 Jenny, a programmer, uses Microsoft Excel 2016 to generate data required for the programs she develops. She uses various functions in Excel to perform the required calculations.
Jenny enters =INT(3.1428) in one of the cells, which returns the integer value. The function used by Jenny is a _____ function.

Accepted Answer

A) Math & Trig 
B) Statistical 
C) Date & Time 
D) Logical 
A) Math & Trig 
B) Statistical 
C) Date & Time 
D) Logical

Question 7

The _____ command on the Paste button menu is used to control how content is pasted from the Clipboard in Excel. ​

Accepted Answer

A)  Paste Special ​ 
B) Paste Options 
C) Detailed Paste 
D) Paste Cells 
A)  Paste Special ​ 
B) Paste Options 
C) Detailed Paste 
D) Paste Cells

Question 8

The accompanying figure shows a cell in Microsoft Excel 2016 with _____. ​

Accepted Answer

A)  mixed references ​ 
B) financial functions 
C) center aligned text 
D) the fill color option 
A)  mixed references ​ 
B) financial functions 
C) center aligned text 
D) the fill color option

Question 9

The accompanying figure shows the Border tab in the _____ dialog box in Microsoft Excel 2016. ​ ​

Accepted Answer

A) Format Cells 
B) AutoFill 
C) Function Arguments 
D) Paste Special 
A) Format Cells 
B) AutoFill 
C) Function Arguments 
D) Paste Special

Question 10

Functions that retrieve data from multidimensional databases involving online analytical processing (OLAP) are called _____. ​

Accepted Answer

A) Compatibility functions 
B) Cube functions 
C) Math & Trig functions 
D) Statistical functions 
A) Compatibility functions 
B) Cube functions 
C) Math & Trig functions 
D) Statistical functions

Question 11

In the accompanying figure of Microsoft Excel 2016, the highlighted portion labeled "Savings Account" is an example of _____. ​

Accepted Answer

A) merging two cells 
B) indenting cell contents 
C) using AutoFill functions 
D) citing mixed references 
A) merging two cells 
B) indenting cell contents 
C) using AutoFill functions 
D) citing mixed references

Question 12

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 13

Which of the following AutoFill features copies the content but not the pattern? ​

Accepted Answer

A) Fill Without Formatting 
B) AutoFill Content Only 
C) Copy Content Only 
D) Undo Formatting 
A) Fill Without Formatting 
B) AutoFill Content Only 
C) Copy Content Only 
D) Undo Formatting

Question 14

The formula =SUM(D28:D30) uses an absolute reference. ​

Accepted Answer

A) True 
 B)False

Question 15

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 16

To remove an indentation, click the Decrease Indent button. ​

Accepted Answer

A) True 
 B)False

Question 17

​ The Increase Indent button is in the Alignment group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 18

Borders are the lines that divide the columns and rows on a worksheet and define the structure of the worksheet. ​

Accepted Answer

A) True 
 B)False

Question 19

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 20

Which of the following functions is used to calculate the day of the week from the date value? ​

Accepted Answer

A) WEEKDAY( date [, return_type ]) 
B) WEEKDAY( return-type, ) 
C) WEEKDAY( day, month, year ) 
D) WEEKDAY( MM / DD / YY ) 
A) WEEKDAY( date [, return_type ]) 
B) WEEKDAY( return-type, ) 
C) WEEKDAY( day, month, year ) 
D) WEEKDAY( MM / DD / YY )

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

Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range?

The _____ button can be used to see a more precise interest rate per period for loans.

You cannot apply styles to a cell and its contents in Excel.

The _____ command on the Paste button menu is used to control how content is pasted from the Clipboard in Excel.

The accompanying figure shows a cell in Microsoft Excel 2016 with _____.

The accompanying figure shows the Border tab in the _____ dialog box in Microsoft Excel 2016.

Functions that retrieve data from multidimensional databases involving online analytical processing (OLAP) are called _____.

In the accompanying figure of Microsoft Excel 2016, the highlighted portion labeled "Savings Account" is an example of _____.

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

Which of the following AutoFill features copies the content but not the pattern?

The formula =SUM(D28:D30) uses an absolute reference.

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

To remove an indentation, click the Decrease Indent button.

The Increase Indent button is in the Alignment group on the Home tab.

Borders are the lines that divide the columns and rows on a worksheet and define the structure of the worksheet.

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

Which of the following functions is used to calculate the day of the week from the date value?

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

Exam 14: Working With Formulas and Functions

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

Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range? ​

The _____ button can be used to see a more precise interest rate per period for loans. ​

You cannot apply styles to a cell and its contents in Excel. ​

The _____ command on the Paste button menu is used to control how content is pasted from the Clipboard in Excel. ​

The accompanying figure shows a cell in Microsoft Excel 2016 with _____. ​

The accompanying figure shows the Border tab in the _____ dialog box in Microsoft Excel 2016. ​ ​

Functions that retrieve data from multidimensional databases involving online analytical processing (OLAP) are called _____. ​

In the accompanying figure of Microsoft Excel 2016, the highlighted portion labeled "Savings Account" is an example of _____. ​

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

Which of the following AutoFill features copies the content but not the pattern? ​

The formula =SUM(D28:D30) uses an absolute reference. ​

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

To remove an indentation, click the Decrease Indent button. ​

​ The Increase Indent button is in the Alignment group on the Home tab.

Borders are the lines that divide the columns and rows on a worksheet and define the structure of the worksheet. ​

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

Which of the following functions is used to calculate the day of the week from the date value? ​

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

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

Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range?

The _____ button can be used to see a more precise interest rate per period for loans.

You cannot apply styles to a cell and its contents in Excel.

The _____ command on the Paste button menu is used to control how content is pasted from the Clipboard in Excel.

The accompanying figure shows a cell in Microsoft Excel 2016 with _____.

The accompanying figure shows the Border tab in the _____ dialog box in Microsoft Excel 2016.

Functions that retrieve data from multidimensional databases involving online analytical processing (OLAP) are called _____.

In the accompanying figure of Microsoft Excel 2016, the highlighted portion labeled "Savings Account" is an example of _____.

Which of the following AutoFill features copies the content but not the pattern?

The formula =SUM(D28:D30) uses an absolute reference.

To remove an indentation, click the Decrease Indent button.

The Increase Indent button is in the Alignment group on the Home tab.

Borders are the lines that divide the columns and rows on a worksheet and define the structure of the worksheet.

Which of the following functions is used to calculate the day of the week from the date value?