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
| Function | Meaning |
|---|---|
| PMT | Per Month Instalment |
| IPMT | Per Month Interest |
| PPMT | Per 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.
| Function | Formula | Result |
|---|---|---|
| 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.
| Year | DB |
|---|---|
| 1 | 6,380.00 |
| 2 | 4,344.78 |
| 3 | 2,958.80 |
| 4 | 2,014.94 |
| 5 | 1,372.17 |
| 6 | 934.45 |
| Total | 18,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.
| Name | First name | Last name |
|---|---|---|
| Suraj kumar | suraj | kumar |
| Ajay Verma | ||
| Shahanawaz Abbasi | ||
| Meena Rani | ||
| Riya Tyagi | ||
| Pinki | ||
| Shife Choudhary | ||
| Mona Pal | ||
| Manoj kumar |
Free study material for Computer Science
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
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.