MS-Excel - MS-Excel MCQ

56:  

There are three types of data found in a spreadsheet

A.

data, words, numbers

B.

equations, data, numbers

C.

words, numbers, labels

D.

numbers formulas, labels

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



57:  

In MS-Excel to select a column the easiest method is to

A.

Double click any cell in the column

B.

Drag from the top cell in the column to the last cell in the column

C.

Click the column heading

D.

None of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



58:  

In MS-Excel to copy cell contents using drag and drop press the

A.

End key

B.

Shift key

C.

Ctrl key

D.

Esc key

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



59:  

In MS-Excel when you copy a formula

A.

MS-Excel erases the original copy of the formula

B.

MS-Excel edits cell references in the newly copied formula

C.

MS-Excel adjusts absolute cell references

D.

All of these

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



60:  

In MS-Excel when you want to insert a blank embedded excel worksheet  in a word document you can

A.

Click the object command on the insert menu

B.

Click the office links button on the standard toolbar

C.

Click the create worksheet button on the formatting toolbar

D.

Click the import excel command on the file menu

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here: