Exam 6: Financial Functions, Data Tables, and Amortization Schedules

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

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

You can enter a sheet reference in cell by typing it or by clicking the appropriate sheet tab while in ____________________ mode.

Case 5-2 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. -You tell Judy that ____.

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

Which of the following are true about the ROUND function?

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

Case 5-2 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 ____ keyboard shortcut copies an image of the source area as a picture.

The formula =sum(1:1) adds all the values in column A.

Using the following illustration, define the possible four sections of a format code. $*#,##0.00; [Magenta]#,##0.00; 0.00; "The answer is"@

If multiple sheets are selected and you want to select a sheet that is selected, but not active, tap or click the sheet tab you want to select.

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

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.

You can use the ENTER key to complete a paste operation.

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.

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.

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.

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