MS Excel Questions and Answers for Bank Exams

MS Excel Questions and Answers for Competitive Exams

Q.31  Which among following is divide symbol in excel?

(A) /

(B) D

(C) Div

(D) \

Q.32  Which function in excel counts the numbers of characters in a cell?

(A) LENGTH

(B) LGT

(C) LEN

(D) LT

Q.33  Which function converts miles to kilometres?

(A) Change

(B) Convert

(C) Shift

(D) Conv

Q.34  What is shortcut to enter current date in cell in excel?

(A) Ctrl +;

(B) Alt +;

(C) Shift + &

(D) Ctrl + $

Q.35  Shortcut to edit the selected cell?

(A) F3

(B) F8

(C) F4

(D) F2

Q.36  Which shortcut can be used to Switch between open workbooks?

(A) Ctrl + F2

(B) Ctrl + F6

(C) Ctrl + F8

(D) Ctrl + F10

Q.37  Shortcut to enter current date?

(A) Insert + -

(B) Shift + -

(C) Alt + -

(D) Ctrl + -

Q.38  Shortcut to enter current date?

(A) Ctrl +;

(B) Shift +;

(C) Home +;

(D) Alt +;

Q.39  When the formula bar is activated, you can see

(A) The Edit Formula button

(B) The cancel button

(C) The Enter button

(D) All of the above

Q.40  Stylesheet formats can be applied from?

(A) Table>>Autoformat

(B) Format>>Autoformat

(C) Table>>Cells

(D) Fromat>>Cells

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.