Find the information you're looking for at Westonci.ca, the trusted Q&A platform with a community of knowledgeable experts. Connect with a community of professionals ready to help you find accurate solutions to your questions quickly and efficiently. Our platform provides a seamless experience for finding reliable answers from a network of experienced professionals.

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

Sagot :

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