Exam 14: Working With Formulas and Functions

Explore all topics

Rebecca, a workflow analyst at Blanket Flower LLC, is using Microsoft Excel 2016 to develop work schedules for each department in the company. Her manager asks her to list the various departments in the company in the first column of the worksheet as shown in the figure given below. Which of the following orientations should Rebecca use to represent the cell content as shown in the figure?

(Multiple Choice)

4.9/5

(37)

Question 61

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

(Short Answer)

4.7/5

(31)

Question 62

In Microsoft Excel 2016, some styles are based on the workbook's current _____.

(Multiple Choice)

4.8/5

(37)

Question 63

The general syntax of Excel functions is _____.

(Multiple Choice)

4.9/5

(46)

Question 64

The syntax of the PMT function is PMT(rate,nper,pv[,fv=0][,type=0]).

(True/False)

4.9/5

(37)

Question 65

You cannot merge more than two cells in Excel.

(True/False)

5.0/5

(40)

Question 66

In the accompanying figure of Microsoft Excel 2016, Box 1 points to _____.

(Multiple Choice)

4.9/5

(36)

Question 67

The cells in the accompanying figure of Microsoft Excel 2016 are _____.

(Multiple Choice)

4.9/5

(37)

Question 68

In the accompanying figure of Microsoft Excel 2016, the present value (PV) is _____.

(Multiple Choice)

4.9/5

(35)

Question 69

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

(Short Answer)

4.9/5

(44)

Question 70

Which of the following is true of parenthesis in Microsoft Excel 2016?

(Multiple Choice)

5.0/5

(32)

Question 71

A cell background can be formatted by using the _____ button.

(Multiple Choice)

4.7/5

(30)

Question 72

The series in the accompanying figure of Microsoft Excel 2016 has been created using the _____ option.

(Multiple Choice)

4.9/5

(40)

Question 73

Which of the following step should be followed to edit the range reference to a cell when you have double-clicked the cell containing the formula or function?

(Multiple Choice)

4.9/5

(38)

Question 74

The DAY(date) function is used to _____.

(Multiple Choice)

4.8/5

(33)

Question 75

The accompanying figure shows a button in Microsoft Excel 2016 that is used to _____.

(Multiple Choice)

4.9/5

(33)

Question 76

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

(Essay)

4.8/5

(29)

Question 77

Showing 61 - 77 of 77

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

In Microsoft Excel 2016, some styles are based on the workbook's current _____.

The general syntax of Excel functions is _____.

The syntax of the PMT function is PMT(rate,nper,pv[,fv=0][,type=0]).

You cannot merge more than two cells in Excel.

In the accompanying figure of Microsoft Excel 2016, Box 1 points to _____.

The cells in the accompanying figure of Microsoft Excel 2016 are _____.

In the accompanying figure of Microsoft Excel 2016, the present value (PV) is _____.

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

Which of the following is true of parenthesis in Microsoft Excel 2016?

A cell background can be formatted by using the _____ button.

The series in the accompanying figure of Microsoft Excel 2016 has been created using the _____ option.

Which of the following step should be followed to edit the range reference to a cell when you have double-clicked the cell containing the formula or function?

The DAY(date) function is used to _____.

The accompanying figure shows a button in Microsoft Excel 2016 that is used to _____.

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

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

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

In Microsoft Excel 2016, some styles are based on the workbook's current _____.

The general syntax of Excel functions is _____. ​

The syntax of the PMT function is PMT(rate,nper,pv[,fv=0][,type=0]). ​

You cannot merge more than two cells in Excel. ​

​ In the accompanying figure of Microsoft Excel 2016, Box 1 points to _____. ​

The cells in the accompanying figure of Microsoft Excel 2016 are _____. ​

In the accompanying figure of Microsoft Excel 2016, the present value (PV) is _____. ​

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

Which of the following is true of parenthesis in Microsoft Excel 2016? ​

A cell background can be formatted by using the _____ button. ​

The series in the accompanying figure of Microsoft Excel 2016 has been created using the _____ option. ​

Which of the following step should be followed to edit the range reference to a cell when you have double-clicked the cell containing the formula or function? ​

The DAY(date) function is used to _____. ​

The accompanying figure shows a button in Microsoft Excel 2016 that is used to _____. ​

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

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 general syntax of Excel functions is _____.

The syntax of the PMT function is PMT(rate,nper,pv[,fv=0][,type=0]).

You cannot merge more than two cells in Excel.

In the accompanying figure of Microsoft Excel 2016, Box 1 points to _____.

The cells in the accompanying figure of Microsoft Excel 2016 are _____.

In the accompanying figure of Microsoft Excel 2016, the present value (PV) is _____.

Which of the following is true of parenthesis in Microsoft Excel 2016?

A cell background can be formatted by using the _____ button.

The series in the accompanying figure of Microsoft Excel 2016 has been created using the _____ option.

Which of the following step should be followed to edit the range reference to a cell when you have double-clicked the cell containing the formula or function?

The DAY(date) function is used to _____.

The accompanying figure shows a button in Microsoft Excel 2016 that is used to _____.

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