Exam 6: Excell: Working With Multiple Worksheets and Workbooks

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.

Which of the following format codes insures that Excel will display a decimal point in the number?

Critical Thinking Questions Case 5-1 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 ____________________ format code displays the characters in the cell in the designated color.

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

Each format ____________________ within the format code shown in the accompanying figure has special meaning.

If added, a footer appears at the bottom of every printed worksheet page.

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

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

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

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

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

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

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

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

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

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

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.

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.