Exam 2: Excel 2019

To display a preview of a table style applied to the selected table, point to a style in the Table Styles gallery.

It is possible to go to the next comment using the Next button in the Comments group on the Review tab.

To calculate the cumulative total of payments made toward the principal of a loan, you use the _____ function.

Which of the following elements can you add to a chart to display a line representing the general direction in a data series?

The first PivotTable created in a workbook is named PivotTableNew .

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

When you split a worksheet pane, its contents are always visible, though you cannot scroll in the pane.

A(n) _____ is a range of data Excel treats as a single object that can be managed independently from other data in the workbook.

If a PivotTable field is expanded, you can click the minus button to collapse the field and hide field details.

Which of the following can help you quickly format a cell range with labels in the left column and top row, and totals in the bottom row?

Which of the following indicates the column and row where a cell is located?

What must you do to have a filter button appear in the upper-left corner of a PivotTable?

Where can you rename a data query?

How can you edit a macro to change its actions?

A teacher creates a table for Sports Day events. The table includes columns for Event, Rank, First Name, and Last Name. To find the top-ranking participants for each event, the teacher can sort the table first by Event and then by Rank.

To go to a previous comment, use the Previous button in the Comments group on the Review tab.

Because of their compact size, you cannot apply a style to a sparkline.

If a worksheet arranges lookup values in rows rather than columns, which function is best for retrieving data from the lookup table?

Jin wants to insert a recommended PivotTable. After clicking a cell in a data range, what should he select?

The three PivotTable layouts differ in how they arrange fields in the Rows area and where they display _____.