Exam 2: Excel 2019

When you group data to create a(n) custom view , you can create groups of columns or rows.

Kylie has a table with a Skill Number column that contains values from 400 to 500. What type of filter can she use to select records with skill numbers less than 450?

A worksheet named Income (2) is most likely which of the following?

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

To rename a worksheet, you change the text on the _____.

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

Which of the following functions inserts the total of a range?

Which category do you select in the Excel Options dialog box to add the Power Pivot tab to the ribbon?

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

You can click the Field List button to show or hide the PivotTable Fields pane.

Which of the following can you insert in a SmartArt shape?

The Comma Style format adds a comma and a dollar sign to a cell value.

Bertie wants to show data labels inside a text bubble shape. Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?

How can you create a single PivotTable to analyze data from two tables?

To change the number format of a Value field in a PivotTable from General to Currency, you change the number format in the data source.

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

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

Ina wants to protect a worksheet with a password, but still provide a data entry area where users can change data. Before protecting the worksheet, she should unlock the cells she wants to allow users to edit.

To combine the results of four separate scenarios, you create an Answer report.

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.