You want to apply subtotals per sport in the data below. What should you do before applying subtotals?

If the worksheet below, you want to use Data > Subtotal to show a subtotal value per sport. What must you do BEFORE applying the Subtotal function?If the worksheet below, you want to use Data > Subtotal to show a subtotal value per sport. What must you do BEFORE applying the Subtotal function?

READ MOREREAD MORE

Which format setting does not change the background appearance of a cell?Which format setting does not change the background appearance of a cell?

READ MOREREAD MORE

Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?

READ MOREREAD MORE