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