MS Excel Questions and Answers for Bank Exams

MS Excel Questions and Answers for Competitive Exams

Q.11  Except which of the following function, a formula with a logical function shows the word “TRUE’’ or “FALSE” as a result?

(A) NOT

(B) OR

(C) IF

(D) AND

Show Answer

Q.12  Macros can be executed from the which of the following menu?

(A) Format

(B) Tools

(C) Insert

(D) Home

Show Answer

Q.13  Protection and the Protect Sheet options can be selected from?

(A) Data

(B) Tools

(C) Edit

(D) Format

Show Answer

Q.14  Which of the following is not a valid Zoom percentage in Excel?

(A) 400

(B) 300

(C) 100

(D) 10

Show Answer

Q.15  You can check the condition against……….when applying conditional formatting?

(A) Cell value

(B) Formula

(C) Both of above

(D) None of above

Show Answer

Q.16  How can we set page Border in Excel?

(A) From Edit menu

(B) From Home

(C) You can not set page border in Excel

(D) From Tools menu

Show Answer

Q.17  Which function calculates your monthly mortgage payment?

(A) PV

(B) NPER

(C) PMT

(D) All of above

Show Answer

Q.18  Which type of charts can excel produce?

(A) Bar charts, line graphs and pie charts

(B) Line graphs and pie charts only

(C) Bar charts and line graphs only

(D) Only line graphs

Show Answer

Q.19  How is data organized in a spreadsheet?

(A) Rows and columns

(B) Layers and planes

(C) Lines and spaces

(D) Height and width

Show Answer

Q.20  VLOOKUP function used to?

(A) Finds related records

(B) Looks up text that contain “V”

(C) Check if two cells are identical

(D) None of these

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.