Many business applications require data from several worksheets to be summarized on one worksheet.

The process of summarizing data included on multiple worksheets on one worksheet is called linking.

One efficient way to create the workbook is first to create a template, save the template, and then copy the template to a workbook as many times as necessary.

Templates help speed and simplify work because Excel users often work with very different problems.

Excel allows you to print page numbers and the sheet name of each sheet.

Templates cannot contain macros or formulas.

Data placeholders are helpful to users of templates.

A brace is a rectangular area of variable size in which you can add text.

When Excel is first installed on a computer, it places commonly used shapes in the Recently Used Shapes area in the Shapes gallery.

In the accompanying figure, the width of columns C, D, E, F, and G could have been made wider all at once by selecting them as a range and dragging the left boundary of column G to the desired width.

In the accompanying figure, you could enter the date in cell G3 by using the NOW function.

In the accompanying figure, dummy data (sample data) is used in place of actual data to verify the formulas in the template.

In the accompanying figure, column C shows a growth series.

In the accompanying figure, column B shows a linear series.

In the accompanying figure, to center the title in range A1:G1, use the Merge & Center button on the Ribbon.

The process of summarizing data included on multiple worksheets on one worksheet is called ____.

A workbook that contains patterns for creating other workbooks is called a(n) ____.

The function =NOW()+14 does what?

The ____ function is most useful in formulas where year, month, and day are formulas, not constants.

The result of an arithmetic operation, such as multiplication or division, is ____ to the factor with the least number of decimal places.

To change from Enter mode or Edit mode to Point mode, start by ____.

Saving a template is just like saving a workbook, except that the file type ____ is selected in the Save as type box in the Save As dialog box.

A function that sums all the values in all the cells in column A is ____.

A format code is a series of ____ that defines how a cell entry assigned a format will appear.

A style is a group of format specifications that ____.

The Normal format style is ____.

How many worksheets are in a new workbook if you do not set a default?

What is the maximum number of worksheets that a workbook can have?

Entering a number once and having it be entered in the same cell on all worksheets is called ____.

How can a page break be moved?

If you create a worksheet for someone who does not have Excel, save the worksheet as a(n) ____ file.

A single character, word, or phrase is referred to as a(n) ____.

Match case means that the search ____ and the cell contents must match the word exactly the way it is typed.

What happens if Excel does not find the information in the search?

What happens if Excel replaces a text string?

A workspace file ____.

Excel will update links automatically if ____.

The accompanying figure shows a ____.

In the accompanying figure, the Format Cells dialog box was used for cells D12:G12 to assign a category named ____.

In the accompanying figure, the template is using standard accounting format for the numbers, which means____.