Question

ilities spreadsheet
keep track of her liabilities using a spreadsheet similar to this one. she has an auto loan, medical bills,
quity loan.
match each formula with the correct cell to complete jadas spreadsheet.
=sum(b2:b5) =sum(c2:c5) =(c6 - b6)/b6×100

Explanation:

Step1: Analyze the formula =SUM(B2:B5)

This formula calculates the sum of the values in cells B2 to B5. In the context of the spreadsheet, column B is labeled "Original Value". So, this formula should be in the cell that represents the total of the original values. Looking at the spreadsheet, cell B6 is likely the total of the original values (since rows 2 - 5 are individual items and row 6 is a summary row).

Step2: Analyze the formula =SUM(C2:C5)

This formula calculates the sum of the values in cells C2 to C5. Column C is labeled "Current Value". So, this formula should be in the cell that represents the total of the current values. Cell C6 is likely the total of the current values.

Step3: Analyze the formula =(C6 - B6)/B6×100

This formula calculates the percentage change. The percentage change is calculated as \(\frac{\text{Current Value}-\text{Original Value}}{\text{Original Value}}\times100\). Column D is labeled "Percent Change (\%)", so this formula should be in cell D6.

Answer:

B6: =SUM(B2:B5), C6: =SUM(C2:C5), D6: =(C6 - B6)/B6×100