Exam 5: Working With Multiple Worksheets and Workbooks

When should you use the ROUND function?

As you link workbooks,the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n)____ cell reference.

When you consider how to organize your data in a workbook,use multiple worksheets when the data is tightly related.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A workbook that automatically reads data from linked workbooks.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Enter a number once and copy it through worksheets.

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

How do you determine how many worksheets to add to a workbook?

You should create good ____ to ensure your workbooks are free of errors.

You can drill all of the following down through a workbook EXCEPT ____.

Among the Paste Gallery commands,the ____________________ option will copy the contents and format of a source area but not any borders.

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

Judy, an administrative assistant to the sales manager, sends you an e-mail requesting some help on a current project. The sales manager has created three separate workbooks in which she stores sales data. Judy needs to create a new workbook with worksheets that summarize the data from the three workbooks; she asks if there is any way to summarize the data in the three workbooks without spending hours to do it manually. -Judy sends you another e-mail thanking you for your tip and asks if there is any quick way that she can copy the format of a given source area but not its contents.You tell Judy to use the ____ keyboard shortcut.

The standard accounting format for a table or numbers contains floating dollar signs in the first row of numbers.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The process of summarizing data included on multiple worksheets on one worksheet.

You can display the ____ tab to specify page setup options.

You can create and then assign a style to a cell,a range of cells,a worksheet,or a workbook.

The ____ keyboard shortcut copies an image of the source area as a picture.

An organization may keep data from various departments or regions in different worksheets in the same workbook._________________________

When a series of @@@@@@ signs or symbols appears in a cell that should contain a date,the formatted date does not fit in the width of the cell._________________________

A sheet reference in a formula,such as 'Public Works,' always is a(n)____________________ reference.