Question

Name the cells that will considered when the following functions are entered = count(d2,d5:d8) = average(d4.,:f8 ) = max(d3, d5, a1:a5) = sum( a3,a5,d2,d4)​

Answer 1

Answer:

1) =count(d2,d5:d8) - the cells d2 , d5 , d6 , d7 and d8 are considered

2) =average(d4:f8) - the cells d4,d5,d6,d7,d8, e4,e5,e6,e7,e8, f4.f5.f6.f7 and f8 are considered

3) =max(d3,d5, a1:a5) - the cells d3,d5,a1,a2,a3,a4 and a5 are considered

4) =sum(a3,a5,d2,d4) - the cells a3,a5,d2 and d4 are considered