Exam 2: Excel 2019

Ricki wants to apply a particular chart style to a PivotChart she has created. Which of these tabs will help her apply it?

To search for a picture in the Online Pictures dialog box, you enter a format related to your subject of interest .

When you record a macro, Excel stores it as a VBA module attached to the workbook.

Caleb created a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts?

To change the color of cell content, you use the ________ color list arrow.

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

To remove duplicate values from an Excel worksheet, click the Remove Duplicates button in the Data Tools group on the Data tab.

Which of the following form controls provides a way for users to enter data?

To see how copied contents will look with both values and number formatting, you would use Paste Numbers .

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

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?

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time. Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control) into a worksheet?

Isaac formatted a worksheet so that all the cells with data or formulas have blue borders. He also wants a picture he inserted to fit the worksheet design. Which of the following should he do?

Which of the following is the temporary storage area that holds selections you copy or cut?

You can move the PivotTable Fields pane, but you cannot hide it.

When you sort a table on the Department and then the Last Name columns, Excel first sorts the records by Department, and then sorts by Last Name within each Department.

To use the Track Changes feature, you can add the Track Changes button to the ribbon using the Track changes (Legacy) command.

A(n) _____ is a specially formatted word, phrase, or graphic that, when clicked, displays a webpage.