Exam 14: Working With Formulas and Functions

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. On the Home tab, in the Alignment group, Morris notices the feature shown in the accompanying figure. Morris identifies this feature as the _____ button.

(Multiple Choice)

4.7/5

(40)

Question 21

The formula =SUM(A7:A9) is an example of a(n) _____ reference.

(Multiple Choice)

4.7/5

(48)

Question 22

Which of the following buttons in Microsoft Excel 2016 can be used to combine two or more cells into one cell?

(Multiple Choice)

4.9/5

(29)

Question 23

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

(Short Answer)

4.8/5

(44)

Question 24

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.

(Multiple Choice)

4.9/5

(34)

Question 25

The accompanying figure shows the buttons in Microsoft Excel 2016 that are used to _____ cells.

(Multiple Choice)

4.7/5

(38)

Question 26

Functions that return true or false values are called _____.

(Multiple Choice)

4.9/5

(25)

Question 27

In the accompanying figure of a feature of Microsoft Excel 2016, B6:B11 is the _____.

(Multiple Choice)

4.9/5

(36)

Question 28

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

(Short Answer)

4.7/5

(38)

Question 29

The Wrap Text option is used to center cell content vertically within the cell.

(True/False)

4.8/5

(33)

Question 30

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

(Short Answer)

4.9/5

(32)

Question 31

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

(Multiple Choice)

4.8/5

(41)

Question 32

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

(Short Answer)

4.9/5

(42)

Question 33

When a worksheet is printed, the gridlines are not printed unless you specify that they should be.

(True/False)

4.8/5

(44)

Question 34

Which of the following is true of optional arguments?

(Multiple Choice)

4.9/5

(38)

Question 35

Which of the following is true of borders in Excel?

(Multiple Choice)

4.8/5

(38)

Question 36

While referencing cells on a worksheet in other workbook, if the worksheet name contains spaces, _____.

(Multiple Choice)

4.9/5

(43)

Question 37

RAND() is an example of a _____ function.

(Multiple Choice)

4.8/5

(45)

Question 38

Which of the following is true of a what-if analysis?

(Multiple Choice)

4.8/5

(34)

Question 39

The Paste Options button in Excel offers fewer options than in Word.

(True/False)

4.7/5

(34)

Question 40

Showing 21 - 40 of 77

The formula =SUM(A7:A9) is an example of a(n) _____ reference.

Which of the following buttons in Microsoft Excel 2016 can be used to combine two or more cells into one cell?

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

The accompanying figure shows the buttons in Microsoft Excel 2016 that are used to _____ cells.

Functions that return true or false values are called _____.

In the accompanying figure of a feature of Microsoft Excel 2016, B6:B11 is the _____.

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

The Wrap Text option is used to center cell content vertically within the cell.

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

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

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

When a worksheet is printed, the gridlines are not printed unless you specify that they should be.

Which of the following is true of optional arguments?

Which of the following is true of borders in Excel?

While referencing cells on a worksheet in other workbook, if the worksheet name contains spaces, _____.

RAND() is an example of a _____ function.

Which of the following is true of a what-if analysis?

The Paste Options button in Excel offers fewer options than in Word.

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

The formula =SUM(A7:A9) is an example of a(n) _____ reference. ​

Which of the following buttons in Microsoft Excel 2016 can be used to combine two or more cells into one cell? ​

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

The accompanying figure shows the buttons in Microsoft Excel 2016 that are used to _____ cells. ​

Functions that return true or false values are called _____. ​

In the accompanying figure of a feature of Microsoft Excel 2016, B6:B11 is the _____. ​ ​

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

The Wrap Text option is used to center cell content vertically within the cell. ​

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

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

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

When a worksheet is printed, the gridlines are not printed unless you specify that they should be. ​

Which of the following is true of optional arguments? ​

Which of the following is true of borders in Excel? ​

While referencing cells on a worksheet in other workbook, if the worksheet name contains spaces, _____. ​

RAND() is an example of a _____ function. ​

Which of the following is true of a what-if analysis? ​

The Paste Options button in Excel offers fewer options than in Word. ​

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 formula =SUM(A7:A9) is an example of a(n) _____ reference.

Which of the following buttons in Microsoft Excel 2016 can be used to combine two or more cells into one cell?

The accompanying figure shows the buttons in Microsoft Excel 2016 that are used to _____ cells.

Functions that return true or false values are called _____.

In the accompanying figure of a feature of Microsoft Excel 2016, B6:B11 is the _____.

The Wrap Text option is used to center cell content vertically within the cell.

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

When a worksheet is printed, the gridlines are not printed unless you specify that they should be.

Which of the following is true of optional arguments?

Which of the following is true of borders in Excel?

While referencing cells on a worksheet in other workbook, if the worksheet name contains spaces, _____.

RAND() is an example of a _____ function.

Which of the following is true of a what-if analysis?

The Paste Options button in Excel offers fewer options than in Word.