Question

Write formula to calculate the Total points (Sum of Points + Bonus) of each

player in cell F2 – F6.

(b) ​

Answer 1

maybe u r asking this question right

Answer 2

(a) First selection of  the cell F2-F6 after that click on auto sum button. or u following this rule: =sum(F2:F7)

(b) selection of  the cells of total then clicking  on data tab and then going on to  sort and filtering group and subsequently  click on short z to a icon.

(c) using of  the formula: =MAX ,selection  all cells of total,  then tab enter button of your keyboard

(d) using  the formula:=MIN , selection  all cells of total, then tab enter button of your keyboard .

(e) =AVARAGE, considering all cells of points to total and then tab on your enter key of your keyboard.