Exam 2: Excel 2019

You can set a scaling option to resize a worksheet to fit within a single page.

Which of the following PivotTable layouts displays all fields in separate columns and subtotal rows at the bottom of each group, similar to a table?

Use the DGET function to count the numeric values in a column for cells that match the criteria.

To unprotect a worksheet, open the worksheet, click the Review tab, and then click the Unprotect Sheet button.

A(n} _____ combines items in a PivotTable field to create a new group, which appears as a new field in the PivotTable.

When you add fields to the Columns area of a PivotTable, they appear as headings at the top of the table.

After clicking the Get Data button on the Data tab, what do you select to import an Access database table into Excel?

Doug is using WordArt for a chart title that displays an outline of letters with shadows. To display filled letters with reflections, he can change the Transform effect.

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

To display the contents of a worksheet but not how it will look when printed, use Page Layout view.

Gabriel wants to see how changes to the sales price and number of units sold would affect his company's profit. Which of the following should he create?

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

What must you add to the Excel ribbon before you can insert a form control or create a macro?

To detect language automatically, you should select the Detect language automatically check box in the Language dialog box.

The PivotTable layouts different mainly in how they arrange fields in the Rows area and where they display grand totals.

Splitting the workbook window affects all the worksheets in the workbook.

To which of the following locations can you move a PivotChart?

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.