MS Excel Questions and Answers for Bank Exams

MS Excel Questions and Answers for Competitive Exams

Q.21  How do you change column width to fit the contents?

(A) Single-click the boundary to the left to the column heading

(B) Double click the boundary to the right of the column heading

(C) Press Alt and single click anywhere  in the column

(D) All of above.

Q.22  To insert three columns between columns A and B you would

(A) Select Column A

(B) Select A and B

(C) Select B

(D) All of above

Q.23  To drag a selected range of data to another worksheet in the same workbook, use the?

(A) Ctrl key

(B) Shift key

(C) Alt key

(D) Tab key

Q.24  You can activate a cell by?

(A) Pressing the Tab key

(B) Clicking the cell

(C) Pressing an arrow key

(D) All of the above

Q.25  A function inside another function is known as ?

(A) Nested function

(B) Switched function

(C) Sandwich function

(D) Round function

Q.26  What excel feature can you use if you want to work with one record at a time?

(A) Auto Complete

(B) Data Form

(C) Set Form

(D) Auto Text

Q.27  Which function is used for creating a data table?

(A) Sum

(B) Table

(C) Add

(D) Count

Q.28  The accounting style shows negative numbers in?

(A) Bold

(B) Italics

(C) Parentheses

(D) Quotes

Q.29  3-D reference in a formula?

(A) Spans worksheet

(B) Can not be modified

(C) Only appears on summary worksheets

(D) Limits the formatting options

Q.30  3-D reference in a formula?

(A) + and -

(B) ! and ^

(C) * and ?

(D) <and>

You can comment in the comment box or can ask anything related ms-excel questions and answers if you have any doubts or problems. Visit on the next page for more practice of ms-excel questions and answers.