Exam 2: Excel 2019

Which of the following conditional formatting types can you apply to use red fill to indicate cells that have higher values and green fill to indicate lower values?

Which of the following lets you search for a function or select one from a category?

To enter a typed number into a cell, you can press Tab or Backspace.

Which dialog box do you use to change the user name?

A Sunburst chart is a type of scatter chart.

Musa wants to customize the fonts he uses in a workbook. He can change the heading font and the _____ font.

You can change the caption of a Check Box form control, but not its internal name.

When you select a cell range, the cells must be adjacent to each other.

Reggie created a data validation rule for cell B3, which contains a unit price. He wants to use the only the data validation in cell D3. Which of the following should he do?

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

When you switch rows and columns in a chart, Excel updates the legend at the same time.

Which of these is the default layout for a newly created Pivot table?

Miguel wants to remove the outline from a worksheet containing grouped data. What does he need to do?

Which of the following functions can you use to display the middle characters in specified text?

After creating a table, you can add preset formatting combinations of fill color, borders, type style, and type color by apply a table format .

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

What is the correct formula to insert the date January 12, 1998 into a cell?

A one-input data table shows the result of varying one input value.

Sven wants to use a more vivid color as the Accent 1 color in his workbook's theme. What can he do to change the Accent 1 color?

Which of the following Solver constraints should you delete if the range A5:F5 must contain exact dollar amounts such as $500.25?