Activity 4
numbers.xlsx | |
File Size: | 9 kb |
File Type: | xlsx |
- Download the worksheet Numbers above.
- Move to cell A102, type Count.
- Move to cell B102, click the Insert Function button. From the Statistical category. select COUNT and click OK.
- For Value1 enter the range B1:B100. Click OK.
- Find the cell that has the missing number enter 23.
- In cell A103 type Average.
- Move to cell B103, click the Insert Function button. From the Statistical category. select AVERAGE and click OK.
- For Value1 enter the range B1:B100. Click OK.
- Move back to the top of the worksheet and in cell D11 type Count. In D12 type CountA.
- In E11, insert a function to count the number of numeric cells in the range E1:E9.
- In cell A104 enter the text Max. Move to cell B104 and insert the function Max from the Statistical group. Enter the range B1:B100 and click OK.
- In cell A105 enter the text Min. Move to cell B105 and insert the function Min from the Statistical group. Enter the range B1:B100 and click OK.
- Change the contents of cell B100 to 201.
- In cell D17 enter your name.
- In Cell D18 enter your class M3 - ?.
- Print 1 page Select printer option with scaling - all rows on 1 page.