Microsoft Excel Exercise #1

  Home   Excel Quiz Two | Search |

code y3t1- 01 

Student Final Term Score Worksheet
A B C D E F G
6   Total                  
1    Test1    Test2    Test3    Paper    Final    %   
2 Out of 30 30 30 30    120    100%   
3 Matthew 20 10 0 10           
4 Mark 30 10 20 20           
5 Luke 20 30 0 10           

The worksheet above indicates Students test scores including Final Exam score for one term along with their percentages

  1) How many rows are displayed above?

  2) How many columns are displayed above?

  3) In which cell is Matthew's final mark recorded?

  4)The range   A2 : A5    contains    labels values formulae

  5) The range   B4 :E4    contains    labels values formulae

  6) If =F3/$F$2 is the formula to calculate Matthew's percentage what formula will you place in G4 for Mark ?

  7) Who got the highest mark for Test Two?

  8) If Matthew had scored 15 on his third test what would his final score have been?