Home › CBSE Class 12 (Commerce) › Accountancy › Computerised Accounting System › SUMIF over cells holding 2, 4, 3, 7 and 5 with t…
SUMIF over cells holding 2, 4, 3, 7 and 5 with the condition below 6 returns
A10
B14
C21
D9
Answer & Solution
Correct answer: B. 14
Only 2, 4, 3 and 5 are below 6, and 2 + 4 + 3 + 5 = 14.
Related questions
Excel 2007 chart tools are found on which ribbon tab?Data markers of the same colour in a chart form aA plot has at least two axes. The horizontal one is usually theWhich payroll deduction is a monthly share of the yearly income tax?Which payroll deduction is levied under state legislation in some states?In a salary bill, Dearness Allowance compensates employees forA clerk's basic pay earned is 25000 and house rent allowance is 8 percent of it. The allowWith basic pay earned of 18000 and a PF rate of 12 percent, the PF deduction is