MS excel set 4 Detailed Explanation And More Example

Question : 1

When you link data maintained in an excel workbook to a word document

a) The word document cannot be edit

b) The word document contains a reference to the original source application

c) The word document must contain a hyperlink

d) The word document contains a copy of the actual data

Question : 2

When you see a cell with a red triangle in the top right corner, what does this signify?

a) There is an error in the cell.

b) There is a comment associated with the cell

c) The font color for text in the cell is red

d) A formula cannot be entered into the cell

e) None of these

Question : 3

In Excel when the formula bar is active, you can see

a) The edit formula button

b) The cancel button

c) The enter button

d) All of the above

Question : 4

In Excel when you copy a formula

a) Excel erases the original copy of the formula

b) Excel edits cell references in the newly copied formula

c) Excel adjusts absolute cell references

d) Excel doesn’t adjust relative cell references

Question : 5

Data can be arranged in a worksheet in a easy to understand manner using

a) auto formatting

b) applying styles

c) changing fonts

d) all of above

e) None of these

Question : 6

Excel files have a default extension of

a) Xls

b) Xlw

c) Wk1

d) 123