Advanced Study Material for Computer Science: MS Office
Review targeted academic resources with the Advanced Excel Course All About Fill Option 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.
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.
This page explains the Fill command of the Home tab: filling cells down, right, up and left, filling the same data across several worksheets, and the Series dialog box that builds linear, growth and date series such as days, weekdays, months and years.
Fill Down, Right, Up and Left
The Fill button is in the Editing group of the Home tab, next to AutoSum. Its drop-down menu contains these commands: Down, Right, Up, Left, Across Worksheets, Series, Justify and Flash Fill.
Example: a student marks table has the columns Sr., Student Name, English, Math, Hindi, Art, Science and Maximum Marks for ten students. The total of the English column is entered in cell C12 as =SUM(C2:C11), which gives 484, and the same formula can then be filled into the neighbouring cells of the row with Fill.
| Command | Shortcut | What it does |
|---|---|---|
| Down | Ctrl + D | Copies the content of the top cell of the selection into all the selected cells below it. |
| Right | Ctrl + R | Copies the content of the left-most cell of the selection into all the selected cells to its right. |
| Up | Copies the content of the bottom cell of the selection into all the selected cells above it. | |
| Left | Copies the content of the right-most cell of the selection into all the selected cells to its left. |
Example for Fill Down: type 100 in a cell, select that cell together with the cells below it, and choose Fill > Down; every selected cell shows 100. Fill Right is used in the same way on a row of cells (100 in the first cell, selection to the right). For Fill Up, type 100 in the lowest cell of the selection and every selected cell above it becomes 100.
Across Worksheets
Across Worksheets copies the selected cells to the same cells of other worksheets of the workbook.
1. Copy the table (for example a product table with the columns Product Name, HSN Code, GST Rate and Rate) on the first sheet.
2. Select all the sheets: click the first sheet tab and Shift + click the last sheet tab.
3. Select the table range and choose Fill > Across Worksheets. The Fill Across Worksheets dialog box opens with three options: All, Contents and Formats.
4. Click OK.
All pastes everything, Contents pastes only the content of the cells, and Formats pastes only the formatting.
Series
Fill > Series opens the Series dialog box. The dialog box has the following parts.
| Part of the dialog box | Choices |
|---|---|
| Series in | Rows or Columns |
| Type | Linear, Growth, Date, AutoFill |
| Date unit (active only for the Date type) | Day, Weekday, Month, Year |
| Trend | Check box |
| Step value | The amount added (or multiplied) for each cell |
| Stop value | The value at which the series stops |
Linear series
Type 1 in a cell, select the cells below it, open Fill > Series, choose Columns and Linear, set Step value 1 and Stop value 20, and click OK. The cells fill with 1, 2, 3, ... 20.
Growth series
Type 2 in a cell and select the cells below it. In the Series dialog box choose Columns and Growth, with Step value 2. Each value is multiplied by the step value, so the cells fill with:
2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 4096, 8192, 16384
Date series
Type the date 01-06-2022 in a cell, select the cells below it, open Fill > Series, choose Columns and Date, and select one of the date units with Step value 1.
| Date unit | Result |
|---|---|
| Day | 01-06-2022, 02-06-2022, 03-06-2022, ... every day, up to 15-06-2022 |
| Weekday | Saturdays and Sundays are skipped: 01-06-2022, 02-06-2022, 03-06-2022, then 06-06-2022, 07-06-2022 ... 10-06-2022, 13-06-2022 ... 17-06-2022, 20-06-2022, 21-06-2022 |
| Month | 01-06-2022, 01-07-2022, 01-08-2022 ... 01-12-2022, 01-01-2023 ... up to 01-08-2023 |
| Year | 01-06-2022, 01-06-2023, 01-06-2024 ... up to 01-06-2036 |
Justify and Flash Fill
Justify and Flash Fill are the last two commands of the Fill menu. Flash Fill is explained with its own example in the Financial Function notes of this course, and its shortcut is Ctrl + E.
Free study material for Computer Science
Free CBSE Study Guides: 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
Designed around the official curriculum, these study guides guarantee standard compliance. Reviewing step-by-step solutions clarifies complex sub-topics within MS Office and demystifies standard marking schemes for Computer Science evaluations.
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.