MS-Excel - MS-Excel MCQ

111:  

In MS-Excel Rounding errors can occur

A.

When you use multiplication, division, or exponentiation in a formula

B.

When you use addition and subtraction in a formula

C.

Because MS-Excel uses hidden decimal places in computation

D.

None of these

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



112:  

In MS-Excel one can copy data or formulas

A.

With the copy, paste and cut commands on the edit menu

B.

With commands on the shortcut menu

C.

With buttons on the standard toolbars

D.

All of the above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



113:  

In MS-Excel when working in the page break preview, you can

A.

View exactly where each page break occurs

B.

Add or remove page breaks

C.

Change the print area

D.

All of above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



114:  

To copy formatting from one area in a worksheet and apply it to another area you would use

A.

The Edit>Copy Format and Edit>Paste Format commands form the menu

B.

The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu

C.

There is no way to copy and apply formatting in MS-Excel - You have to do it manually.

D.

The Format Painter button on the standard toolbar

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



115:  

Which area in an MS-Excel window allows entering values and formulas ?

A.

Title bar

B.

Menu bar

C.

Formula bar

D.

Both (b) & (c)

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



Related MCQ