Computer Awareness Capsule for IBPS PO Mains 2020-2021 - 1

Question: 1

Which one of the following is not a Spreadsheet program?

(A) Quattro Pro

(B) MS-DOS

(C) Lotus 1-2-3

(D) VisiCalc

Ans: B

MS-DOS

Question: 2

The bar used to display the current cell and its contents is

(A) Menu bar

(B) Function bar

(C) Formula bar

(D) Object bar

Ans: C

Formula bar

Question: 3

A spreadsheet template is

(A) A What if feature

(B) Formulas and data relationships ready to be calculated as soon as data are entered

(C) A clear plastic sheet divided into rows and columns that fits over the computer screen

(D) None of these

Ans: B

Formulas and data relationships ready to be calculated as soon as data are entered

Question: 4

To calculate the effect of interest rates on sums of money over time, we should use a

(A) String function

(B) Financial function

(C) Statistical function

(D) Mathematical function

Ans: B

Financial function

Question: 5

An electronic spreadsheet consist of

(A) Rows

(B) Columns

(C) Cells

(D) All of these

Ans: D

All of these

Related Questions