Computer Science Study Guide: Advanced Excel Course Maths and Trig Functions Notes Set 01
Explore structured advanced study materials through the Advanced Excel Course Maths and Trig Functions Notes Set 01. Tailored for learners, utilizing these Computer Science resources ensures thorough preparation and strengthens foundational knowledge before final evaluations.
Download MS Office Study Material PDF
View or download the dedicated Advanced Excel Course Maths and Trig Functions Notes Set 01 resource below. Engaging with these advanced study guides under focused conditions ensures continuous academic progress and mastery of the 2026-27 curriculum for MS Office.
Worked examples of the commonly used mathematical functions are collected here: SUM, PRODUCT, ROUND, ODD and EVEN, POWER and SQRT, LCM, GCD, SUMIF, SUBTOTAL and SUMPRODUCT, with the sample numbers, formulas and results.
SUM
=SUM(B2:F2)
Adds the numbers of a range. In the marks sheet the total of Hindi, English, Maths, Computer and Science for each student is found in the Total Marks column.
| Students Name | Hindi | English | Maths | Computer | Science | Total Marks |
|---|---|---|---|---|---|---|
| Mahin Alam | 89 | 78 | 42 | 89 | 54 | 352 |
| Jitender Singh | 70 | 59 | 58 | 65 | 58 | 310 |
| Dennis Ritchie | 50 | 80 | 85 | 89 | 50 | 354 |
| Sakshi Thakur | 84 | 45 | 36 | 24 | 65 | 254 |
| Haider Ali | 85 | 84 | 24 | 85 | 47 | 325 |
| Ziya Naqvi | 78 | 91 | 50 | 42 | 58 | 319 |
| Amit Tyagi | 56 | 65 | 65 | 32 | 67 | 285 |
| Ajay Singh | 85 | 50 | 59 | 61 | 52 | 307 |
| Devid Kumar | 71 | 62 | 25 | 23 | 32 | 213 |
| John Stephen | 46 | 47 | 42 | 89 | 65 | 289 |
PRODUCT
=PRODUCT(B2:C2)
Multiplies the numbers of the range. Total Amount = Quantity multiplied by Rate.
| Fruits Name | Quantity | Rate | Total Amount |
|---|---|---|---|
| Apple | 50 | 85 | 4250 |
| Orange | 80 | 30 | 2400 |
| Pineapple | 25 | 65 | 1625 |
| Litchi | 40 | 60 | 2400 |
| Grapes | 12 | 40 | 480 |
| Guava | 10 | 25 | 250 |
| Kiwi | 20 | 85 | 1700 |
ROUND
=ROUND(A2,2)
Rounds a number to the stated number of decimal places (here 2).
| Rupees | Round |
|---|---|
| 25.652 | 25.65 |
| 75.53 | 75.53 |
| 80.443 | 80.44 |
| 90.9 | 90.9 |
| 100.77 | 100.77 |
| 1800.531 | 1800.53 |
| 1259.6 | 1259.6 |
| 1999.55 | 1999.55 |
| 1589.78 | 1589.78 |
ODD and EVEN
=ODD(C2) =EVEN(C2)
ODD rounds a number up to the nearest odd integer and EVEN rounds it up to the nearest even integer (an even number stays unchanged under EVEN, an odd number stays unchanged under ODD).
| Number | ODD | EVEN |
|---|---|---|
| 11 | 11 | 12 |
| 12 | 13 | 12 |
| 19 | 19 | 20 |
| 25 | 25 | 26 |
| 28 | 29 | 28 |
| 16 | 17 | 16 |
| 17 | 17 | 18 |
| 34 | 35 | 34 |
| 55 | 55 | 56 |
POWER and SQRT
=POWER(D2,2) =SQRT(D2)
POWER raises a number to a power (here the square). SQRT gives the square root.
| NUMBER | POWER | NUMBER | SQRT |
|---|---|---|---|
| 5 | 25 | 25 | 5 |
| 6 | 36 | 36 | 6 |
| 7 | 49 | 49 | 7 |
| 8 | 64 | 1296 | 36 |
| 9 | 81 | 9 | 3 |
| 10 | 100 | 10 | 3.1623 |
| 12 | 144 | 144 | 12 |
| 25 | 625 | 225 | 15 |
| 14 | 196 | 64 | 8 |
LCM
=LCM(A2:C2)
Returns the least common multiple of the numbers.
| NUMBER | NUMBER | NUMBER | LCM |
|---|---|---|---|
| 3 | 6 | 9 | 18 |
| 2 | 4 | 6 | 12 |
| 12 | 19 | 18 | 684 |
| 11 | 5 | 27 | 1485 |
| 25 | 9 | 10 | 450 |
| 22 | 15 | 13 | 4290 |
| 9 | 8 | 7 | 504 |
| 5 | 10 | 15 | 30 |
| 15 | 25 | 35 | 525 |
GCD (Greatest Common Divisor)
=GCD(A2:C2)
Returns the greatest common divisor of the numbers.
| NUMBER | NUMBER | NUMBER | GCD |
|---|---|---|---|
| 3 | 6 | 9 | 3 |
| 2 | 4 | 6 | 2 |
| 12 | 19 | 18 | 1 |
| 11 | 5 | 27 | 1 |
| 25 | 9 | 10 | 1 |
| 22 | 15 | 13 | 1 |
| 9 | 8 | 7 | 1 |
| 5 | 10 | 15 | 5 |
| 15 | 25 | 35 | 5 |
SUMIF
=SUMIF(B3:B17,B3,C3:C17)
Adds the quantities of those rows whose item name matches the criteria. In the purchase list the date, item name and quantity are given for 15 purchases, and the total purchase of each item is found with SUMIF.
| DATE | ITEM NAMES | QTY |
|---|---|---|
| 10-01-21 | COMPUTER | 10 |
| 10-02-21 | PRINTER | 15 |
| 10-03-21 | LAPTOP | 73 |
| 10-04-21 | LAPTOP | 20 |
| 10-05-21 | COMPUTER | 32 |
| 10-06-21 | C.P.U | 18 |
| 10-07-21 | CHAIR | 14 |
| 10-08-21 | PRINTER | 16 |
| 10-09-21 | T.V. | 65 |
| 10-10-21 | TABLE | 30 |
| 10-11-21 | REFRIGERATOR | 10 |
| 10-12-21 | CHAIR | 23 |
| 10-13-21 | KEYBOARD | 25 |
| 10-14-21 | A.C | 60 |
| 10-15-21 | C.P.U | 5 |
| ITEM | TOTAL ITEM PURCHASE |
|---|---|
| COMPUTER | 42 |
| PRINTER | 31 |
| LAPTOP | 93 |
| C.P.U | 23 |
| CHAIR | 37 |
| T.V. | 65 |
| TABLE | 30 |
| REFRIGERATOR | 10 |
| KEYBOARD | 25 |
| A.C. | 60 |
SUBTOTAL
=SUBTOTAL(9,G3:G9) =SUBTOTAL(9,H3:H9)
SUBTOTAL calculates a total of a filtered list. Its first argument, function_num, selects the calculation. When the function is typed, Excel shows the list of function numbers: 2 - COUNT, 3 - COUNTA, 4 - MAX, 5 - MIN, 6 - PRODUCT, 7 - STDEV.S, 8 - STDEV.P, 9 - SUM, 10 - VAR.S, 11 - VAR.P, 101 - AVERAGE and so on. In the example the NAME, UNIT and PRICE columns have filter buttons and the TOTAL row uses SUBTOTAL(9,...) so that only the visible rows are added.
| NAME | UNIT | PRICE |
|---|---|---|
| CPU | 4 | 250 |
| MOUSE | 4 | 350 |
| LED | 10 | 300 |
| KEYBOARD | 2 | 150 |
| MONITOR | 8 | 200 |
| COMPUTER | 10 | 170 |
| DVD | 18 | 70 |
| TOTAL | 56 | 1490 |
SUMPRODUCT
=SUMPRODUCT(B2:B8,C2:C8)
SUMPRODUCT multiplies the matching numbers of two ranges and adds the products. The same result is obtained by calculating UNIT multiplied by PRICE in column D (=B2*C2 and so on) and adding with =SUM(D2:D8).
| NAME | UNIT | PRICE | PRODUCT |
|---|---|---|---|
| CPU | 4 | 250 | =B2*C2 (1000) |
| MOUSE | 4 | 350 | =B3*C3 (1400) |
| LED | 10 | 300 | =B4*C4 (3000) |
| KEYBOARD | 2 | 150 | =B5*C5 (300) |
| MONITOR | 8 | 200 | =B6*C6 (1600) |
| COMPUTER | 10 | 170 | =B7*C7 (1700) |
| DVD | 18 | 70 | =B8*C8 (1260) |
| SUMPRODUCT | =SUMPRODUCT(B2:B8,C2:C8) | =SUM(D2:D8) |
Both formulas give 10260.
Free study material for Computer Science
Computer Science Exam Resources: MS Office
Quick Revision Material for MS Office
Review targeted study resources for MS Office tailored for learners. Utilizing these structured notes and quick-revision tools ensures complete alignment with current CBSE evaluation standards.
Expert Notes and Solved Exam Questions
Built using official NCERT guidelines for Computer Science, these materials provide reliable academic support. Integrating past examination questions and step-by-step solutions helps students understand official CBSE grading criteria.
Additional Study Resources for
Maximize your grade potential by utilizing Computer Science practice papers in tandem with these structured notes. All printable assignments and interactive mock tests on our platform are updated for the 2026 session and available free of charge.
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.