MS-Excel - MS-Excel MCQ

81:  

In MS-Excel the following describes how to select all the cells in a single column?

A.

Right click on column and select Pick from list

B.

Use data - text to columns menu item

C.

Left click on the gray column title button

D.

Both (a) & (c)

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



82:  

MS-Excel & paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

A.

Rows and columns

B.

Headings

C.

Speed

D.

Both (a) & (b)

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



83:  

In MS-Excel which of these will not select all the cells in a document?

A.

Clicking three times with the right mouse button in the spreadsheet

B.

Using the Edit - Select All menu

C.

Pressing Ctrl + A on the keyboard

D.

All of these

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



84:  

In MS-Excel all worksheet formula

A.

Manipulate values

B.

Manipulate labels

C.

Return a formula result

D.

Both (a) & (b)

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



85:  

In MS-Excel you can use the formula palette to

A.

Format cells containing numbers

B.

Create and edit formulas containing functions

C.

Enter assumptions data

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here: