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 :

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

Write your comments here:



Related MCQ