Exam 2: Excel 2019

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file. To do so, she can click File > Info > Protect (Document, Presentation, or Workbook) > Protect Current Sheet > OK.

(True/False)

4.8/5

(36)

Question 181

Bree added data labels to a pie chart, where they appear on each slice. She wants the data labels to appear outside of the pie chart but close to each slice. Which Label Position option should she select for the data labels?

(Multiple Choice)

4.7/5

(35)

Question 182

Adele wants to filter a Customers table to show customers in Denver or customers with invoices over $2500. What type of filter should she use?

(Multiple Choice)

4.8/5

(41)

Question 183

Gwen wants to locate cells that contain the date 11/14/21. Which of the following tools should she use?

(Multiple Choice)

4.9/5

(41)

Question 184

When you create a calculated item for a field in a PivotTable, it appears as a new item within the field.

(True/False)

4.7/5

(22)

Question 185

Which of the following Excel features finds a numeric solution to a problem involving several input values?

(Multiple Choice)

4.8/5

(37)

Question 186

To change the background color of a cell, you use the Background color button.

(True/False)

4.8/5

(36)

Question 187

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12. When he presses ENTER, 23/08/2012 will appear in B12.

(True/False)

4.7/5

(42)

Question 188

A good practice is to move the most important worksheets to the end of the workbook.

(True/False)

4.8/5

(35)

Question 189

When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change?

(Multiple Choice)

4.9/5

(25)

Question 190

To display a tracer arrow to each cell providing direct data to the active cell, click Formulas tab > Formula Auditing group > Trace Precedents.

(True/False)

4.9/5

(31)

Question 191

A _____ is text or an image you click to open a webpage or file.

(Multiple Choice)

4.9/5

(43)

Question 192

Which of the following is a type of logical function?

(Multiple Choice)

5.0/5

(33)

Question 193

How can you hide the filter buttons in a table?

(Multiple Choice)

4.7/5

(30)

Question 194

Currency is an example of a number format.

(True/False)

4.8/5

(28)

Question 195

If you want to print only part of a worksheet, you can set a _____.

(Multiple Choice)

5.0/5

(34)

Question 196

To move a worksheet, you can drag its sheet tab to the left or right.

(True/False)

5.0/5

(45)

Question 197

Which of the following tabs lets you set worksheet print options?

(Multiple Choice)

4.8/5

(35)

Question 198

A(n) _____ is descriptive text that appears next to a chart's horizontal or vertical axis.

(Multiple Choice)

4.9/5

(35)

Question 199

Allison wants to sort the Reservation data in a PivotTable by days of the week, Sunday through Monday. What does Allison need to create?

(Multiple Choice)

4.8/5

(28)

Question 200

Showing 181 - 200 of 503

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file. To do so, she can click File > Info > Protect (Document, Presentation, or Workbook) > Protect Current Sheet > OK.

Bree added data labels to a pie chart, where they appear on each slice. She wants the data labels to appear outside of the pie chart but close to each slice. Which Label Position option should she select for the data labels?

Adele wants to filter a Customers table to show customers in Denver or customers with invoices over $2500. What type of filter should she use?

Gwen wants to locate cells that contain the date 11/14/21. Which of the following tools should she use?

When you create a calculated item for a field in a PivotTable, it appears as a new item within the field.

Which of the following Excel features finds a numeric solution to a problem involving several input values?

To change the background color of a cell, you use the Background color button.

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12. When he presses ENTER, 23/08/2012 will appear in B12.

A good practice is to move the most important worksheets to the end of the workbook.

When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change?

To display a tracer arrow to each cell providing direct data to the active cell, click Formulas tab > Formula Auditing group > Trace Precedents.

A _____ is text or an image you click to open a webpage or file.

Which of the following is a type of logical function?

How can you hide the filter buttons in a table?

Currency is an example of a number format.

If you want to print only part of a worksheet, you can set a _____.

To move a worksheet, you can drag its sheet tab to the left or right.

Which of the following tabs lets you set worksheet print options?

A(n) _____ is descriptive text that appears next to a chart's horizontal or vertical axis.

Allison wants to sort the Reservation data in a PivotTable by days of the week, Sunday through Monday. What does Allison need to create?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters