Exam 5: Working With Multiple Worksheets and Workbooks

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keyboard shortcut to paste the contents and format of source area.

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area for numbers or formulas,but use the format of the destination area for text.

Which of the following are true about the ROUND function?

The path to the Comma Style button is ____.

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

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

A(n)____ reference is a formula that depends on its own value.

Which of the following is the path to the Fill button?

The following sequence,1,1,1,etc.,is an example of a(n)____ series.

When you use the SUM function,Excel assumes that all contiguous numbers should be summed.

Once you have selected a range to chart,you can press ____ to draw a chart on a worksheet.

Always take the time to select ____________________ data that tests the limits of the formulas.

Which of the following is the path to the Insert Cells button?

A(n)____________________ is a series of format symbols that defines how a cell entry assigned a format will appear.

You can enter formulas that reference cells on other worksheets in the workbook.

A code is a group of format specifications that are assigned a name.

The code ____ instructs Excel to insert the page number in the header or footer section.

To select adjacent sheets,select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

Which of the following is the path to the Switch Windows button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Linked workbooks.