Question 1

FIGURE EX 15-1  In Figure EX 15-1 above, item 2 points to a(n) ____.

Accepted Answer

A)  trace 
B)  suggestion 
C)  view 
D)  error

Question 2

Match between columns
                        Premises: A group of adjacent worksheets.

Accepted Answer

The Answer of Source and Worksheet range and Destination and is...

Question 3

To instantly create a chart in its own chart sheet, simply select the range of data you want in the chart and press ____.

Accepted Answer

A)  F3 
B)  F5 
C)  F7 
D)  F11

Question 4

A PivotTable lets you twist or rearrange the data.

Accepted Answer

A) True 
 B)False

Question 5

The user cannot change the macro security level in Excel.

Accepted Answer

A) True 
 B)False

Question 6

The results of the calculation appear in the cell in which the formula is entered.

Accepted Answer

A) True 
 B)False

Question 7

You can consolidate data from several worksheets in the same workbook or between several workbooks.

Accepted Answer

A) True 
 B)False

Question 8

You must use double brackets to enclose the text you want the IF function to return in the second and third arguments.

Accepted Answer

A) True 
 B)False

Question 9

Moving a worksheet does not affect 3-D references in the workbook.

Accepted Answer

A) True 
 B)False

Question 10

The formula =SUM(Sheet2:Sheet4!D12), adds the value from cell D12 in the Sheet2, Sheet3, and Sheet4 worksheets.

Accepted Answer

A) True 
 B)False

Exam 2: Microsoft Excel Basics

FIGURE EX 15-1 In Figure EX 15-1 above, item 2 points to a(n) ____.