MS-Excel - MS-Excel MCQ

21:  

In MS-Excel you can use the drag and drop method to

A.

Copy cell contents

B.

Move cell contents

C.

Add cell contents

D.

(A) and (B)

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



22:  

In MS-Excel which of the following is not a worksheet design criterion?

A.

Efficiency

B.

Aditibility

C.

Description

D.

All of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



23:  

In MS-Excel it is acceptable to let long text flow into adjacent cells on a worksheet when

A.

Data will be entered in the adjacent cells

B.

No data will be entered in the adjacent cells

C.

Both (a) & (b)

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



24:  

In MS-Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

A.

Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

B.

Click page setup on the file menu, click the page tab, click the options button, then enter your choices.

C.

Click page setup on the file menu, click the sheet tab, and make a selection under the print heading.

D.

All of above

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



25:  

In MS-Excel a fast way to add up data in a column is to click in the cell below the numbers and then

A.

Click subtotals on the data menu

B.

View the sum in the formula bar

C.

Click the autosum button on the standard toolbar, then press enter

D.

All of above

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here: