Download Computer Science Useful Resources
Access comprehensive study materials and useful resources for MS Office using the Advanced Excel Course Statistical Function Notes Set 01. Designed to align with the 2026-27 academic guidelines, these advanced resources help Computer Science students reinforce core concepts beyond standard textbooks.
Access Study Guides and Summaries
Access the complete useful resource PDF for Computer Science below. Regular practice with these targeted academic notes builds familiarity with complex topics and helps secure higher marks in final school evaluations.
Statistical functions are shown on student result sheets and small lists: AVERAGE, MAX and MIN, COUNT, COUNTA, COUNTBLANK, LARGE, SMALL, MEDIAN and COUNTIF, each with its formula and the result of the worked example.
AVERAGE, MAX, MIN
=SUM(B4:F4) =MAX(B4:F4) =MIN(B4:F4) =AVERAGE(B4:F4)
The Results sheet has the marks in Hindi, English, Computer, Maths and Science of ten students, followed by the columns Total, Max, Min and Average.
| Student Names | Hindi | English | Computer | Maths | Science | Total | Max | Min | Average |
|---|---|---|---|---|---|---|---|---|---|
| Zainab Rizvi | 78 | 54 | 58 | 23 | 23 | 236 | 78 | 23 | 47.2 |
| Amit Tyagi | 89 | 59 | 94 | 25 | 22 | 289 | 94 | 22 | 57.8 |
| Shahid Kapoor | 78 | 56 | 54 | 65 | 32 | 285 | 78 | 32 | 57 |
| Dennis Ritchie | 96 | 84 | 62 | 45 | 42 | 329 | 96 | 42 | 65.8 |
| Nusbeeha Naqvi | 56 | 78 | 45 | 52 | 23 | 254 | 78 | 23 | 50.8 |
| James Thomas | 95 | 61 | 65 | 20 | 52 | 293 | 95 | 20 | 58.6 |
| Eli Christian | 63 | 59 | 74 | 55 | 35 | 286 | 74 | 35 | 57.2 |
| Jameson | 56 | 69 | 21 | 23 | 35 | 204 | 69 | 21 | 40.8 |
| Ravi Kumar | 65 | 89 | 23 | 23 | 62 | 262 | 89 | 23 | 52.4 |
| Shivi Singh | 79 | 45 | 80 | 34 | 45 | 283 | 80 | 34 | 56.6 |
COUNT
=COUNT(B2:B11)
COUNT counts only the cells that contain numbers. In the student list the Student Names column and the Roll No column (DI245, DI246 ...) contain text, so COUNT gives 0 for them. The counts of the other columns are:
| S N Count | R N Count | Hindi Count | Eng Count | Computer Count | Maths Count | Science Count |
|---|---|---|---|---|---|---|
| 0 | 0 | 10 | 10 | 8 | 10 | 10 |
The Computer count is 8 because two Computer cells are empty.
COUNTA
=COUNTA(B2:B11)
COUNTA counts all the cells that are not empty, whether they contain numbers or text. In the same kind of student list, where some name and mark cells are empty, the counts are:
| S N Counta | R N Counta | Hindi Counta | Eng Counta | Computer Counta | Maths Counta | Science Counta |
|---|---|---|---|---|---|---|
| 10 | 10 | 9 | 9 | 10 | 10 | 10 |
COUNTBLANK
=COUNTBLANK(B2:B11)
COUNTBLANK counts the empty cells of a range. In a list of ten students with missing entries the blank cells counted are:
| S N CB | Hindi CB | Eng CB | Computer CB | Maths CB | Science CB |
|---|---|---|---|---|---|
| 4 | 3 | 4 | 2 | 3 | 4 |
LARGE
=LARGE(B2:E2,2)
LARGE returns the k-th largest value of a range. Here k = 2, the second largest of the four marks of each student.
| Name | English | Maths | Hindi | Computer | Large |
|---|---|---|---|---|---|
| Sita | 12 | 25 | 35 | 44 | 35 |
| Geeta | 14 | 12 | 36 | 10 | 14 |
| Monika | 85 | 13 | 15 | 36 | 36 |
| Priya | 20 | 58 | 34 | 25 | 34 |
| Minakshi | 11 | 41 | 63 | 14 | 41 |
| Suraj | 30 | 14 | 7 | 28 | 28 |
| Mohan | 10 | 16 | 15 | 39 | 16 |
| Ajay | 35 | 87 | 96 | 40 | 87 |
SMALL
=SMALL(B2:E2,2)
SMALL returns the k-th smallest value of a range. Here k = 2, the second smallest mark of each student.
| Name | English | Maths | Hindi | Computer | Small |
|---|---|---|---|---|---|
| Sita | 12 | 25 | 35 | 44 | 25 |
| Geeta | 14 | 12 | 36 | 10 | 12 |
| Monika | 85 | 13 | 15 | 36 | 15 |
| Priya | 20 | 58 | 34 | 25 | 25 |
| Minakshi | 11 | 41 | 63 | 14 | 14 |
| Suraj | 30 | 14 | 7 | 28 | 14 |
| Mohan | 10 | 16 | 15 | 39 | 15 |
| Ajay | 35 | 87 | 96 | 40 | 40 |
MEDIAN
=MEDIAN(A2:B2)
MEDIAN returns the middle value of the numbers (for two numbers, the value halfway between them).
| Number | Number | Median |
|---|---|---|
| 10 | 20 | 15 |
| 60 | 40 | 50 |
| 15 | 15 | 15 |
| 25 | 25 | 25 |
| 20 | 30 | 25 |
| 60 | 10 | 35 |
| 20 | 40 | 30 |
| 16 | 18 | 17 |
| 12 | 28 | 20 |
COUNTIF
=COUNTIF(A2:A10,"Apple")
COUNTIF counts the cells of a range that meet one condition. The fruit list has the columns Fruits name, Qty and Rate; the formula counts how many times Apple appears.
| Fruits name | Qty | Rate |
|---|---|---|
| Apple | 50 | 25 |
| Mango | 10 | 12 |
| Apple | 20 | 13 |
| Pear | 40 | 15 |
| Apple | 50 | 16 |
| Mango | 10 | 18 |
| Pear | 40 | 26 |
| Apple | 20 | 28 |
| Mango | 10 | 17 |
Result: Apple 4 and Mango 3. In the same way the formula with Pear as the condition counts the two Pear rows of the list.
Free study material for Computer Science
Computer Science Exam Resources: MS Office
Quick Revision Material for MS Office
Explore essential learning tools for Computer Science MS Office. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.
Expert Notes and Solved Exam Questions
Each resource draws directly from authorized textbooks to maintain academic accuracy. Evaluating solved examples allows students to master the formal presentation and answer-writing standards expected in upcoming school exams.
Additional Study Resources for
For peak performance in upcoming evaluations, integrate official Computer Science sample papers directly into your study schedule. Follow up your revision by attempting online MCQ tests for MS Office to refine calculation speed and precision.
FAQs
The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.
Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.
Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.
in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.