Exam 7: Excel

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

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?

A _____ between tables in the data model lets you access data from both tables.

You can change a table back to a range by clicking the Change to Range button on the Table Tools Design tab.

A _____ is a graphic object you can use to filter data in a PivotTable.

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

To retrieve data values from a comma-separated values (CSV) file, you use the From Text/CSV button in the Get & Transform group on the Data tab.

Which of the following views shows how a worksheet will appear when printed?

Which of the following can you insert in a SmartArt shape?

You can open the Visual Basic Editor by clicking the Visual Basic button in the Code group on the Developer tab.

Eric wants to rearrange the legend, title, gridlines, and other elements in a bar chart.Which of the following tools can he use to change many chart elements at the same time?

Which of the following will you select as X in the series of clicks to clear data validation circles in a worksheet: Data tab > Data Tools group > Arrow next to X > Clear Validation Circles?

If a PivotTable contains more than one field in the Columns area, you can drill down in the data to display the details for those fields.

Banded Rows applies banding to table rows to fill alternating rows with color.

When you group worksheet data, you can use the Hide Outline button to hide details in grouped columns or rows.

If you add the Month field to the Filters area of a PivotTable, Excel filters the PivotTable to show data only for January.

To change the starting and ending values on a chart axis, use the _____ pane.

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.

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

To print worksheet contents across the length of a page, you can use portrait orientation.