Advanced Excel Course Statistical Function Notes Set 01

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 NamesHindiEnglishComputerMathsScienceTotalMaxMinAverage
Zainab Rizvi7854582323236782347.2
Amit Tyagi8959942522289942257.8
Shahid Kapoor7856546532285783257
Dennis Ritchie9684624542329964265.8
Nusbeeha Naqvi5678455223254782350.8
James Thomas9561652052293952058.6
Eli Christian6359745535286743557.2
Jameson5669212335204692140.8
Ravi Kumar6589232362262892352.4
Shivi Singh7945803445283803456.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 CountR N CountHindi CountEng CountComputer CountMaths CountScience Count
00101081010

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 CountaR N CountaHindi CountaEng CountaComputer CountaMaths CountaScience Counta
101099101010

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 CBHindi CBEng CBComputer CBMaths CBScience CB
434234

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.

NameEnglishMathsHindiComputerLarge
Sita1225354435
Geeta1412361014
Monika8513153636
Priya2058342534
Minakshi1141631441
Suraj301472828
Mohan1016153916
Ajay3587964087

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.

NameEnglishMathsHindiComputerSmall
Sita1225354425
Geeta1412361012
Monika8513153615
Priya2058342525
Minakshi1141631414
Suraj301472814
Mohan1016153915
Ajay3587964040

MEDIAN

=MEDIAN(A2:B2)

MEDIAN returns the middle value of the numbers (for two numbers, the value halfway between them).

NumberNumberMedian
102015
604050
151515
252525
203025
601035
204030
161817
122820

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 nameQtyRate
Apple5025
Mango1012
Apple2013
Pear4015
Apple5016
Mango1018
Pear4026
Apple2028
Mango1017

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.

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

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

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.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

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.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

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.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

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.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

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.