Official Study Materials for Computer Science
Access comprehensive study materials and useful resources for MS Office using the Advanced Excel Course Lookup and Reference 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.
Advanced Resources for Computer Science
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.
The lookup functions VLOOKUP and HLOOKUP are explained with an employee table and a salesman sales table, followed by MATCH and the INDEX with MATCH combination used to fetch a person's address from a list.
VLOOKUP
VLOOKUP searches for a value in the first column of a table and returns a value from the stated column of the same row. The arguments are lookup value, table range, column number and 0 (exact match).
| ID No | First Name | Last Name | Division | Monthly Salary |
|---|---|---|---|---|
| AB1234 | Mohd | Haider | CEO | 80000 |
| BC42345 | Harper | Williams | Marketing | 23000 |
| CD13456 | Dennis | Ritchie | Accounting | 26000 |
| DE4567 | Thomas | Smith | Sales | 21000 |
| EF5678 | Brown | Jones | Research | 30000 |
| FG6789 | Jackson | Davis | Accounting | 26000 |
| GH78910 | Alam | Zaidi | CA | 32000 |
| HI891011 | Miller | Taylor | Sales | 21000 |
| IJ9101112 | Ankit | Singh | Research | 30000 |
| KL111213 | Jones | Anderson | Sales | 21000 |
A second block with the headings ID No, First Name, Last Name, Division and Monthly Salary shows the ID numbers HI891011, BC42345, GH78910, KL111213 and EF5678 in column A. The other four columns are filled with VLOOKUP formulas that use column numbers 2, 3, 4 and 5.
=VLOOKUP(A15,A1:E11,2,0) First Name =VLOOKUP(A15,A1:E11,3,0) Last Name =VLOOKUP(A15,A1:E11,4,0) Division =VLOOKUP(A15,A1:E11,5,0) Monthly Salary
HLOOKUP
HLOOKUP searches for a value in the first row of a table and returns a value from the stated row of the same column. The table has the names of nine salesmen across the top (RAVI, RAJU, AMIT, VINOD, MAYANK, DENNIS, ROHIT, SHUBHAM, MANISH) and the four months JAN, FEB, MAR and APR down the first column.
| NAME OF SALESMAN | RAVI | RAJU | AMIT | VINOD | MAYANK | DENNIS | ROHIT | SHUBHAM | MANISH |
|---|---|---|---|---|---|---|---|---|---|
| JAN | 308 | 495 | 466 | 255 | 440 | 314 | 399 | 283 | 493 |
| FEB | 351 | 479 | 461 | 276 | 357 | 404 | 290 | 272 | 353 |
| MAR | 456 | 422 | 279 | 348 | 305 | 330 | 485 | 492 | 464 |
| APR | 392 | 439 | 489 | 492 | 475 | 322 | 299 | 319 | 410 |
=HLOOKUP(A10,A2:J6,2,0) MANISH, JAN
=HLOOKUP(A10,A2:J6,3,0) MANISH, FEB
=HLOOKUP(A10,A2:J6,4,0) MANISH, MAR
=HLOOKUP(A10,A2:J6,5,0) MANISH, APR
=HLOOKUP("DENNIS",A2:J6,2,0) DENNIS, JANThe row numbers 2, 3, 4 and 5 are counted from the first row of the table range (the row with the salesmen names).
MATCH
=MATCH(A8,A2:A10,0)
MATCH returns the position of a value in a list. The list A2:A10 holds the names Ram, Mohan, Ram, Bablu, Ram, Teena, Reena, Mohan and Pinki; the value in A8 (Reena) is the 7th item of the list, so the result is 7.
INDEX with MATCH
=INDEX(A3:D11,MATCH(F5,B3:B11,0),4)
INDEX returns the value found at a given row and column of a range. MATCH finds the row number of the name and 4 is the column number of Address. The sheet has the columns ID, Name, Age and Address; typing the name Mohan in F5 gives its address in G5.
| ID | Name | Age | Address |
|---|---|---|---|
| 3429 | Mohan | 24 | Agra |
| 2826 | Rohan | 22 | Mathura |
| 1833 | Shyam | 18 | Aligarh |
| 5207 | Geeta | 20 | Agra |
| 6040 | Savita | 19 | Mathura |
| 6713 | Mohit | 21 | Aligarh |
| 374 | Madhav | 18 | Agra |
| 2467 | Shalini | 22 | Mathura |
| 1383 | Shruti | 23 | Aligarh |
Result for Mohan: Agra.
Free study material for Computer Science
CBSE Computer Science Study Material: 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
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.