Exam 2: Excel 2019

A(n) _____ groups and summarizes data in a concise format of rows and columns.

You cannot add totals to an Excel table because the table structure of fields and records must be preserved.

To insert defined names in existing formulas, you use the Create Names command on the Formulas tab.

Xan wants to change the number format in a PivotTable and its PivotChart. To do so, she can use the Number Format button in the Value Field Settings dialog box.

A _____ is a named operation that replaces the action of an arithmetic expression.

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

When you are using a workbook and want to open another one, you can display Backstage view and then click Open.

Because Solver is a(n) add-in , you must activate it before you an use it.

To count only records that match a filter criteria, you use the SUBTOTAL function.

A PivotTable Expanded layout expands fields into an outline of separate columns and displays subtotal rows at the top of each group.

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Which of the following functions inserts the total of a range?

Lucinda wants to apply conditional formats to three worksheets that have the same structure. She can apply the conditional formats to the three worksheets at the same time by grouping the worksheets.

When you click the File tab and then click Print, which of the following elements appears in the preview of the worksheet printout?

Which of the following is the temporary storage area that holds selections you copy or cut?

The PivotTable Fields pane lists the fields available to the PivotTable.

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

In Solver, a(n) _____ is a condition that limits the solution to a set of possible values.

Brielle wants to increase the size of a SmartArt graphic in her worksheet. To do so, she clicks the following series: Shape > Format tab > SmartArt tools . What should she do next to resize the object proportionally?

Gina is working with a query that includes an Income field and a Month field. She wants the query to return the total income for each month. She can sort the query by the values in the Month column and then create a column that sums the Income field.