Exam 2: Excel 2019

What must you change to customize the background color of a Command Button (ActiveX Control)?

A Scatter chart shows positive values in green and negative values in red.

To make the appearance of sparklines consistent with other parts of a worksheet, you can change their layout.

Sophia has a table with a column named Sales that lists monthly sales data. To sort the column, she can click the Sales filter list arrow and then click Number.

To print worksheet contents across the length of a page, you can use portrait orientation.

To change the actions in a recorded macro, you can open the macro in the Visual Basic Editor.

Jin wants to review types of PivotTables that suit her selected data. Which feature should she use to do so?

Jenny inserted two types of SmartArt in a worksheet and wants to make them look more similar. Which of the following can she do?

To format a range so that all values greater than $500 appear in red, which of the following can you use?

Lucinda's small business earned $15,000 in profit in August. She wants to calculate the profit she will earn in 12 months if profit grows by 1.5% each month. Which of the following can she do to make the calculation?

To move a chart to another location on the same worksheet, drag it to the location you want.

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

After adding data validation criteria to a worksheet, which of the following features can you use to locate data that doesn't satisfy the criteria?

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

With a _____, you can emphasize one data point by exploding it.

To document a workbook, you can use _____, notes you add to worksheet cells.

Which of the following is a way to make a table accessible?

Jeremy created a worksheet with a Departments column and an Expenses column. To average the expense amounts for the Customer Service Department only, he can use the AVERAGE function.

You can change a table to a worksheet range by click the Change to Range button.

A trendline is a small, simple chart in a worksheet cell that shows trends of data in nearby cells.