Exam 2: Excel 2019

Boris is displaying two instances of the same workbook and wants to remove one. Which button should he click on the View tab?

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

A field named Difference appears in the PivotTable Fields pane and in the PivotTable, where it displays the difference between the Year 1 and Year 2 fields. What type of field is Difference?

Lydia entered row titles in the range A1:A10 and listed data next to it in the range B1:B10. Which Excel feature can she use to apply the text in the range A1:10 as defined names for the cells in the range B1:B10?

Betty wants to display negative percentages in red text with parentheses. What type of number format should she apply?

Charlie created a pie chart that displays number values in data labels. How can he change the values to show dollar amounts?

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.

Objects you can insert into Excel workbooks from other apps include pictures, database objects, and text data.

Which of the following is true when you delete a cell?

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

Jerome inserted a Check Box form control and set cell A10 as the cell link. When a user clicks the check box to insert a checkmark, cell A10 will display SELECTED.

To move a worksheet, you can drag its sheet tab to the left or right.

In a chart, a data table displays the data series in rows and the category values in columns.

A chart is a type of table that is not located in a specific cell or range, letting you copy and move it without affecting formulas or data in the worksheet.

What type of chart is a Clustered Column - Line chart?

Jada has a worksheet listing the first and last names of her students in a single column. Which Excel tool can she use to split the names into separate columns?

By default, Excel records absolute cell references in macros.

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

When you create a scenario summary report, it is linked to the data so that if you change the data values, the report updates automatically.

You can copy and paste only the cell validation by copying a cell with data validation, right-clicking the destination cell, clicking Paste Special, then clicking the Rules button in the Paste Special dialog box.