Exam 2: Excel-2019

When you want to know the position of an item in a range, you can use the LOOKUP function.

Which of the following chart types shows the distribution of data grouped in bins?

Where can you see a brief description of a selected function?

A threaded comment is one that remains attached to a cell even if you move the cell.

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.

Banded Rows applies banding to table rows to fill alternating rows with color.

A(n) _____ is a section of columns or rows that you can freeze and unfreeze.

If you turn on the Track Changes legacy feature, it can keep track of editing changes made in a workbook.

When you right-click a cell containing a hyperlink, which of the following commands should you select to remove cell contents along with the hyperlink?

To check your workbook for features that assist people with disabilities, you can use the Ability Checker.

Excel provides a tool for tracing formula operators.

If you add the Month field to the Filters area of a PivotTable, Excel filters the PivotTable to show data only for January.

After you circle invalid data on a worksheet, the circles remain in place until you correct the circle values.

You can create conditional cell formats using either the Home tab or the _____.

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

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.

How can you align all objects to the upper-left corner of a cell?

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command.

You can use the Update Links button on the Data tab to manage links in an Excel workbook.

Which of the following Excel features applies a design using theme colors to a table?