Respuesta :
Complete question:
Add the range of cells A1:B10
Divide A2 by the sum of the range of cells in A10 through C10
Find the highest number in the cell range A1:C10
Subtract B8 from the sum of cells C1 through C10
Multiply A6 by the sum of cells A1 through C10 and then divide the result by A2
Find the lowest number in the cell range A1:A10
Calculate the average of cells C1:C10
Multiply the sum of the range of cells A7 through B10 by the sum of the range of cells B2 through C9
Find the average of all data in the spreadsheet (A1:C10)
Subtract C10 from the sum of the cells in the range A1 through A10
Solution:
Done this solution With the Microsoft's Excel
shift - F3 (insert function) may help.
Add the range of cells A1:B10
=SUM(A1:B10)
Divide A2 by the sum of the range of cells in A10 through C10
=A2/SUM(A10:C10)
Find the highest number in the cell range A1:C10
=MAX(A1:C10)
Subtract B8 from the sum of cells C1 through C10
=SUM(C1:C10)-B8
Multiply A6 by the sum of cells A1 through C10 and then divide the result by A2
=A6*SUM(A1:C10)/A2
Find the lowest number in the cell range A1:A10
=MIN(A1:A10)
Calculate the average of cells C1:C10
=AVERAGE(C1:C10)
Multiply the sum of the range of cells A7 through B10 by the sum of the range of cells B2 through C9
=SUM(A7:B10)*SUM(B2:C9)
Find the average of all data in the spreadsheet (A1:C10)
=AVERAGE(A1:C10)
Subtract C10 from the sum of the cells in the range A1 through A10
=SUM(A1:A10)-C10