MS Excel Questions Answers for bank exams IBPS PO, IBPS RRB, NIACL, NICL, LIC, BOI, Bank of Baroda and other competitive exams
- 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
E) none of these
- Macros can be executed from the which of the following menu ?
A) format
B) home
C) insert
D) tools
E) none of these
- What function displays row data in a column or column data in a row ?
A) transpose
B) index
C) rows
D) hyperlinks
E) none of these
- You can convert existing Excel worksheet data and charts to HTML document by using the ?
A) internet assistant wizard
B) intranet wizard
C) import wizard
D) export wizard
E) None of these
- Which of the following is not a valid Zoom percentage in Excel ?
A) 10
B) 100
C) 300
D) 500
E) none of these
- MS-EXCEL can be used to automate
A) Financial statements, Business forecasting
B) Transaction registers, inventory control
C) Accounts receivable, accounts payable
D) Any of the above
E) none of these
- In Excel _______ may not contain in Formula
A) text constant
B) number constant
C) circular reference
D) all of them
E) none of these
- In Excel, by default Numeric Values appears in
A) left aligned
B) right aligned
C) center aligned
D) justify aligned
E) none of these
- What is the shortcut key to insert new sheet in current workbook?
A) F11
B) ALT+F11
C) CTRL+F11
D) SHIFT+F11
E) None of these
- What is the shortcut key to hide entire row?
A) CTRL+H
B) CTRL+R
C) CTRL+9
D) CTRL+ –
E) None of these
7/10 ty:)) Az
Thx az
8/10
Tnx
Thank you
9/10..ty Az..
I think 3rd should be ..Transpose
.question 3rd ans must be option no. one i.e. TRANSPOSE
shortcut key to insert new sheet in current workbook= alt+shift+F1
thank you team
thnxx
9/10
Thank u