Advanced Study Material for Computer Science: MS Office
Explore structured advanced study materials through the Advanced Excel Course MS Excel Shortcut Keys Notes Set 01. Tailored for learners, utilizing these Computer Science resources ensures thorough preparation and strengthens foundational knowledge before final evaluations.
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.
A list of the most useful Excel keyboard shortcuts: the Ctrl key combinations from A to Z, function-key shortcuts, row and column shortcuts, Alt key sequences for row height and column width, other keyboard shortcuts and the Alt + H + B border shortcuts.
Ctrl key shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + A | Select All |
| Ctrl + B | Bold |
| Ctrl + C | Copy |
| Ctrl + D | Fill Down: copies the data of the cell above into the selected cells below it, without using Ctrl + C |
| Ctrl + E | Flash Fill |
| Ctrl + F | Find |
| Ctrl + G | GoTo: jumps to a given cell or page, for example from page 1 to page 10 |
| Ctrl + I | Italic |
| Ctrl + K | Hyperlink |
| Ctrl + L | Left Alignment |
| Ctrl + N | New Workbook |
| Ctrl + O | Open |
| Ctrl + P | |
| Ctrl + R | Right Alignment |
| Ctrl + S | Save |
| Ctrl + T | Table Create |
| Ctrl + U | Underline |
| Ctrl + V | Paste |
| Ctrl + W | Worksheet Close |
| Ctrl + X | Cut |
| Ctrl + Y | Redo |
| Ctrl + Z | Undo |
| Ctrl + Shift + C | Format Painter |
Function key shortcuts with Ctrl
| Shortcut | Action |
|---|---|
| Ctrl + F1 | Show or Hide Ribbon |
| Ctrl + F2 | Print Preview |
| Ctrl + F3 | Name Manager |
| Ctrl + F6 | Switching Workbook: moves from one open workbook to another |
| Ctrl + F9 | Minimize Windows |
| Ctrl + F10 | Maximize Windows |
Selecting, moving and inserting
| Shortcut | Action |
|---|---|
| Ctrl + Space | Select Current Column |
| Shift + Space | Select Current Row |
| Ctrl + Arrow Key | Move to the edge of the data region |
| Ctrl + Home | Goto First Cell |
| Ctrl + End | Goto Last Cell |
| Ctrl + + | Add New Column or Row |
| Ctrl + - | Delete Column or Row |
| Ctrl + : | Insert Current Time |
| Ctrl + ; | Insert Current Date |
Row height and column width (Alt sequences)
| Shortcut | Action |
|---|---|
| Alt + O + R + E | Row Height |
| Alt + O + C + W | Column Width |
| Alt + H + O + I | Column width Auto adjust |
| Alt + H + O + A | Row Height Auto adjust |
Excel other keyboard shortcuts
| Shortcut | Particulars |
|---|---|
| Ctrl + 0 | Hides the selected column |
| Ctrl + 9 | Hides the selected row |
| Ctrl + Shift + 0 | Unhides a column |
| Ctrl + Shift + 9 | Unhides a row |
| Ctrl + 1 | Opens the Format Cells window |
| Ctrl + 5 | Strikethrough: draws a line through the selected text |
| Ctrl + Shift + + | Shows the Insert dialog box |
| Shift + F2 | Inserts a comment |
| Shift + F3 | Opens the Excel formula (Insert Function) box |
| Shift + F5 | Opens the Search (Find) box |
| Shift + F11 | Adds a new worksheet |
| F1 | Opens Microsoft Excel Help |
| F2 | Edits the selected cell |
| F4 | Repeats the last action |
| F7 | Spelling check of the selected text |
| F11 | Creates a chart of the selected data |
| F12 | Save As: saves any file under a new name |
| Shift + Space | Selects all the cells of a row |
| Ctrl + Space | Selects all the cells of a column |
| Alt + = | Applies the AutoSum formula |
| Alt + F1 | Creates a chart |
| Alt + F8 | Displays the macros |
| Ctrl + Shift + & | Puts an outline border |
| Ctrl + Shift + - | Removes the borders |
| Ctrl + Shift + U | Expands or collapses the formula bar |
Border shortcut keys
Press Alt, then H, then B (the Borders button of the Home tab), and then the letter of the border.
| Keys | Border |
|---|---|
| Alt + H + B then O | Bottom border |
| Alt + H + B then P | Top border |
| Alt + H + B then L | Left border |
| Alt + H + B then R | Right border |
| Alt + H + B then N | No borders |
| Alt + H + B then A | All borders |
| Alt + H + B then S | Outside borders |
| Alt + H + B then T | Thick outside borders |
| Alt + H + B then B | Bottom double borders |
| Alt + H + B then H | Thick bottom borders |
| Alt + H + B then C | Top and thick bottom border |
| Alt + H + B then U | Top and double bottom border |
Free study material for Computer Science
Computer Science Exam Resources: 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
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.
Additional Study Resources for
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.