Question ID: 1528 11/34
PREVIOUS QUESTION NEXT QUESTION

In the cell B1 of the Total worksheet insert the appropriate function to sum up the cells within the cell range A1:A10 from the FF1 worksheet through to the FF12 worksheet.

Insert in the cell B2 a function that returns the average of the respective cell range, in cell B3 for the minimum, in cell B4 for the maximum and in cell B5 for the total of cells displaying numbers, following the same pattern.

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365

 

 

 


In the cell B1 of the Total worksheet insert the appropriate function to sum up the cells within the cell range A1:A10 from the FF1 worksheet through to the FF12 worksheet.
Insert in the cell B2 a function that returns the average of the respective cell range, in cell B3 for the minimum, in cell B4 for the maximum and in cell B5 for the total of cells displaying numbers, following the same pattern.