". VdoTips: MS EXCEL PRACTICE SET

APPLY LATEST GOVT JOBS

hi

MS EXCEL PRACTICE SET

1. Which of the following is an absolute cell reference?
(A)!A!1
(B)$A$1
(C)#a#1
(D)A1


2. What symbol is used before a number to make it a label?
(A)“ (quote)
(B)= (equal)
(C)_ (underscore)
(D)‘ (apostrophe)


3. Which symbol must all formula begin with?
(A)=
(B)+
(C)(
(D)@


4. Which of the following formulas is not entered correctly?
(A)=10+50
(B)=B7*B1
(C)=B7+14
(D)10+50


5. 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