0% found this document useful (0 votes)
20 views14 pages

Excel Practice Set

excel simple practice

Uploaded by

singhsanket979
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)
20 views14 pages

Excel Practice Set

excel simple practice

Uploaded by

singhsanket979
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
You are on page 1/ 14

STUDENT DASHBOARD

Class AVERAGE MARKS Aditya Amit Anjali


10A 79 1 1
1 1 Arjun Isha Karan
10B 77.8 1 1
1 1 Kavya Manish Meera
10C 77.6
10D 79.4 1 1 Neha Pooja Priya

This shape represents a 1 1 Rahul Ravi Rohan


slicer. Slicers are Siddharth Simran Sneha
1 1
supported in Excel
2010 or later. 1 1 Tanvi Vikram
1 1
1 1
If the shape was
modified in an earlier
version of Excel, or if
the workbook was
saved in Excel 2003 or
earlier, the slicer
cannot be used.
NT DASHBOARD
PASS

25% 25%
10A
10B
10C
10D

25% 25%
Class Average of Marks
10A 79
10B 77.8
10C 77.6
10D 79.4

CLASS VS AVERAGE OF MARKS

79.4
79 Averag

77.8
77.6

10A 10B 10C 10D


VERAGE OF MARKS

79.4
Average of Marks

77.6

10C 10D
Class Name TOP OF THE CLASS
10A Sneha 92
10B Arjun 95
10C Siddharth 91
10D Kavya 94
GROUP ATTENDANCE Average of Marks
70–80 58
81–90 72.777777777778
91–100 88.666666666667
student PASS /FAIL
Class PASS
10A 5
10B 5
PASS
10C 5
10D 5

25% 25%
10A
10B
10C
10D

25% 25%
10A
10B
10C
10D
Class NUMBER OF STUDENT
10A 5
10B 5
10C 5
10D 5
Name ATTENDANCE%
Aditya 84
Amit 90 Total
Anjali 92
120
Arjun 97
Isha 93 100 97 99 96 98
95
Karan 76 90 92 93 91 94 90 88
84 86 87 85 85
80 79 82
Kavya 99 76
Manish 86 60
ATTENDANC
Meera 91
Neha 94 40
Pooja 79
20
Priya 95
Rahul 87 0
a li a ya ra a l n n i
Ravi 85 ity ja Ish Kav ee oj hu ha mra nv
A d A n
M Po R a
Ro i Ta
Rohan 85 S
Siddharth 96
Simran 82
Sneha 98
Tanvi 90
Vikram 88
90 88

ATTENDANCE%

i
nv
Name Count of PASS /FAIL
Aditya 1
Amit 1
Total
Anjali 1 Aditya Amit A
Arjun 1
Isha 1 Arjun Isha K
Karan 1
Kavya 1 Kavya Manish M
Manish 1
Meera 1 Neha Pooja P
Neha 1
Pooja 1 Rahul Ravi R
Priya 1
Rahul 1 Siddharth Simran S
Ravi 1
Rohan 1 Tanvi Vikram
Siddharth 1
Simran 1
Sneha 1
Tanvi 1
Vikram 1
Aditya Amit Anjali

Arjun Isha Karan

Kavya Manish Meera

Neha Pooja Priya

Rahul Ravi Rohan

Siddharth Simran Sneha

Tanvi Vikram
Student ID Name Class Marks Attendance % GROUP ATTENDANCE PASS /FAIL
S001 Amit 10A 78 90 81–90 PASS
S002 Priya 10A 85 95 91–100 PASS
S003 Rohan 10A 66 85 81–90 PASS
S004 Sneha 10A 92 98 91–100 PASS
S005 Vikram 10A 74 88 81–90 PASS
S006 Anjali 10B 81 92 91–100 PASS
S007 Karan 10B 56 76 70–80 PASS
S008 Neha 10B 89 94 91–100 PASS
S009 Arjun 10B 95 97 91–100 PASS
S010 Simran 10B 68 82 81–90 PASS
S011 Ravi 10C 72 85 81–90 PASS
S012 Meera 10C 88 91 91–100 PASS
S013 Siddharth 10C 91 96 91–100 PASS
S014 Pooja 10C 60 79 70–80 PASS
S015 Rahul 10C 77 87 81–90 PASS
S016 Isha 10D 83 93 91–100 PASS
S017 Aditya 10D 69 84 81–90 PASS
S018 Kavya 10D 94 99 91–100 PASS
S019 Manish 10D 71 86 81–90 PASS
S020 Tanvi 10D 80 90 81–90 PASS

You might also like