Question

small business expenses
in this spreadsheet, expenses are listed in column a and their amounts are in column b.
which formula would you use in cell b13 to calculate the total fixed expenses?
=sum(b2,b3,b4,b8,b9)
=b2 + b3 + b4 + b8
=sum(b2:b3)
=sum(b2:b9)

Explanation:

Step1: Identify fixed - expenses

Fixed expenses are Rent (B2), Liability insurance (B3), Property insurance (B4), Health Insurance (B8), Workers' compensation insurance (B9).

Step2: Select the correct formula

The SUM function is used to add up values. The correct way to sum these specific cells is =SUM(B2,B3,B4,B8,B9).

Answer:

=SUM(B2,B3,B4,B8,B9)