Question 1

____ text often provides a strong visual appeal.

Accepted Answer

A)  Launched 
B)  Tiny 
C)  Logical 
D)  Rotated 
A)  Launched 
B)  Tiny 
C)  Logical 
D)  Rotated

Question 2

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

Accepted Answer

SPARKLINE

Question 3

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box.Which of the following are valid values for that number?

Accepted Answer

A) 15 
B) 90 
C) 145 
D) 180 
A) 15 
B) 90 
C) 145 
D) 180

Question 4

The syntax of the IF function is IF(logical_test),value_if_false,value_if_true).

Accepted Answer

A) True 
 B)False

Question 5

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A)  included 
B)  other 
C)  nested 
D)  duplicate 
A)  included 
B)  other 
C)  nested 
D)  duplicate

Question 6

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Accepted Answer

A) True 
 B)False

Question 7

Using the mouse to move or copy cells is called ____.

Accepted Answer

A)  drop and drag 
B)  drag and drop 
C)  drag and copy 
D)  drag and paste 
A)  drop and drag 
B)  drag and drop 
C)  drag and copy 
D)  drag and paste

Question 8

Explain in detail the utility of freezing worksheet columns and rows.

Accepted Answer

Freezing worksheet columns and rows is a

Question 9

-In the accompanying figure,the split double arrow mouse pointer ____.

Accepted Answer

A)  indicates a hidden column 
B)  allows text to be entered at that location 
C)  is the result of moving the mouse pointer to the boundary between column heading A and column heading B 
D)  indicates the proposed width of column A 
A)  indicates a hidden column 
B)  allows text to be entered at that location 
C)  is the result of moving the mouse pointer to the boundary between column heading A and column heading B 
D)  indicates the proposed width of column A

Question 10

-The type of chart shown in the accompanying figure is a(n)____________________ chart.

Accepted Answer

The answer of  
-The type of chart shown in...

Question 11

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Accepted Answer

A) True 
 B)False

____ text often provides a strong visual appeal.

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box.Which of the following are valid values for that number?

The syntax of the IF function is IF(logical_test),value_if_false,value_if_true).

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Using the mouse to move or copy cells is called ____.

Explain in detail the utility of freezing worksheet columns and rows.

-In the accompanying figure,the split double arrow mouse pointer ____.

-The type of chart shown in the accompanying figure is a(n)____________________ chart.

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

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 3: Working With Large Worksheets,Charting,and What-If Analysis

____ text often provides a strong visual appeal.

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box.Which of the following are valid values for that number?

The syntax of the IF function is IF(logical_test),value_if_false,value_if_true).

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Using the mouse to move or copy cells is called ____.

Explain in detail the utility of freezing worksheet columns and rows.

-In the accompanying figure,the split double arrow mouse pointer ____.

-The type of chart shown in the accompanying figure is a(n)____________________ chart.

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

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