Question 1

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

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

Accepted Answer

A) True 
 B)False

Question 3

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

Accepted Answer

A)  45 
B)  90 
C)  0 
D)  125 
A)  45 
B)  90 
C)  0 
D)  125

Question 4

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 5

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function.

Accepted Answer

A) True 
 B)False

Question 6

Error messages begin with the ____ symbol.

Accepted Answer

A)  (?) 
B)  = 
C)  ! 
D)  # 
A)  (?) 
B)  = 
C)  ! 
D)  #

Question 7

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which of the following formulas contains an absolute cell reference?

Accepted Answer

A)  =$B4 
B)  =B$4 
C)  =$B$4 
D)  =B4 
A)  =$B4 
B)  =B$4 
C)  =$B$4 
D)  =B4

Question 10

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 11

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

Accepted Answer

A)  Wednesday 
B)  Thursday 
C)  Saturday 
D)  Monday 
A)  Wednesday 
B)  Thursday 
C)  Saturday 
D)  Monday

Question 12

You can press the ____ keys to open the Format Cells dialog box.

Accepted Answer

A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4 
A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4

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

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

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

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function.

Error messages begin with the ____ symbol.

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

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

Which of the following formulas contains an absolute cell reference?

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

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

You can press the ____ keys to open the Format Cells dialog box.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

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

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

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

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

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function.

Error messages begin with the ____ symbol.

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

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

Which of the following formulas contains an absolute cell reference?

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

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

You can press the ____ keys to open the Format Cells dialog box.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

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