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) \

Show Answer

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

(A) LENGTH

(B) LGT

(C) LEN

(D) LT

Show Answer

Q.33  Which function converts miles to kilometres?

(A) Change

(B) Convert

(C) Shift

(D) Conv

Show Answer

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

(A) Ctrl +;

(B) Alt +;

(C) Shift + &

(D) Ctrl + $

Show Answer

Q.35  Shortcut to edit the selected cell?

(A) F3

(B) F8

(C) F4

(D) F2

Show Answer

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

(A) Ctrl + F2

(B) Ctrl + F6

(C) Ctrl + F8

(D) Ctrl + F10

Show Answer

Q.37  Shortcut to enter current date?

(A) Insert + -

(B) Shift + -

(C) Alt + -

(D) Ctrl + -

Show Answer

Q.38  Shortcut to enter current date?

(A) Ctrl +;

(B) Shift +;

(C) Home +;

(D) Alt +;

Show Answer

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

Show Answer

Q.40  Stylesheet formats can be applied from?

(A) Table>>Autoformat

(B) Format>>Autoformat

(C) Table>>Cells

(D) Fromat>>Cells

Show Answer

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.