Basic Computer Knowledge :: Ms Excel For IBPS PO LIC AAO Question And Answers

























































11. Which of the following is an absolute cell reference?

A. !A!1 B. $A$1
C. #a#1 D. A1
View Answer Discuss in Forum

12. What symbol is used before a number to make it a label?

A. “ (quote) B. = (equal)
C. _ (underscore) D. ‘ (apostrophe)
View Answer Discuss in Forum

13. Which symbol must all formula begin with?

A. = B. +
C. ( D. @
View Answer Discuss in Forum

14. Which of the following formulas is not entered correctly?

A. =10+50 B. =B7*B1
C. =B7+14 D. 10+50
View Answer Discuss in Forum

15. Which of the following formulas will Excel Not be able to calculate?

A. =SUM(Sales)-A3 B. =SUM(A1:A5)*.5
C. =SUM(A1:A5)/(10-10) D. =SUM(A1:A5)-10
View Answer Discuss in Forum

16. A typical worksheet has …. Number of columns

A. 128 B. 256
C. 512 D. 1024
View Answer Discuss in Forum

17. How many characters can be typed in a single cell in Excel?

A. 256 B. 1024
C. 32,000 D. 65,535
View Answer Discuss in Forum

18. A worksheet can have a maximum of …. Number of rows

A. 256 B. 1024
C. 32,000 D. 65,535
View Answer Discuss in Forum

19. Which of the following is not an example of a value?

A. 350 B. May 10, 2001
C. 57% D. Serial Number 50771
View Answer Discuss in Forum

20. The chart wizard term data series refers to

A. A chart legend B. A collection of chart data markers
C. A data label D. A set of values you plot in a chart
View Answer Discuss in Forum



Related Topics

Ms Excel For IBPS LIC AAO
Computer Networking Basics
Computer LIC AAO 2016
Basics of Computers
LIC AAO Exam Computer
Computer Knowledge Interview






Who are all can get the advantages from this Ms Excel For IBPS PO LIC AAO Question and Answers section?

Those are all planning for any competitive examinations can use this segment to enhance their abilities.