Exam 15: Creating an Advanced Workbook

Sarah, who has been an apparel retailer for ten years, wants to analyze and compare the monthly profits for the ten years. She fills details such as the year, month, and profit in three columns on an Excel sheet. She wants to highlight the months with a profit of more than $100. In this scenario, Sarah should use the _____ function to highlight the relevant cells at once.

(Multiple Choice)

4.9/5

(35)

Question 61

A text argument can be included in an IF function by enclosing it in quotation marks.

(True/False)

5.0/5

(43)

Question 62

Which of the following statements is true of hiding rows and columns in an Excel sheet?

(Multiple Choice)

4.9/5

(41)

Question 63

The region of an active Microsoft Excel sheet that is sent to the printer is known as the _________. A)print space B)print preview C)print area D)print domain

(Short Answer)

4.8/5

(40)

Question 64

Hannah, a financial analyst, creates a balance sheet for one of her clients. When she prints the balance sheet, the content appears split at awkward places on the sheet. Hannah decides to reprint the sheet. In this scenario, Hannah should use the _____ to split the Excel sheet into logical segments.

(Multiple Choice)

4.7/5

(34)

Question 65

Case 15-1 Frank, a business analyst at Pro-White Technologies, deals with vast amount of data and analysis. Since Frank uses Excel worksheets for most of his work, he uses several advanced functions of Excel that eases and speeds up his work. Frank has a set of data in four columns B, C, D, and E, which he wants to collate in a single columnA)He uses Flash Fill to collate the data. However, after filling the column using Flash Fill, Frank changes the data in cell C5. Which of the following is the most likely result of this change?

(Multiple Choice)

4.8/5

(36)

Question 66

In the accompanying image of Microsoft Excel 2016, box A points to the _____.

(Multiple Choice)

4.9/5

(42)

Question 67

In the accompanying nested function, which of the following functions will be executed first? =IF(D4>((SUM(E4:E10))/7)*100,"True")

(Multiple Choice)

4.8/5

(48)

Question 68

In the accompanying image of Microsoft Excel 2016, box A points to the _____.

(Multiple Choice)

4.9/5

(38)

Question 69

For Flash Fill to suggest content, you need to:

(Multiple Choice)

4.8/5

(36)

Question 70

In a new worksheet, the page margins are set to 0.3 inches on the left and right and 0.5 inches on the top and bottom with 0.6-inch margins around the page header and footer.

(True/False)

4.9/5

(44)

Question 71

Garner, a management student, conducts a survey on the purchasing power of people in a small town and records the information on an Excel sheet. When he tries to print the data, print preview displays the last two rows on a separate sheet. To print the entire content on a single sheet, Garner should:

(Multiple Choice)

4.7/5

(27)

Question 72

Which of the following statements is true of the IF function in Excel?

(Multiple Choice)

4.8/5

(40)

Question 73

Steve enters the equation "=2*(16 − 4)/10+23" in a cell in Microsoft Excel. The operation within parenthesis indicates that:

(Multiple Choice)

4.9/5

(37)

Question 74

Showing 61 - 74 of 74

A text argument can be included in an IF function by enclosing it in quotation marks.

Which of the following statements is true of hiding rows and columns in an Excel sheet?

The region of an active Microsoft Excel sheet that is sent to the printer is known as the _________. A)print space B)print preview C)print area D)print domain

Hannah, a financial analyst, creates a balance sheet for one of her clients. When she prints the balance sheet, the content appears split at awkward places on the sheet. Hannah decides to reprint the sheet. In this scenario, Hannah should use the _____ to split the Excel sheet into logical segments.

In the accompanying image of Microsoft Excel 2016, box A points to the _____.

In the accompanying nested function, which of the following functions will be executed first? =IF(D4>((SUM(E4:E10))/7)*100,"True")

In the accompanying image of Microsoft Excel 2016, box A points to the _____.

For Flash Fill to suggest content, you need to:

In a new worksheet, the page margins are set to 0.3 inches on the left and right and 0.5 inches on the top and bottom with 0.6-inch margins around the page header and footer.

Which of the following statements is true of the IF function in Excel?

Steve enters the equation "=2*(16 − 4)/10+23" in a cell in Microsoft Excel. The operation within parenthesis indicates that:

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

Working With Formulas and Functions

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 15: Creating an Advanced Workbook

A text argument can be included in an IF function by enclosing it in quotation marks. ​

Which of the following statements is true of hiding rows and columns in an Excel sheet? ​

The region of an active Microsoft Excel sheet that is sent to the printer is known as the _________. A)print space B)print preview C)print area D)print domain

​ In the accompanying image of Microsoft Excel 2016, box A points to the _____.

In the accompanying nested function, which of the following functions will be executed first? =IF(D4>((SUM(E4:E10))/7)*100,"True") ​

In the accompanying image of Microsoft Excel 2016, box A points to the _____.

For Flash Fill to suggest content, you need to: ​

In a new worksheet, the page margins are set to 0.3 inches on the left and right and 0.5 inches on the top and bottom with 0.6-inch margins around the page header and footer. ​

Which of the following statements is true of the IF function in Excel?

Steve enters the equation "=2*(16 − 4)/10+23" in a cell in Microsoft Excel. The operation within parenthesis indicates that:

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

Working With Formulas and Functions

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

A text argument can be included in an IF function by enclosing it in quotation marks.

Which of the following statements is true of hiding rows and columns in an Excel sheet?

In the accompanying image of Microsoft Excel 2016, box A points to the _____.

In the accompanying nested function, which of the following functions will be executed first? =IF(D4>((SUM(E4:E10))/7)*100,"True")

For Flash Fill to suggest content, you need to:

In a new worksheet, the page margins are set to 0.3 inches on the left and right and 0.5 inches on the top and bottom with 0.6-inch margins around the page header and footer.