Exam 2: Excel 2019

Stella wants to merge two workbooks. She begins by opening the workbooks, then selects the worksheets she wants to copy by clicking on the first sheet tab that she wants to copy, pressing and holding the Shift key, and then clicking on the last sheet tab. Then she right-clicks on one of the selected tabs and selects an option from the menu. Which of the following can her selection be?

Steffie needs a wider left margin in her worksheet. Which of the following can she do to change the margin?

Which of the following statements is true about COUNT functions?

A combination chart combines two chart types and can plot data on primary and secondary axes.

To remove a field from a PivotTable, clear its check box in the field list.

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

In the Expenses workbook, Cassie defined the range D10:G10 with the name RentExpenses. Which of the following formulas can replace the formula =SUM(Expenses!D10:G10)?

Which of the following is the default function Excel uses to summarize non-numeric data in a PivotTable?

One can create a one-variable data table in Excel to test a series of values for a single input cell and see the influence of these values on the result of a related formula.

When you save a workbook as a template, which of the following file name extensions does Excel apply?

You can use the Query Properties dialog box to have Excel automatically refresh data in a query.

A _______ refers to a collection of characters with a similar, specific design.

You should move a chart to a chart sheet when you want the source data to appear with the chart.

Louis has entered a column of expense values. What feature can he use to insert the total expenses at the end of the column?

After Eddie adds three fields to the Rows area of a PivotTable, he can use the open and collapse buttons to drill up and down the data.

Before Barry inserts new formulas in the range A5:F5, he wants to clear the cell contents. How can he do so?

When you arrange windows in a Vertical or Side by Side layout, you can use synchronized _____ to more easily compare the two worksheets.

A one-variable data table performs several what-if analyses by specifying one changing cell and several result cells.

What happens when you click a link to a Word document while working in Excel?

One way of creating a PivotTable group in a date field is through a custom group, where you select items in the field to create a new group, such as the September to December items to create a Semester group.