Advanced Excel Course Maths and Trig Functions Notes Set 01

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 NameHindiEnglishMathsComputerScienceTotal Marks
Mahin Alam8978428954352
Jitender Singh7059586558310
Dennis Ritchie5080858950354
Sakshi Thakur8445362465254
Haider Ali8584248547325
Ziya Naqvi7891504258319
Amit Tyagi5665653267285
Ajay Singh8550596152307
Devid Kumar7162252332213
John Stephen4647428965289

PRODUCT

=PRODUCT(B2:C2)

Multiplies the numbers of the range. Total Amount = Quantity multiplied by Rate.

Fruits NameQuantityRateTotal Amount
Apple50854250
Orange80302400
Pineapple25651625
Litchi40602400
Grapes1240480
Guava1025250
Kiwi20851700

ROUND

=ROUND(A2,2)

Rounds a number to the stated number of decimal places (here 2).

RupeesRound
25.65225.65
75.5375.53
80.44380.44
90.990.9
100.77100.77
1800.5311800.53
1259.61259.6
1999.551999.55
1589.781589.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).

NumberODDEVEN
111112
121312
191920
252526
282928
161716
171718
343534
555556

POWER and SQRT

=POWER(D2,2)
=SQRT(D2)

POWER raises a number to a power (here the square). SQRT gives the square root.

NUMBERPOWERNUMBERSQRT
525255
636366
749497
864129636
98193
10100103.1623
1214414412
2562522515
14196648

LCM

=LCM(A2:C2)

Returns the least common multiple of the numbers.

NUMBERNUMBERNUMBERLCM
36918
24612
121918684
115271485
25910450
2215134290
987504
5101530
152535525

GCD (Greatest Common Divisor)

=GCD(A2:C2)

Returns the greatest common divisor of the numbers.

NUMBERNUMBERNUMBERGCD
3693
2462
1219181
115271
259101
2215131
9871
510155
1525355

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.

DATEITEM NAMESQTY
10-01-21COMPUTER10
10-02-21PRINTER15
10-03-21LAPTOP73
10-04-21LAPTOP20
10-05-21COMPUTER32
10-06-21C.P.U18
10-07-21CHAIR14
10-08-21PRINTER16
10-09-21T.V.65
10-10-21TABLE30
10-11-21REFRIGERATOR10
10-12-21CHAIR23
10-13-21KEYBOARD25
10-14-21A.C60
10-15-21C.P.U5
ITEMTOTAL ITEM PURCHASE
COMPUTER42
PRINTER31
LAPTOP93
C.P.U23
CHAIR37
T.V.65
TABLE30
REFRIGERATOR10
KEYBOARD25
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.

NAMEUNITPRICE
CPU4250
MOUSE4350
LED10300
KEYBOARD2150
MONITOR8200
COMPUTER10170
DVD1870
TOTAL561490

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).

NAMEUNITPRICEPRODUCT
CPU4250=B2*C2 (1000)
MOUSE4350=B3*C3 (1400)
LED10300=B4*C4 (3000)
KEYBOARD2150=B5*C5 (300)
MONITOR8200=B6*C6 (1600)
COMPUTER10170=B7*C7 (1700)
DVD1870=B8*C8 (1260)
SUMPRODUCT=SUMPRODUCT(B2:B8,C2:C8)=SUM(D2:D8)

Both formulas give 10260.

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

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.