Question: Write an Excel function or functions and cell stats! B3, which can be copied down the column and across the row to sell stats! C7,
Write an Excel function or functions and cell stats! B3, which can be copied down the column and across the row to sell stats! C7, that will calculate the average hours exercise based on the corresponding age and gender combination, for example cell stats! B3, the formula should calculate the average number of hours exercise by males in the 18 to 21 age category when copied across the cell stats! C3 it should calculate the average number of hours exercise by females in the 18 to 21 age category
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
