Answered

Welcome to Westonci.ca, where your questions are met with accurate answers from a community of experts and enthusiasts. Get quick and reliable solutions to your questions from a community of seasoned experts on our user-friendly platform. Explore comprehensive solutions to your questions from knowledgeable professionals across various fields on our 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 :

raphealnwobi

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

Thank you for your visit. We are dedicated to helping you find the information you need, whenever you need it. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Thank you for choosing Westonci.ca as your information source. We look forward to your next visit.