Question

СРОЧНО!!!! ДАЮ 100 БАЛЛОВ!!

Answer 1

Скріншот прикріпив.

Формули:

B13:   =AVERAGE(B4:F10)

B14:   =MAX(B4:F10)

B15:   =MIN(B4:F10)

B16:   =COUNTIF(B4:F10,">0")

B17:   =COUNTIF(B4:F10,"<0")

B18:   =COUNTIF(B4:F10,"=0")

G13:   =AVERAGE(G4:K10)

G14:   =MAX(G4:K10)

G15:   =MIN(G4:K10)

G16:   =COUNTIF(G4:K10,">0")

G17:   =COUNTIF(G4:K10,"<0")

G18:   =COUNTIF(G4:K10,"=0")

L13:   =AVERAGE(L4:P10)

L14:   =MAX(L4:P10)

L15:   =MIN(L4:P10)

L16:   =COUNTIF(L4:P10,">0")

L17:   =COUNTIF(L4:P10,"<0")

L18:   =COUNTIF(L4:P10,"=0")

O13:   =AVERAGE(B4:P10)

O14:   =MAX(B4:P10)

O15:   =MIN(B4:P10)

O16:   =COUNTIF(B4:P10,">0")

O17:   =COUNTIF(B4:P10,"<0")

O18:   =COUNTIF(B4:P10,"=0")