Exam 2: Excel-2019

Horatio wants to hide field headers in a PivotTable. He clicks the PivotTable, then clicks the PivotTable Tools Analyze tab on the ribbon. What should he do next to complete the procedure?

(Multiple Choice)

4.9/5

(38)

Question 481

You can repeatedly paste an item from the Office Clipboard as many times as you like.

(True/False)

5.0/5

(34)

Question 482

Which of the following is a correction you can apply to a picture?

(Multiple Choice)

4.9/5

(38)

Question 483

Where can you display a list of all the macros in the current workbook.

(Multiple Choice)

4.8/5

(33)

Question 484

Lucinda's small business earned $15,000 in profit in August. She wants to calculate the profit she will earn in 12 months if profit grows by 1.5% each month. Which of the following can she do to make the calculation?

(Multiple Choice)

4.7/5

(45)

Question 485

As you edit a worksheet, you can use the _____ to see how changes to cells affect selected worksheet formulas.

(Multiple Choice)

4.9/5

(39)

Question 486

If a PivotTable contains more than one field in the Columns area, you can drill down in the data to display the details for those fields.

(True/False)

4.7/5

(38)

Question 487

The default worksheet text is _____-point Calibri.

(Multiple Choice)

4.8/5

(42)

Question 488

Which of the following lets you fill a cell with only specific elements of a copied cell?

(Multiple Choice)

4.9/5

(33)

Question 489

A _____ is a preset combination of fill color, borders, and font color.

(Multiple Choice)

4.9/5

(45)

Question 490

To format a range so that all values greater than $500 appear in red, which of the following can you use?

(Multiple Choice)

4.9/5

(42)

Question 491

Adding a table to the data model is also called adding a _____.

(Multiple Choice)

4.9/5

(40)

Question 492

Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?

(Multiple Choice)

4.8/5

(36)

Question 493

Before you can track changes in a workbook, what can you do to use the Track changes (legacy) feature?

(Multiple Choice)

4.9/5

(40)

Question 494

What happens when you drag a corner handle on SmartArt?

(Multiple Choice)

4.7/5

(40)

Question 495

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

(Multiple Choice)

4.7/5

(40)

Question 496

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

(Multiple Choice)

4.9/5

(25)

Question 497

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

(True/False)

4.8/5

(41)

Question 498

You can change the color of a data series by selecting the series and then clicking the _____ button.

(Multiple Choice)

4.9/5

(37)

Question 499

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

(Multiple Choice)

4.9/5

(28)

Question 500

Showing 481 - 500 of 580

Horatio wants to hide field headers in a PivotTable. He clicks the PivotTable, then clicks the PivotTable Tools Analyze tab on the ribbon. What should he do next to complete the procedure?

You can repeatedly paste an item from the Office Clipboard as many times as you like.

Which of the following is a correction you can apply to a picture?

Where can you display a list of all the macros in the current workbook.

Lucinda's small business earned $15,000 in profit in August. She wants to calculate the profit she will earn in 12 months if profit grows by 1.5% each month. Which of the following can she do to make the calculation?

As you edit a worksheet, you can use the _____ to see how changes to cells affect selected worksheet formulas.

If a PivotTable contains more than one field in the Columns area, you can drill down in the data to display the details for those fields.

The default worksheet text is _____-point Calibri.

Which of the following lets you fill a cell with only specific elements of a copied cell?

A _____ is a preset combination of fill color, borders, and font color.

To format a range so that all values greater than $500 appear in red, which of the following can you use?

Adding a table to the data model is also called adding a _____.

Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?

Before you can track changes in a workbook, what can you do to use the Track changes (legacy) feature?

What happens when you drag a corner handle on SmartArt?

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

You can change the color of a data series by selecting the series and then clicking the _____ button.

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters