Official Study Materials for Computer Science
Review targeted academic resources with the Advanced Excel Course Advance Sort 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.
This page shows how to sort a table in Excel with the Sort dialog box: single-column sorting and the Sort Warning, sorting in A to Z and Z to A order, multi-level sorting with Add Level, the case sensitive option and sorting left to right.
Opening the Sort dialog box
Select the data and click the Sort button in the Sort & Filter group of the Data tab. The Sort dialog box contains these controls.
| Control | Purpose |
|---|---|
| Add Level | Adds another sorting level (Then by). |
| Delete Level | Removes the selected level. |
| Copy Level | Copies the selected level. |
| Options | Opens the Sort Options box (Case sensitive, Orientation). |
| My data has headers | Check box; when ticked, the first row is treated as column headings and is not sorted. |
| Column: Sort by | The column that decides the order. |
| Sort On | Values. |
| Order | Smallest to Largest (A to Z), Largest to Smallest (Z to A). |
The sample table used in this section has four columns: SR NO, PRODUCT, CITY and SALES.
| SR NO | PRODUCT | CITY | SALES |
|---|---|---|---|
| 1 | Keyboard | Mumbai | 45 |
| 2 | Mouse | Pune | 65 |
| 3 | Harddisk | Mumbai | 32 |
| 4 | Pendrive | Delhi | 65 |
| 5 | LCD | Mumbai | 32 |
| 6 | Card Reader | Pune | 65 |
| 7 | Ram | Delhi | 21 |
| 8 | Motherboard | Mumbai | 32 |
| 9 | CPU | Delhi | 65 |
| 10 | Power Supply | Pune | 54 |
Sort Warning
If only one column (for example the PRODUCT column) is selected and then sorted, Excel shows the Sort Warning: Microsoft Excel found data next to your selection. Since you have not selected this data, it will not be sorted. What do you want to do? The two choices are Expand the selection and Continue with the current selection. Choose Expand the selection so that the whole rows move together; otherwise only the selected column changes and the rows no longer match.
Sorting one column
With the cell pointer in the PRODUCT column, open the Sort dialog box, tick My data has headers, choose Sort by PRODUCT, Sort On Values and Order A to Z. Choosing Order Z to A arranges the table in reverse order (Ram, Power Supply, ... at the top). The My data has headers box keeps the heading row (SR NO, PRODUCT, CITY, SALES) out of the sort.
Sorting on more than one level
Click Add Level to add a Then by row. Example: Sort by CITY with Order A to Z, Then by SALES with Order Largest to Smallest.
| SR NO | PRODUCT | CITY | SALES |
|---|---|---|---|
| 9 | CPU | Delhi | 65 |
| 4 | Pendrive | Delhi | 65 |
| 7 | Ram | Delhi | 21 |
| 1 | Keyboard | Mumbai | 45 |
| 3 | Harddisk | Mumbai | 32 |
| 5 | LCD | Mumbai | 32 |
| 8 | Motherboard | Mumbai | 32 |
| 6 | Card Reader | Pune | 65 |
| 2 | Mouse | Pune | 65 |
| 10 | Power Supply | Pune | 54 |
Sort Options
The Options button of the Sort dialog box opens the Sort Options box. Case sensitive: when ticked, the sort treats capital and small letters as different (the entries Card Reader and CARD READER are then arranged separately). Orientation: Sort top to bottom (the default, used for sorting rows of a list) or Sort left to right.
Sort left to right is used when the data is arranged across a row. Example: a row containing C, B, D, A in cells is sorted by Row 2 in order A to Z after choosing Sort left to right in the Sort Options box, and the headings of that row become A, B, C, D. In this case the My data has headers box is not used and the dialog box shows Row instead of Column.
Free study material for Computer Science
Useful Resources and Notes for Computer Science MS Office
Core Study Kit: Computer Science 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.
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
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.