Question 1

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

Accepted Answer

A)  Accounting 
B)  Custom 
C)  General 
D)  Number 
A)  Accounting 
B)  Custom 
C)  General 
D)  Number

Question 2

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 3

An organization may keep data from various departments or regions in different worksheets in the same workbook.

Accepted Answer

A) True 
 B)False

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Keyboard shortcut to paste the contents and format of source area.

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 5

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area but swap the rows and columns.

Accepted Answer

The answer of The ____________________ option is the Paste Gallery...

Question 6

The path to the Sum button is ____.

Accepted Answer

Question 7

You can display the ____ tab to specify page setup options.

Accepted Answer

A)  SETUP 
B)  PRINT 
C)  PAGE LAYOUT 
D)  DISPLAY 
A)  SETUP 
B)  PRINT 
C)  PAGE LAYOUT 
D)  DISPLAY

Question 8

The ____________________ format code displays the characters in the cell in the designated color.

Accepted Answer

The answer of The ____________________ format code displays the characters...

Question 9

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.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

You can switch to Page Layout view by clicking the Page Layout button ____.

Accepted Answer

A)  on the status bar 
B)  (HOME tab | Layout group) 
C)  (VIEW tab | Show group) 
D)  on the FILE tab 
A)  on the status bar 
B)  (HOME tab | Layout group) 
C)  (VIEW tab | Show group) 
D)  on the FILE tab

Question 13

You can enter formulas that reference cells on other worksheets in the workbook.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

Question 15

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 16

Always take the time to select ____________________ data that tests the limits of the formulas.

Accepted Answer

The answer of Always take the time to select ____________________...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

Accepted Answer

A) True 
 B)False

Question 19

An alternative to adding worksheets to a workbook is to change the ____________________ number of worksheets before you open a new workbook.

Accepted Answer

The answer of An alternative to adding worksheets to a...

Question 20

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

Accepted Answer

A) True 
 B)False

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

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

An organization may keep data from various departments or regions in different worksheets in the same workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keyboard shortcut to paste the contents and format of source area.

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area but swap the rows and columns.

The path to the Sum button is ____.

You can display the ____ tab to specify page setup options.

The ____________________ format code displays the characters in the cell in the designated color.

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.

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

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

You can switch to Page Layout view by clicking the Page Layout button ____.

You can enter formulas that reference cells on other worksheets in the workbook.

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

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

Always take the time to select ____________________ data that tests the limits of the formulas.

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

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

An alternative to adding worksheets to a workbook is to change the ____________________ number of worksheets before you open a new workbook.

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

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

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

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

An organization may keep data from various departments or regions in different worksheets in the same workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Keyboard shortcut to paste the contents and format of source area.

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area but swap the rows and columns.

The path to the Sum button is ____.

You can display the ____ tab to specify page setup options.

The ____________________ format code displays the characters in the cell in the designated color.

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.

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

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

You can switch to Page Layout view by clicking the Page Layout button ____.

You can enter formulas that reference cells on other worksheets in the workbook.

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

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

Always take the time to select ____________________ data that tests the limits of the formulas.

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

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

An alternative to adding worksheets to a workbook is to change the ____________________ number of worksheets before you open a new workbook.

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

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