Microsoft Excel Exercise #2

  Home   Excel Quiz Three | Search |

code y3t1- 02 

Science Graduates Worksheet
A B C D E F
5   Total                
1    2001    2002    2003    Total    %   
2 Chemistry 100 75 65          
3 Biology 40 50 70          
4 Physics 25 15 5          

The worksheet above indicates the number of science graduates from a college during the period : 2001 - 2003

  1) How many rows are displayed above?

  2) How many columns are displayed above?

  3) In which cell is Biology Graduates for 2002 recorded?

  4)The range   A2 : A5    contains    labels values formulae

  5) The range   B4 :D4    contains    labels values formulae

  6) What is the range of cells which displays the number of graduates for Physics for the three years ?

  7) Enter a formula in cell E2 to calculate the number of Chemistry graduates for the three years

  8) The value in C4 is changed to 20. What two cells will change (separate your answers with a comma only - E5 contains no data )