Official Study Materials for Computer Science
Review targeted academic resources with the Advanced Excel Course Text Function Notes Set 01. Built according to official standards for the 2026-27 term, these downloadable Computer Science study materials support effective daily practice and deeper conceptual understanding for MS Office.
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.
Ten text functions of Excel are shown with worked examples: UPPER, LOWER, PROPER, TRIM, LEFT, MID, RIGHT, LEN, CONCATENATE and EXACT, each with its formula and a table of inputs and results.
Text Functions
Text functions change or pick parts of text. In every example below the formula is typed in the first cell of the result column and copied down.
UPPER
=UPPER(A2)
Converts all the letters of the text to capital letters.
| Name | Age | Upper |
|---|---|---|
| jOhn | 19 | JOHN |
| Smith | 16 | SMITH |
| Jackson | 18 | JACKSON |
| fisCHer | 16 | FISCHER |
| mahin Alam | 12 | MAHIN ALAM |
| emma | 12 | EMMA |
| aleXANder | 20 | ALEXANDER |
| Suzzane | 15 | SUZZANE |
| Peter | 19 | PETER |
| ColBy p Ford | 20 | COLBY P FORD |
LOWER
=LOWER(A2)
Converts all the letters of the text to small letters.
| Text | Lower |
|---|---|
| Document | document |
| INserT | insert |
| ALGORITHM | algorithm |
| Data Mining | data mining |
| FirEwall | firewall |
| Frequently | frequently |
| HACKER | hacker |
| backup | backup |
| APPLIcation | application |
| Notebook Computer | notebook computer |
PROPER
=PROPER(A2)
Changes the first letter of every word to a capital letter and the rest to small letters.
| Full Name | Proper |
|---|---|
| mr. Haider Ali | Mr. Haider Ali |
| MISS. OLIVIA | Miss. Olivia |
| Ram kumar singh | Ram Kumar Singh |
| Chhaya yadav | Chhaya Yadav |
| Anita singh yadav | Anita Singh Yadav |
| skylar rubY | Skylar Ruby |
| ALICE CORA | Alice Cora |
| MAhIN aLAM | Mahin Alam |
| shaziya zaidi | Shaziya Zaidi |
| shahban Abbas | Shahban Abbas |
TRIM
=TRIM(A2)
Removes the extra spaces from the text: the spaces before and after it, and all but one of the spaces between words.
| Title | Trim |
|---|---|
| The Shawshank Redemption (1994) | The Shawshank Redemption (1994) |
| The Godfather (1972) | The Godfather (1972) |
| The Godfather: Part 2nd (1972) | The Godfather: Part 2nd (1972) |
| Pulp Fiction (1994) | Pulp Fiction (1994) |
| The Good, The Bad and the Ugly (1966) | The Good, The Bad and the Ugly (1966) |
| 12 Angery Men (1957) | 12 Angery Men (1957) |
| Fight Club (1999) | Fight Club (1999) |
LEFT
=LEFT(A2,4)
Returns the stated number of characters from the left (start) of the text. The number of characters is the second argument and differs from row to row in this example.
| Names | Left |
|---|---|
| Syed Abid Ali | Syed |
| David Warner | David Warner |
| M.S Dhoni | M.S |
| Virat Kohli | Virat Ko |
| Adam Zampa | Adam Z |
| Ricky Ponting | Ric |
| Mohd Shami | Mohd |
| Josh Hazlewood | Josh Haz |
| Adil Rashid | Adi |
| Jonny Bairstow | Jonny Bair |
MID
=MID(A2,9,15)
Returns characters from the middle of the text. The arguments are the text, the starting position and the number of characters. Here the web address https://mail.google.com/mail.u gives the domain name.
| Websites | Mid |
|---|---|
| https://mail.google.com/mail.u | mail.google.com |
| https://www.bigrock.in/dod?gclid= | www.bigrock.in |
| https://eralamshahbaz.com | eralamshahbaz.com |
| https://web.whatsapp.com/ | whatsapp.com |
| https://smallpdf.com/pdf-to-jpg | smallpdf.com |
RIGHT
=RIGHT(A2,4)
Returns the stated number of characters from the right (end) of the text.
| Names | Right |
|---|---|
| Syed Abid Ali | Ali |
| David Warner | David Warner |
| M.S Dhoni | oni |
| Virat Kohli | at Kohli |
| Adam Zampa | Zampa |
| Ricky Ponting | Ponting |
| Mohd Shami | hami |
| Josh Hazlewood | azlewood |
| Adil Rashid | hid |
| Jonny Bairstow | y Bairstow |
LEN (Length)
=LEN(A2)
Counts the characters in the text, including the spaces.
| Names | Length |
|---|---|
| Zainab Rizvi | 12 |
| Amit Tyagi | 10 |
| Shahid Kapoor | 13 |
| Dennis Ritchie | 14 |
| Nusbeeha Naqvi | 14 |
| James Thomas | 12 |
| Eli Christian | 13 |
| Jameson | 7 |
| Ravi Kumar | 10 |
| Shivi Singh | 11 |
CONCATENATE
=CONCATENATE(A2," ",B2," ",C2)
Joins the text of several cells into one. A space in quotation marks is placed between the parts.
| First Name | Middle Name | Last Name | Full Name (Concatenate) |
|---|---|---|---|
| Mohd | Ali | Alam | Mohd Ali Alam |
| Eshika | Singh | Yadav | Eshika Singh Yadav |
| Amit | Kumar | Tyagi | Amit Kumar Tyagi |
| Inaya | Ansari | Inaya Ansari | |
| Liyana | Zaidi | Liyana Zaidi | |
| Mohd | Mahin | Alam | Mohd Mahin Alam |
| St | Dennis | Ritchie | St Dennis Ritchie |
| Miss | Aliya | Naqvi | Miss Aliya Naqvi |
| Miss | Sheeza | Ansari | Miss Sheeza Ansari |
| Naina | Bhardwaj | Naina Bhardwaj |
EXACT
=EXACT(A2,B2)
Compares two texts and returns TRUE only when they are exactly the same (including capital and small letters), otherwise FALSE.
| Data 1 | Data 2 | Exact |
|---|---|---|
| Document | Ink | FALSE |
| Paper | Paper | TRUE |
| Pen | Pencil | FALSE |
| AC1500 | AB1500 | FALSE |
| Printer | Printers | FALSE |
| Scanner | Scanner | TRUE |
| 158 | 158 | TRUE |
| SMPS | Power | FALSE |
| Keyboard | Press | FALSE |
| Mouse Pad | Pad | FALSE |
Free study material for Computer Science
Free CBSE Study Guides: Computer Science MS Office
Quick Revision Material for MS Office
Access comprehensive study material for MS Office, including revision notes, concept maps, and high-probability questions. These resources are designed in alignment with the latest 2026 CBSE syllabus for Computer Science to support effective exam preparation.
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
Wrap up your chapter revision by testing your knowledge against standard objective question formats. Explore our full library of free, up-to-date sample papers and online assessments to secure top grades in your CBSE examinations.
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.