Question

In cell K10, create a formula using the SUM function that calculated the total of the range F17:F20 subtracts it from the value in cell J10 adds the total of the range G17:G20 and subtracts 160
​

Answer 1

In cell K10, insert the formula: '=J10 - SUM(F17:F20) + SUM(G17:G20) - 160'

What is Microsoft excel

Microsoft Excel is a spreadsheet program used for data visualization and analysis using formulas and functions. A function is a preset formula, that helps perform mathematical, statistical and logical operations.

To solve the above problem, in cell K10, insert the formula: '=J10 - SUM(F17:F20) + SUM(G17:G20) - 160'

Find out more on Microsoft excel at: https://brainly.com/question/1538272