Exam 2: Excel 2019

If the answer to a what-if question requires data from two tables, you can use Power Pivot to create a PivotTable that uses fields from both tables.

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

When you click the View Side by Side button, you activate the Synchronous Scrolling button so you can scroll both worksheets at the same time.

Henry imported text data, which appeared in all lowercase. To convert text such as "order date" to "Order Date," he can use the TEXTJOIN function.

Fred created a template named Revenue.xltx. What is the name of the that opens when he double-clicks Revenue.xltx for the first time?

Ariana wants to compare data on different worksheets in a workbook named Financials. Which of the following buttons can she use on the View tab to open an instance of the Financials workbook?

When you remove duplicate records from a table, Excel can examine only one column for duplicate data.

To import data from an Access table into Excel, you use the _____ tool.

In the formula =SUM('San Francisco'!A6:D6), the exclamation point is a(n) linked reference indicator.

If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

The COUNTIF function counts blank cells.

To retrieve summary data from a PivotTable, you need to use the PIVOTSUM function.

You can use an XML map to import and export PDF data, a format often used for storing and exchanging data.

To accept a suggested spelling for that instance only, which of the following would you click?

In a PivotTable, the Row Labels appear above the PivotTable values.

To show a comment attached to the active cell, move the pointer over the cell.

To apply a cell style, you would use the Cell Styles command on the _____ tab.

You can insert two types of controls in a worksheet: VBA controls and ActiveX controls.

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

Applying a layout to a PivotChart using the Quick Layout button does not affect the layout of the corresponding PivotTable.