MS excel set 6 Detailed Explanation And More Example

Question : 1

Except for the ...... function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result

a) IF

b) AND

c) OR

d) NOT

e) None of these

Question : 2

You can use the horizontal and vertical scroll bars to

a) Split a, worksheet into two panes

b) View different rows and columns edit the contents of a cell

c) Edit the contents of a cell

d) view different worksheets

e) None of these

Question : 3

In Excel which of the following is not a way to complete a cell entry?

a) Pressing enter

b) Pressing any arrow key on the keyboard

c) Clicking the Enter button on the Formula bar

d) Pressing spacebar

Question : 4

NOT, AND, OR and XOR are

a) Logical Operators

b) Arithmetic operators

c) Relational operators

d) All of the above

e) None of these

Question : 5

B7:B9 indicates:

a) Cells B7 and cell B9 only.

b) Cells B7 through B9.

c) Cell only.

d) All of the above.

e) None of these

Question : 6

Which tool you will use to join some cells and place the content at the middle of joined cell?

a) From Format Cells dialog box click on Merge Cells check box

b) From Format Cells dialog box select the Centered alignment

c) From Format Cells dialog box choose Merge and Center check box

d) Click on Merge and Center tool on formatting toolbar

e) None of these