Question 1

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

Accepted Answer

The answer of Pressing the ____________________ keyboard shortcut keys opens...

Question 2

To copy the contents of a cell to the cell directly below it,click the target cell and press ____.

Accepted Answer

A)  CTRL+X 
B)  CTRL+D 
C)  CTRL+C 
D)  CTRL+V 
A)  CTRL+X 
B)  CTRL+D 
C)  CTRL+C 
D)  CTRL+V

Question 3

The result of an arithmetic operation,such as multiplication or division,is accurate to the factor with the least number of decimal places.

Accepted Answer

A) True 
 B)False

Question 4

You can use the ENTER key to complete a paste operation.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

-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 8

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 9

You can press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

Accepted Answer

The answer of You can press and hold or right-click...

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

To copy the contents of a cell to the cell directly below it,click the target cell and press ____.

The result of an arithmetic operation,such as multiplication or division,is accurate to the factor with the least number of decimal places.

You can use the ENTER key to complete a paste operation.

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

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.

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

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 press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

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

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

To copy the contents of a cell to the cell directly below it,click the target cell and press ____.

The result of an arithmetic operation,such as multiplication or division,is accurate to the factor with the least number of decimal places.

You can use the ENTER key to complete a paste operation.

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

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.

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

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 press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

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