PO ASSOCIATE BANK EXAM QUESTION ANSWERS Part 2

MICROSOFT EXCEL

1.How can you find special information in a
list?
( 1) Select Tools > Finder from the menu
(2) Click the Find button on the standard toolbar
(3) Select Insert > Find from the menu
(4) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
(5) None of these

2.When integrating word and excel, word is usually the
(1) Server
(2) Destination
(3)Client
(4) Both 2 & 3
(5) None of these


3.Which is used to perform what if analysis?
(1) Solver
(2) Goal seek
(3) Scenario Manager
(4) All of above
(5) None of these

4.Multiple calculations can be made in a
single formula using
(I) standard formulas
(2) array formula
(3) complex formulas
(4) smart formula
(5)None of these


5.Status indicators are located on the
(1) Vertical scroll bar
(2) Horizontal scroll bar
(3) Formula bar
(4) Standard toolbar
(5)N one of these

6.Which of the following is the oldest
spreadsheet package?
(1) VisiCalc
(2) Lotus 1-2-3
(3) Excel
(4) StarCalc
(5) None of these

7.You can convert existing excel worksheet
data an charts to an HTML document by
using
(1) FTP wizard
(2) intemet assistant wizard
(3) Intranet wizard
(4) Import wizard
(5) None of these

8.Which of the following is not a valid data
type in excel
(1) Number
(2) Character
(3) Label
(4) Date/time
(5) None of these


9. Which of the following options is not
located in the Page Setup dialog box?
( l) Page Break Preview
(2) Page Orientation
(3) Margins
(4) Headers & Footers
(5) None of these

10.Without using the mouse or the arrow keys,
what is the fastest way of getting to cell A]
in a spreadsheet?
(1) Press Ctrl +Home
(2) Press Home
(3) Press Shift + Home
(4) Press Alt + Home
(5) None of these

11. The comparison operators used in Excel to
compute criteria are
(l)=,>,<,>=.<=and<>
(2)0nly=
(3) only =, > and <
(4) only > = and < =
(5) None of these

12. Files created with Lotus 1-2-3 have an
extension
(1 ) DOC
(2) XLS
(3) [23
(4) WK]
(5)None of these


13. Which of the following is not a worksheet
design criterion?
(1) Efficiency
(2) Adaptability
(3) Description
(4) Clarity
(5) None of these

14. Which menu option can be sued to split
windows into two
(I) Format > window
(2) View > window > split
(3) Window > split
(4) View > split
(5) None of these

15. What symbol is used before a number to
make it a label?
( l) ” (quote)
(2) = (equal)
(3) _ (underscore)
(4) ‘(apostrophe)
(5) None of these


 BANK QUESION ANSWERS|PO ASSOCIATE QUESTION ANSWERS | Previous years papers to practice the PO Exam |PO BANK EXAM for SBI PNB|Public Sector Bank

Share

& Comment

Tweet