Can we find the average of more than one range of cells? If yes, what will be the structure of such a function?

Yes, we can find the average of more than one range of cells by using the AVERAGE function.

The structure of the AVERAGE function used is as follows:

= AVERAGE (Range1 , Range2, …)

For example, to find out the average of range B2 : D2 and B3 : D3, we will write the formula as follows:

= AVERAGE (B2 : D2 , B3 : D3)