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

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

(A) Format

(B) Tools

(C) Insert

(D) Home

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

(A) Data

(B) Tools

(C) Edit

(D) Format

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

(A) 400

(B) 300

(C) 100

(D) 10

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

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

Q.17  Which function calculates your monthly mortgage payment?

(A) PV

(B) NPER

(C) PMT

(D) All of above

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

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

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

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.