Advanced Excel Course Financial Function Notes Set 01

Advanced Study Material for Computer Science: MS Office

Access comprehensive study materials and useful resources for MS Office using the Advanced Excel Course Financial 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.

Practice Computer Science Resources: MS Office

Navigate directly to the advanced Computer Science study materials using the digital viewer below. Each resource pack includes detailed conceptual summaries and solved practice questions, allowing students to instantly reinforce their learning.

Loan and depreciation calculations with the financial functions PMT, IPMT, PPMT and DB are shown on a loan of 100000 and a computer bought for 20000, and the page ends with the Flash Fill feature that splits a full name into first and last names.

PMT, IPMT and PPMT

FunctionMeaning
PMTPer Month Instalment
IPMTPer Month Interest
PPMTPer Month Principal

The loan sheet has the Loan Amount 100000 in B1, the Rate of Interest 14% in B2 and the Period of 4 years in B3. The rate is divided by 12 and the period is multiplied by 12 so that the calculation is done per month.

FunctionFormulaResult
PMT=PMT(B2/12,B3*12,B1)-2,732.65
IPMT (first month)=IPMT(B2/12,1,B3*12,B1)-1,166.67
PPMT (first month)=PPMT(B2/12,1,B3*12,B1)-1,565.98
IPMT + PPMT=D6+D7-2,732.65

The instalment of the first month is the sum of its interest and its principal part (-1,166.67 and -1,565.98 add up to the instalment of -2,732.65). The results are negative because they are payments.

DB Function

=DB($B$3,$C$3,$D$3,F3)

DB(cost, salvage, life, period) returns the depreciation of an asset for the given year by the fixed-declining balance method. The sheet has the Item Name Computer, the Cost 20000, the Salvage value 2000 and the life of 6 years.

YearDB
16,380.00
24,344.78
32,958.80
42,014.94
51,372.17
6934.45
Total18,005.14

Flash Fill

Flash Fill (Ctrl + E) fills a column by following the pattern that the user types in the first row. The sheet has the full names in column A; the first name (suraj) is typed in the first row of the First name column and the last name (kumar) in the first row of the Last name column. Pressing Ctrl + E in the next cell completes the remaining rows in the same pattern.

NameFirst nameLast name
Suraj kumarsurajkumar
Ajay Verma
Shahanawaz Abbasi
Meena Rani
Riya Tyagi
Pinki
Shife Choudhary
Mona Pal
Manoj kumar

Useful Resources and Notes for Computer Science MS Office

Core Study Kit: Computer Science 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.

NCERT-Aligned Solutions for MS Office

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.

Next Steps in Your Exam Preparation

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.