Question 1

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

Accepted Answer

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.

Accepted Answer

A)  Select Active Sheet 
B)  Ungroup Sheets 
C)  Quick Select 
D)  Disaggregate Sheets 
A)  Select Active Sheet 
B)  Ungroup Sheets 
C)  Quick Select 
D)  Disaggregate Sheets

Question 4

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

Accepted Answer

The answer of  
-Each format ____________________ within the format...

Question 5

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

Accepted Answer

Question 6

Headers, footers, and margins are all ____ options.

Accepted Answer

A)  validation 
B)  calculation 
C)  page setup 
D)  control 
A)  validation 
B)  calculation 
C)  page setup 
D)  control

Question 7

The ____________________ tab contains the commands for setting the location of page breaks or centering a printout horizontally and vertically.

Accepted Answer

The answer of The ____________________ tab contains the commands for...

Question 8

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

Accepted Answer

A)  Individual 
B)  Specific 
C)  Custom 
D)  Duplicate 
A)  Individual 
B)  Specific 
C)  Custom 
D)  Duplicate

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Keyboard shortcut to copy an image of the source area as a picture.

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 10

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

Accepted Answer

A) True 
 B)False

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Reposition page break in Page Break Preview.

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 12

Which of the following is a method of electronic document distribution?

Accepted Answer

A)  posting on SkyDrive 
B)  sharing an XPS image of a document 
C)  blog posting 
D)  posting on a social networking site 
E)  None of the above 
A)  posting on SkyDrive 
B)  sharing an XPS image of a document 
C)  blog posting 
D)  posting on a social networking site 
E)  None of the above

Question 13

The path to the Comma Style button is ____.

Accepted Answer

Question 14

Excel copies page setup characteristics when one sheet is copied to another.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

Question 16

You can drill all of the following down through a workbook EXCEPT ____.

Accepted Answer

A)  formats 
B)  numbers 
C)  formulas 
D)  groupings 
A)  formats 
B)  numbers 
C)  formulas 
D)  groupings

Question 17

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

Accepted Answer

A)  ALT+SHIFT+ASTERISK (*) 
B)  CTRL+SHIFT+ASTERISK (*) 
C)  TAB+SHIFT+ASTERISK (*) 
D)  SHIFT+HOME+ASTERISK (*) 
A)  ALT+SHIFT+ASTERISK (*) 
B)  CTRL+SHIFT+ASTERISK (*) 
C)  TAB+SHIFT+ASTERISK (*) 
D)  SHIFT+HOME+ASTERISK (*)

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  > 
B)  &[Page] 
C)  [PageNum] 
D)  (LoadPageNum) 
A)  > 
B)  &[Page] 
C)  [PageNum] 
D)  (LoadPageNum)

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

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

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.

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

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

Headers, footers, and margins are all ____ options.

The ____________________ tab contains the commands for setting the location of page breaks or centering a printout horizontally and vertically.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keyboard shortcut to copy an image of the source area as a picture.

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Reposition page break in Page Break Preview.

Which of the following is a method of electronic document distribution?

The path to the Comma Style button is ____.

Excel copies page setup characteristics when one sheet is copied to another.

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

You can drill all of the following down through a workbook EXCEPT ____.

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

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

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

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

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

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

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

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.

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

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

Headers, footers, and margins are all ____ options.

The ____________________ tab contains the commands for setting the location of page breaks or centering a printout horizontally and vertically.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keyboard shortcut to copy an image of the source area as a picture.

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Reposition page break in Page Break Preview.

Which of the following is a method of electronic document distribution?

The path to the Comma Style button is ____.

Excel copies page setup characteristics when one sheet is copied to another.

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

You can drill all of the following down through a workbook EXCEPT ____.

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

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

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

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

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