Excel Quiz Questions & Answers - 2 (Basics)

Question 1 of 10

Given the table below(Function-wise number of employees & total salary of those employees) for a small company. If we want to calculate the total salary outlay for all the functions except finance & Human Resources, which of these formulas will not be correct?

=C2+C3+C4+C5+C8+C9

=SUM(C2:C5)+SUM(C8:C9)

=SUM(C2:C5, C8:C9)

=SUM(C2:C5)+SUM(C6:C9)-C6