In the excell enviroment we can use arithmetic operations/numeric functions to
perform calculations
they include addition, subtraction, multiplication,division, sum, average, maximum,
minimum, count
This done by enetering Formulaes
Use the following data and use the formulaes to make a reporst
John Assingment 1 40/50 Assingment 2 16/20 T0TAL (Calulate/100)
Peter Assingment 1 30/50 Assingment 2 8/20 T0TAL (Calulate/100)
Mary Assingment 1 25/50 Assingment 2 10/20 T0TAL (Calulate/100)
Jane Assingment 1 45/50 Assingment 2 18/20 T0TAL (Calulate/100)
Average (Calculate) (Calculate) (Calculate)
Maximum (Calculate) (Calculate) (Calculate)
Minimum (Calculate) (Calculate) (Calculate)
Determine the class average score for Assigment1, Assignment2 and the Total
Identify the highest and the lowest score in each task.(Hint use =MAX(cell1, cell2...) and =MIN(cell1, cell2...)
Send you attached spreadsheeet to gioko@akam.ac.ke
No comments:
Post a Comment