0% found this document useful (0 votes)
143 views6 pages

Student Scores and Rankings

The document shows the test scores of 9 students in different subjects and their rankings, with Paul having the highest average of 78.25. It also contains a table showing monthly sales figures for the year with the highest being $25,900 in August. The bar chart visualizes the monthly sales data, with a peak in August and generally higher sales from April to September.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
143 views6 pages

Student Scores and Rankings

The document shows the test scores of 9 students in different subjects and their rankings, with Paul having the highest average of 78.25. It also contains a table showing monthly sales figures for the year with the highest being $25,900 in August. The bar chart visualizes the monthly sales data, with a peak in August and generally higher sales from April to September.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

S/N NAME AGE MATHEMATICS ENGLISH BIOLOGY PHYSICS TOTAL AVERAGE

10 ETTA 17 60 68 70 59 257 64.25


1 JOHN 16 72 68 81 70 291 72.75
2 MARY 18 80 70 58 76 284 71
3 PAUL 19 69 75 83 86 313 78.25
4 JOY 17 71 82 90 78 321 80.25
5 PETER 15 69 74 80 85 308 77
6 JAMES 16 73 81 81 83 318 79.5
7 VERA 17 89 86 83 86 344 86
8 FAVOUR 17 56 59 85 58 258 64.5
9 CLETUS 18 54 60 73 57 244 61

PAULS AVERAGE
78.25 78.25
POSITION
10th
1ST
2nd
3rd
4th
5th
6th
7th
8th
9th
NUMBERS ERRORS
14 Err:509
78 #DIV/0!
25 #VALUE!
0 #NAME?
54 ###
75
1 2 3 4 5 6 7 8 9
1 1 2 3 4 5 6 7 8 9
2 2 4 6 8 10 12 14 16 18
3 3 6 9 12 15 18 21 24 27
4 4 8 12 16 20 24 28 32 36
5 5 10 15 20 25 30 35 40 45
6 6 12 18 24 30 36 42 48 54
7 7 14 21 28 35 42 49 56 63
8 8 16 24 32 40 48 56 64 72
9 9 18 27 36 45 54 63 72 81
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT
1000 1000 1000 18000 4700 3500 6000 25900 8000 4000

30000

25000

20000

15000

10000

5000

0
JAN FEB MAR APR MAY JUN JUL AUG SEP O
NOV DEC
3000 2000

Row 2

APR MAY JUN JUL AUG SEP OCT NOV DEC

You might also like