MS-Excel - MS-Excel MCQ

86:  

In MS-Excel you can convert existing worksheet data an charts to an HTML document by using

A.

FTP wizard

B.

Internet assistant wizard

C.

lntranet wizard

D.

None of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



87:  

In MS-Excel the Paste Special command lets you copy and paste

A.

Multiply the selection by a copied value

B.

Cell formulas

C.

Formatting options

D.

The resulting values of a formula instead of the actual formula

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



88:  

In MS-Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

A.

None of these

B.

Select Format > Money from the menu

C.

Click the Currency Style button on the formatting toolbar

D.

You have to retype everything and manually add the dollar signs, commas, and decimals.

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



89:  

In MS-Excel which of the following is not a valid data type

A.

Number

B.

Character

C.

Label

D.

All of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



90:  

In MS-Excel which of the following options is not located in the Page Setup dialog box?

A.

Page Break Preview

B.

Page Orientation

C.

Margins

D.

Both (a) & (c)

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here: