Advertisements
- 11. Which of the following is an absolute cell reference?
A.!A!1
B.$A$1
C.#a#1
D.A1
Answer & Explanation
Answer: Option B 
$A$1
View Answer
- 12. What symbol is used before a number to make it a label?
A.“ (quote)
B.= (equal)
C._ (underscore)
D.‘ (apostrophe)
Answer & Explanation
Answer: Option B
= (equal)
View Answer
- 13. Which symbol must all formula begin with?
A.=
B.+
C.(
D.@
Answer & Explanation
Answer: Option A
=
View Answer
- 14. Which of the following formulas is not entered correctly?
A.=10+50
B.=B7*B1
C.=B7+14
D.10+50
Answer & Explanation
Answer: Option D
10+50
View Answer
- 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
Answer & Explanation
Answer: Option A
=SUM(Sales)-A3
View Answer
To whom this Ms Excel For IBPS PO LIC Questions and Answers section is beneficial?
Students can learn and improve on their skillset for using Verbal Ability effectively and can also prepare for competitive examinations like...
- All I.B.P.S and Public Sector Bank Competitive Exam
- Common Aptitude Test (CAT) Exams
- UPSC Paper-II or CSAT Exams
- SSC Competitive Exams
- Defence Competitive Exams
- L.I.C / G.I.C AO and Clerk Competitive Exams
- Railway Competitive Exam
- University Grants Commission (UGC)
- Career Aptitude Test (IT Companies) and etc.