Microsoft Excel Exercise #3

Enter Here | Search |

code y3t1- 03

Excel Wages Worksheet
A B C D E F
8             TOTAL  
1    Week 1    Week 2    Week 3    Week 4    Staff Total   
2 Ames S 145 235 175 195     
3 Atwell W 325 350 295 260     
4 Ling T 245 285 355 240     
5 Patel J 300 350 295 250     
6 Rajpaul F 325 350 295 260     
7 Smart N 300 285 295 295     

All questions relate to the payroll worksheet displayed above

1) How many rows are displayed above?

2) How many columns are displayed above?

3) In which cell is Ling's wages for the third week recorded?

4)The range   B1 : F1    contains    labels values formulae

5) The range   C2 :C7    contains    labels values formulae

6) What is the range of cells which contains the staff wages for WEEK 3?

7) Enter a formula in cell F5 to calculate the total earned by Patel for the four weeks.

8) Enter a formula in cell F8 to calculate the total earned by all staff.