Exam 5: Working With Multiple Worksheets and Workbooks

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area but swap the rows and columns.

The path to the Sum button is ____.

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

As you develop more sophisticated workbooks,it will become increasingly important that you create good test data to ensure your workbooks are free of errors.

To reference cells in other sheets in a workbook when creating a formula,include the worksheet name rather than the cell reference.

If multiple sheets are selected and you want to select the active sheet,if you are using a mouse,hold down the CTRL key and then click the sheet tab of the active sheet._________________________

An alternative to adding worksheets to a workbook is to change the ____________________ number of worksheets before you open a new workbook.

If you are summing numbers on noncontiguous sheets,hold down the SHIFT key rather than the CTRL key when selecting the sheets.

A ____ is a reference to a cell or range of cells in another workbook.

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

When tiling windows vertically the windows appear as wide as possible._________________________

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

When you print a worksheet or use the Page Setup dialog box,Excel inserts ____ breaks that show the boundaries of what will print on each page.

If you change the Normal style,Excel applies the new format specifications to all cells,including those assigned other styles.

Louie is designing a complex worksheet and needs to format cells containing numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. -Louie calls back with another formatting question.Another coworker suggested that he use styles to format cells in his worksheet,but he is unfamiliar with styles.You tell Louie that _____.

The ____________________ option is the Paste Gallery command that allows you to copy the contents of the source area but not the formatting for formulas.

____ format codes allow you to specify how a cell entry assigned a format will appear.

To select nonadjacent sheets,select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

Louie is designing a complex worksheet and needs to format cells containing numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. -You suggest to Louie that he ____.