Exam 2: Excel-2019

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?

You can add a legend to sparklines to indicate the high and low points in the chart.

You can merge scenarios to apply scenarios from another worksheet into the current one.

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.

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

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

If you save an Excel workbook on OneDrive, _____ saves versions of your workbook as you make changes.

Which of the following is an effect you can apply to a picture?

Amanda wants to calculate formulas only when she saves or opens a workbook. Which of the following calculation options should she select?

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

What type of filter should you use when you want to display records that meet And conditions and Or conditions?

As you edit a worksheet, you can open the Watch window to watch the effect that cell changes have on selected worksheet formulas.

Richard retired recently and is receiving $400 per month from an investment at a rate of 7% for 20 years. Which of the following functions can he use to calculate the current value of the investment?

You can click the Field List button to show or hide the PivotTable Fields pane.

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

Nathan wants to analyze a range of values that shows the results of changing a single input value in a formula. What should he create?

Esperanza wants to save a series of commands she performs often. Which of the following should she do?

To filter a PivotTable to show expenses for only Chicago and Seattle in the City field, press _____ then click the Chicago and Seattle buttons in the City slicer.

Which of the following methods copies an existing worksheet within the same workbook?

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