sharonupshaw9489 sharonupshaw9489
  • 03-03-2022
  • Computers and Technology
contestada

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
​

Respuesta :

raphealnwobi
raphealnwobi raphealnwobi
  • 10-03-2022

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

Answer Link

Otras preguntas

5t + 5 = 30 solve for t
The population of a city increases by 10,000 per year. The starting population is 800,000. Let P be the ending population. Which shows an equation for the tot
how do i prove angle x and angle yzv are supplementary
Why did workers begin to form unions
When was the Archie comics created? what year.
Which of these is most likely to help someone avoid marijuana? A. Promotions from marijuana supporters B. Friends who use marijuana C. A public service annou
What is the answer of 15•x•6=
Which organ in the human body would you compare to the lysosome? A. stomach B. heart C. lungs
When the body changes an internal condition back to its normal state it is called?
• Spanish military leader • Regained Florida from the British • Helped draft the Treaty of Paris • Assisted in the American Revolution Who is described in the c