Welcome to Westonci.ca, your ultimate destination for finding answers to a wide range of questions from experts. Get quick and reliable solutions to your questions from a community of seasoned experts on our user-friendly platform. Discover in-depth answers to your questions from a wide network of professionals on our user-friendly Q&A platform.

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