Exam 2: Excel 2019

One can use Get & Transform (Power Query) feature of Excel to create a dynamic connection to an existing Excel table and refresh the connection when the data in table changes.

You double-click the Format Painter button when you want to _____.

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

Colin wants to apply a Quick Style to a SmartArt graphic. To do so, he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice. Which of these can X be in the following series of clicks?

If you are working with scenarios on one worksheet, you can merge scenarios from other worksheets or workbooks.

To illustrate different data levels using small graphics representing values, which of the following can you use?

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells?

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

When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell.

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

Because loading data from a query creates a snapshot of the data, you need to _____ the connection if the values in the data source change.

To select a single worksheet cell so you can work with it, which of the following would you do?

The _____ function returns the value from a range of data at the intersection of a specified row and column.

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Which of the following lets you extend any data pattern involving dates, times, numbers, or text?

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

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?

You can edit cell contents in the formula bar or in the cell itself.