Question 1

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

Accepted Answer

A)  auto fill 
B)  date 
C)  linear 
D)  growth 
A)  auto fill 
B)  date 
C)  linear 
D)  growth C

Question 2

When tiling windows vertically the windows appear as wide as possible.

Accepted Answer

A) True 
 B)False  False

Question 3

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.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

Excel provides three basic choices when

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Keyboard shortcut to copy the contents and formatting of a source area but not the formula.

Accepted Answer

A) dependent workbook 
B) CTRL+U 
C) drilling an entry 
D) consolidation 
E) circular reference
F)CTRL+P
G)source workbooks
H)header
I)drag page break
J)CTRL+E 
A) dependent workbook 
B) CTRL+U 
C) drilling an entry 
D) consolidation 
E) circular reference
F)CTRL+P
G)source workbooks
H)header
I)drag page break
J)CTRL+E

Question 6

Before printing a workbook, consider the ____________________, which defines the appearance and format of a printed worksheet.

Accepted Answer

The answer of Before printing a workbook, consider the ____________________,...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 _____.

Accepted Answer

A)  a style is a group of format specifications that are assigned a name; he can view styles in the Cell Styles gallery and then click a style to apply it to the selected cell or range 
B)  styles are effective when used to format a word-processing document but cannot be used to format a worksheet 
C)  a style is just another name for a set of formatting codes; a style must be customized to be useful 
D)  using a style will allow him to apply multiple formats at one time to an active cell if it contains text; unfortunately, styles cannot be used to format numbers or calculated values 
A)  a style is a group of format specifications that are assigned a name; he can view styles in the Cell Styles gallery and then click a style to apply it to the selected cell or range 
B)  styles are effective when used to format a word-processing document but cannot be used to format a worksheet 
C)  a style is just another name for a set of formatting codes; a style must be customized to be useful 
D)  using a style will allow him to apply multiple formats at one time to an active cell if it contains text; unfortunately, styles cannot be used to format numbers or calculated values

Question 9

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

Accepted Answer

The answer of You can click the ____________________ tabs at...

Question 10

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.

Accepted Answer

A) dependent workbook 
B) CTRL+U 
C) drilling an entry 
D) consolidation 
E) circular reference
F)CTRL+P
G)source workbooks
H)header
I)drag page break
J)CTRL+E 
A) dependent workbook 
B) CTRL+U 
C) drilling an entry 
D) consolidation 
E) circular reference
F)CTRL+P
G)source workbooks
H)header
I)drag page break
J)CTRL+E

Question 11

A workbook contains ____ worksheet(s) by default.

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four 
A)  one 
B)  two 
C)  three 
D)  four

Question 12

If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

Accepted Answer

A) True 
 B)False

Question 13

A range that spans two or more worksheets in a workbook is called a ____ range.

Accepted Answer

A)  1-D 
B)  2-D 
C)  3-D 
D)  4-D 
A)  1-D 
B)  2-D 
C)  3-D 
D)  4-D

Question 14

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

Accepted Answer

The answer of A sheet reference in a formula, such...

Question 15

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

Accepted Answer

A) True 
 B)False

Question 16

When you insert a manual page break, Excel displays a(n) ____ line between pages.

Accepted Answer

A)  solid 
B)  orange 
C)  red 
D)  dotted 
A)  solid 
B)  orange 
C)  red 
D)  dotted

Question 17

You should hold down the ____ key to select the nonadjacent cells.

Accepted Answer

A)  SHIFT 
B)  CTRL 
C)  TAB 
D)  END 
A)  SHIFT 
B)  CTRL 
C)  TAB 
D)  END

Question 18

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

Accepted Answer

A)  linear 
B)  growth 
C)  fill 
D)  date 
A)  linear 
B)  growth 
C)  fill 
D)  date

Question 19

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

Accepted Answer

A) dependent workbook 
B) CTRL+U 
C) drilling an entry 
D) consolidation 
E) circular reference
F)CTRL+P
G)source workbooks
H)header
I)drag page break
J)CTRL+E 
A) dependent workbook 
B) CTRL+U 
C) drilling an entry 
D) consolidation 
E) circular reference
F)CTRL+P
G)source workbooks
H)header
I)drag page break
J)CTRL+E

Question 20

Which of the following format symbols displays text along with numbers entered in a cell?

Accepted Answer

A)  _ (underscore) 
B)  0 (zero) 
C)  " " (quotation marks) 
D)  # (number sign) 
A)  _ (underscore) 
B)  0 (zero) 
C)  " " (quotation marks) 
D)  # (number sign)

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

When tiling windows vertically the windows appear as wide as possible.

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.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keyboard shortcut to copy the contents and formatting of a source area but not the formula.

Before printing a workbook, consider the ____________________, which defines the appearance and format of a printed worksheet.

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

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

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.

A workbook contains ____ worksheet(s) by default.

If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

A range that spans two or more worksheets in a workbook is called a ____ range.

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

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

When you insert a manual page break, Excel displays a(n) ____ line between pages.

You should hold down the ____ key to select the nonadjacent cells.

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

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

Which of the following format symbols displays text along with numbers entered in a cell?

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

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

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

When tiling windows vertically the windows appear as wide as possible.

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.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keyboard shortcut to copy the contents and formatting of a source area but not the formula.

Before printing a workbook, consider the ____________________, which defines the appearance and format of a printed worksheet.

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

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

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.

A workbook contains ____ worksheet(s) by default.

If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

A range that spans two or more worksheets in a workbook is called a ____ range.

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

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

When you insert a manual page break, Excel displays a(n) ____ line between pages.

You should hold down the ____ key to select the nonadjacent cells.

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

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

Which of the following format symbols displays text along with numbers entered in a cell?

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters