Question 1

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 2

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

Accepted Answer

A) style 
B) workbook name 
C) location 
D) sheet name 
A) style 
B) workbook name 
C) location 
D) sheet name

Question 3

-The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.

Accepted Answer

A)  summarization 
B)  consolidation 
C)  encapsulation 
D)  recapitulation 
A)  summarization 
B)  consolidation 
C)  encapsulation 
D)  recapitulation

Question 4

Which of the following fill actions can you perform by dragging the fill handle?

Accepted Answer

A) Jan,Feb,March,etc. 
B) 1,1,1,etc. 
C) 2,4,6,etc. 
D) 1,2,3,etc. 
E)  None of the above. 
A) Jan,Feb,March,etc. 
B) 1,1,1,etc. 
C) 2,4,6,etc. 
D) 1,2,3,etc. 
E)  None of the above.

Question 5

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 ____________________,which defines...

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-By default,this is blank in a 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 7

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

Accepted Answer

A)  .(period) 
B)  % (percent) 
C)  ( ) 
D)  $* 
A)  .(period) 
B)  % (percent) 
C)  ( ) 
D)  $*

Question 8

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.

Accepted Answer

The answer of To start a new workbook with more...

Question 9

When you print a worksheet or use the Page Setup dialog box,Excel inserts ____ that show the boundaries of what will print on each page.

Accepted Answer

A)  margins 
B)  selection barriers 
C)  indices 
D)  page breaks 
A)  margins 
B)  selection barriers 
C)  indices 
D)  page breaks

Question 10

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

Accepted Answer

A) True 
 B)False

Question 11

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)

Question 12

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 13

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 14

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

Accepted Answer

for positive numbers - $*#,##0

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A formula that depends on its own value.

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 17

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________.

Accepted Answer

drilling a

Question 18

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 19

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 20

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

Headers,footers,and margins are all ____ options.

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

-The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.

Which of the following fill actions can you perform by dragging the fill handle?

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -By default,this is blank in a worksheet.

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

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.

When you print a worksheet or use the Page Setup dialog box,Excel inserts ____ that show the boundaries of what will print on each page.

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

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

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

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.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A formula that depends on its own value.

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________.

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

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

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

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

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

Financial Functions,Data Tables,and Amortization Schedules

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 5: Working With Multiple Worksheets and Workbooks

Headers,footers,and margins are all ____ options.

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

-The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.

Which of the following fill actions can you perform by dragging the fill handle?

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -By default,this is blank in a worksheet.

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

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.

When you print a worksheet or use the Page Setup dialog box,Excel inserts ____ that show the boundaries of what will print on each page.

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

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

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

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.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A formula that depends on its own value.

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________.

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

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

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

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

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

Financial Functions,Data Tables,and Amortization Schedules

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters