Exam 7: Excel

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

When you click the View Side by Side button, you activate the Synchronous Scrolling button so you can scroll both worksheets at the same time.

Which of the following is not true about setting column width?

The _____ is displayed as the label for a Command Button (ActiveX Control).

Fred created a template named Revenue.xltx.What is the name of the that opens when he double-clicks Revenue.xltx for the first time?

You can click the Collapse button to drill up into a PivotTable.

A(n) _____ is a set of display or print settings that you can name and save, and then access later.

A threaded comment is one that remains attached to a cell even if you move the cell.

You can use Forecast Sheet to project future data based on past trends.

Lilia wants to save a workbook as a read-only file.She should encrypt the workbook with a password.

The Remove Duplicates tool locates and deletes records that are duplicated across more than one field.

How can you change the data displayed in the PivotTable?

Jada has a worksheet listing the first and last names of her students in a single column.Which Excel tool can she use to split the names into separate columns?

When you use a named range in a formula, it becomes a(n) _____ reference by default.

Smith created SmartArt that illustrates four steps in a process.How can he add a fifth step?

You double-click the Format Painter button when you want to _____.

A _____ is a preset combination of fill color, borders, and font color.

Han has four workbooks open, with one maximized on the desktop.Which button can he click on the View tab to display a different workbook?

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

The SUMIF function takes which of the following arguments? Select all the options that apply.