1) How many rows are displayed above?

2) How many columns are displayed above?

3) In which cell is John's runs recorded?

4)The range   B1 : E1    contains    labels values formulae

5) The range   C2 :C7    contains    labels values formulae

6) What function should you place in B9 to get total runs for the club?

7) Enter a formula in cell D3 to calculate the strike rate of REID

     Strike Rate = runs scored divided by balls faced multiplied by 100

8) Enter a formula in cell E3 to calculate the percentage of total runs scored for REID.

     % runs scored = the runs scored by that player divided by the Total Runs Scored

9) Cell   $B$9    is an example of a    relative cell address absolute cell address simple cell address

10) Create the   Scorecard    using a spreadsheet application and save it as : scorecard 2023 . Use formulae ONLY in the range D2 to E7. When referencing cell B9 use absolute cell reference at all times.