Classical

MS-Excel - Advanced MS-Excel

26:  

In MS-Excel the view that puts a blue a blue line around each page that would be printed is the

A.

Print Preview

B.

Normal View

C.

Page Break Preview

D.

None of these

 
 

Option: C

Explanation :


27:  

In MS-Excel to select an individual data marker or data label, you must

A.

Double click the data series

B.

Right click selected marker

C.

Both (a) & (b)

D.

Double click the marker or label

 
 

Option: D

Explanation :


28:  

In MS-Excel what does SUMIF function do?

A.

Adds up cell values based on a condition

B.

Adds all the numbers in a range of cells

C.

Returns a subtotal in a list or database

D.

Both (a) & (b)

 
 

Option: A

Explanation :


29:  

In MS-Excel you can insert labels for

A.

All the data markers on a chart

B.

A data series

C.

A selected data marker

D.

All of the above

 
 

Option: D

Explanation :




Suggest an improvement