Computer Awareness MS Excel and MS PowerPoint Notes Set 02

Official Study Materials for Computer Science

Review targeted academic resources with the Computer Awareness MS Excel and MS PowerPoint Notes Set 02. 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.

Microsoft Excel and PowerPoint notes for computer awareness papers: worksheets, cell references, ribbon tabs, 26 commonly asked functions, one-line facts and the full list of Excel shortcut keys, followed by the PowerPoint ribbon tabs and shortcuts.

MS-Excel

1. Spreadsheet application developed by Microsoft corporation.
2. It can perform calculation, graphics, pivot tables and has a macro programming language called Visual Basic for Applications.
3. Intersection of a row and a column is called a cell. The cell in which we are currently working is called active cell.

Worksheet

1. Worksheet is a collection of cells where we keep and manipulate data. Worksheets will begin with row number 1 and column number A.
2. In MS-Excel 2010, the maximum size of a worksheet is 1,048,576 rows by 16,384 columns.
3. We can rename the worksheets by right clicking on the sheet tab and choose rename.
4. We can also add new worksheet by the shortcut Alt+Shift+F1 or Shift + F11.

Workbook

1. Collection of worksheets is called workbook.

Cell References in Excel

Reference TypeFormulaAfter copying the Formula
Relative=A1Both the column letter A and the row number 1 can change.
Absolute=$A$1The column letter A and the row number 1 does not change.
Mixed=$A1The column letter A does not change. The row number 1 can change.
Mixed=A$1The column letter A can change. The row number 1 does not change.

There are three types of cell references in EXCEL formulas:

1. Relative reference
2. Absolute reference
3. Mixed reference

Relative Reference

1. If we have a cell with a formula that references a different cell's address and we copy the formula from the first cell to another cell.
2. Relative references adjust when we change any value or copy and paste in different cells.

Absolute Reference

1. It does not change when the formula is copied.
2. In an absolute cell reference, a dollar sign ($) precedes both the column and row number.

Mixed Reference

1. In this the column can be absolute and the row can be relative or vice-versa.
2. Dollar sign is placed in front of the just the column or row number as per requirements.

Tabs in MS-Excel

Tabs: File, Home, Insert, Page layout, Formula, Data, Review, and View

HOME: Clipboard, Font, Alignment, Number, Style, Cells, Editing

INSERT: Tables, Illustrations (Pictures, online pictures), add-ins (charts, 3 D maps), spark lines (line, column, win/loss), Filters etc.

Formulas: Insert function, function library, defined names: formula auditing, calculation

Some Important Functions used in MS-Excel

No.FunctionUse
1LOWERConverts all characters in a supplied text string to lower case.
2UPPERConverts all characters in a supplied text string to upper case.
3CONCATENATEJoins together two or more text strings.
4LEFTReturns a specified number of characters from the start of a supplied text string.
5RIGHTReturns a specified number of characters from the end of a supplied text string.
6TIMEReturns a time, from a user-supplied hour, minute and second.
7NOWReturns the current date and time.
8TODAYReturns today's date.
9SUMReturns the sum of a supplied list of numbers.
10MAXReturns the largest value from a list of supplied numbers.
11MINReturns smallest value from a list of supplied numbers.
12COUNTIFReturns the number of cells (of a supplied range), that satisfy a given criteria.
13ANDTests a number of user-defined conditions and returns TRUE if all the conditions evaluate to true or false otherwise.
14ORTests a number of user-defined conditions and returns TRUE if any of the conditions evaluate to true or false.
15NOTReturns a logical value that is the opposite of a user supplied logical value or expression i.e. returns FALSE if the supplied argument is TRUE and vice-versa.
16SQRTReturns the positive square root of a given number.
17POWERReturns the power of a number raised to second number.
18FLOORRounds the value down towards zero and always returns a numeric value.
19CEILINGIf the formula reads =CEILING (7, 5) it will return the value of 10. The function will round off number 7 to the nearest multiple of 5 (10).
20IFTests a user defined condition and returns one result if the condition is true, and another result if the condition is false.
21ABSReturns the absolute value of a supplied number.
22PRODUCTReturns the product of a supplied list of numbers.
23MODReturns the remainder from a division between two supplied numbers.
24SUMIFAdds the cells in a supplied range, that satisfy a given criteria.
25COUNTReturns the number of numerical values in a supplied set of cells or values.
26AVERAGEReturns the Average value from a list of supplied numbers.

One Liners of MS-Excel

1. In MS-Excel 2010, command used to hide the columns - Ctrl + 0
2. In MS-Excel 2010, command used to hide a row - Ctrl + 9
3. Hide option is present in View tab in MS-Excel 2010 ribbon bar.
4. LEN function in MS-Excel 2010 returns the total number of characters in a string - LEN (1236) = 4
5. Default alignment of numeric values that are entered into the cell of MS-Excel 2010 - Right
6. Shortcut to collapse the ribbon - Ctrl + F1
7. Alt + Enter is used to start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell.
8. The SUM formula is used to sum all the numbers in a specified range of cells.
9. To rename a table in MS-Excel 2010, the Table Name box on the Table Tools (Design) tab is used. (Ctrl + R is the shortcut for Fill Right.)
10. The maximum number of characters that can be typed in a cell of MS-Excel 2010 Worksheet are - 32767
11. To go to view tab shortcut we use is - Alt + W
12. When we select a range of cells (for eg: B3:G9), then in the name box only the name of first cell is shown. i.e. B3 will be shown only.
13. Maximum zoom percentage in MS-Excel 2010 is - 400%.
14. The tables created through table feature of MS-Excel 2010 allow users to filter column by different values.
15. F2 is used to edit a cell.
16. To replace text within the sheet we use - Ctrl + H.
17. To represent the absolute address of a cell, we use the symbol $ before both co-ordinates.
18. To insert a new worksheet in an existing MS-Excel 2010 workbook the shortcut used is - Shift + F11
19. Counting the number of cells in a range with specific criteria in MS-Excel 2010 can be done by using - COUNTIF
20. To display current date with time in the cell of MS-Excel 2010 worksheet we use Now ().
21. To save an open file, we use Shift + F12.
22. In MS-Excel 2010, the AUTOSUM feature helps us to add the contents (numeric value) of a cluster of adjacent cells.
23. In MS-Excel 2010, MATCH looks up values in reference or array.
24. FLOOR function is used in MS-Excel 2010 for rounding the number down. (Lower) FLOOR (27,6) = 24
25. CEILING function is also used in MS-Excel 2010 for rounding off the number. (Greater) CEILING (27,6) = 30
26. Shortcut to select a row = Shift + Spacebar
27. Shortcut to go to Data tab = Alt + A
28. Ctrl + A is used to select the entire worksheet.
29. Upper function is used in MS Excel to change all the characters of the text to Uppercase.
30. To select one or more non-adjacent worksheets, click the tab for first worksheet, then hold down the Ctrl key on your keyboard while you click the tabs of the other sheets you want to select.
31. DATEVALUE() is used to convert a date that is stored as text to a serial number that Excel recognizes as a date.
32. PROPER function capitalizes the first letter in each word of a text value.
33. There are 1,048,576 rows and 16,384 columns in a worksheet of MS-Excel 2010 and 65536 rows and 256 columns in MS-Excel 2003
34. EXACT checks whether two strings are exactly same or not.
35. Minimum zoom percentage in MS-Excel 2010 is 10%.
36. Ctrl + F4 is used to close a workbook in MS-Excel 2010.
37. Shift + Tab is used to move to the previous cell in a row of the table.
38. Shortcut to go to insert tab = Alt + N
39. Ctrl + T is used to display the create table dialog box.
40. CONCATENATE function is used to join several text items into one text item cell.
41. To preview the worksheet before we print, the shortcut used is Ctrl + F2.
42. The shortcut to open the delete dialog box to delete selected cells is Ctrl + -
43. The keyboard shortcut key to open the format cells dialog box is Ctrl + Shift + F
44. The remove duplicate function is found in the ribbon under the Data tab.
45. ROUND function is used to round off a number to a specified number of digits. ROUND (5.23692,4) = 5.2369
46. EVEN function is used to find the nearest even number (rounding away from zero). EVEN (11) = 12, EVEN (-9) = -10
47. ODD function is used to find the nearest odd number (rounding away from zero). ODD (8) = 9
48. To find total Cells = Rows × Columns. Example : Total cells in the range A4:C10 = Rows × Columns = [(10-4)+1] × 3 = 21
49. The limit of font size in MS-Excel is 8-72 and its manual limit is 1-409.
50. The alphabet data is entered on the left side by default whereas the numerical data is entered on the right side in MS-Excel.
51. Shortcut keys: Date = Ctrl + ; and Time = Ctrl + Shift + ;
52. A new workbook has 3 worksheets by default (at least 1 sheet must be present); more sheets can be added, limited only by the available memory.
53. By default the size and the font in MS-Excel are set to be 11 and Calibri.

Shortcut Keys for MS-Excel

Shortcut KeyFunction
F1Displays the Office Assistant or (Help > Microsoft Excel Help).
F2Edits the active cell, putting the cursor at the end.
F3Displays the (Insert > Name > Paste) dialog box.
F4Repeats the last worksheet action (Edit > Repeat).
F5Displays the (Edit > Go To) dialog box.
F6Moves to the next pane in a workbook (if the window is split).
F7Displays the (Tools > Spelling) dialog box.
F8Toggles whether to extend a selection with the arrow keys.
F9Calculates All the worksheets in All the open workbooks.
F10Toggles the activation of the Menu Bar.
F11Displays the (Insert > Chart) dialog box.
F12Displays the (File > Save As) dialog box.
Shift + F2Inserts or edits a cell comment (Insert > Comment).
Shift + F3Displays the (Insert > Function) dialog box.
Shift + F4Repeats the last Find, the same as (Edit > Find Next).
Shift + F5Displays the (Edit > Find) dialog box.
Shift + F6Moves to the previous pane in a workbook (if the window is split).
Shift + F8Toggles between switching Add Mode on or off*.
Shift + F9Calculates just the active worksheet.
Shift + F10Displays the (Shortcut) menu for the selected item.
Shift + F11Inserts a new worksheet (before the active sheet).
Shift + F12Saves, Displays the (File > Save As) dialog box if a new workbook.
Ctrl + F1Closes and reopens the current task pane (ribbon in 2007).
Ctrl + F2Print Preview.
Ctrl + F3Displays the (Insert > Name > Define) dialog box.
Ctrl + F4Closes the selected workbook window.
Ctrl + F5Restores the size of the active workbook or window.
Ctrl + F6Moves to the next open workbook or window.
Ctrl + F7Activates the Move window command.
Ctrl + F8Activates the Resize window command.
Ctrl + F9Minimizes the size of the active workbook or window.
Ctrl + F10Maximizes the size of the active workbook or window.
Ctrl + F12Displays the (File > Open) dialog box.
Alt + F1Creates a chart (on a chart sheet) using the highlighted range.
Alt + F2Displays the (File > Save As) dialog box.
Alt + F4Closes all the workbooks (saving first) and exits Excel (File > Exit).
Alt + F8Displays the (Tools > Macro > Macros) dialog box.
Alt + F11Toggles between the Visual Basic Editor window and the Excel window.
Alt + Ctrl + F9Calculates All cells on All worksheets in All workbooks.
Alt + Shift + F2Displays the (File > Save As) dialog box.
Alt + Shift + F4Closes all the workbooks (saving first) and exits Excel (File > Exit).
Alt + Shift + F10Displays the drop-down menu for the corresponding smart tag.
Alt + Shift + F11Activates the Microsoft Script Editor window.
Ctrl + Shift + F3Displays the (Insert > Name > Create) dialog box.
Ctrl + Shift + F6Moves to the previous open workbook or window.
Ctrl + Shift + F10Activates the Menu Bar or Shortcut Characters in 2007.
Ctrl + Shift + F12Displays the (File > Print) dialog box.
Ctrl + Shift + 0Unhide the columns in the current selection.
Ctrl + Shift + " (double quote)Enters the value from the cell directly above into the active cell.
Ctrl + Shift + 8Selects the current region (surrounded by blank rows and columns).
Ctrl + Shift + 9Unhide the rows in the current selection.
Ctrl + Shift + FActivates the Font Tab of the format cells.
Ctrl + Shift + OSelects all the cells with comments.
Ctrl + Shift + PActivates the Font Size tab of the format cells.
Ctrl + 0Hides the columns in the current selection.
Ctrl + 1Displays the formatting dialog box.
Ctrl + 2Toggles bold on the current selection.
Ctrl + 3Toggles italics on the current selection.
Ctrl + 4Toggles underlining on the current selection.
Ctrl + 5Toggles the strikethrough of text on the current selection.
Ctrl + 6Toggles between hiding and displaying objects.
Ctrl + 8Toggles the display of Outline symbols on the active worksheet.
Ctrl + 9Hides the rows in the current selection (Format > Row > Hide).
Ctrl + ASelects the whole worksheet.
Ctrl + BToggles bold on the current selection.
Ctrl + CCopies the current selection to the clipboard.
Ctrl + DCopies the first cell in the selection downwards.
Ctrl + FDisplays the Find dialog box.
Ctrl + GDisplays the Go To dialog box.
Ctrl + HDisplays the Replace dialog box.
Ctrl + IToggles italics on the current selection.
Ctrl + KDisplays the Insert Hyperlink dialog box.
Ctrl + LDisplays the Create Table dialog box.
Ctrl + NCreates a new workbook.
Ctrl + ODisplays the Open dialog box.
Ctrl + PDisplays the Print dialog box.
Ctrl + RCopies the leftmost cell in the selection to the right.
Ctrl + SSaves, Displays the Save As dialog box if a new workbook.
Ctrl + UToggles underlining on the current selection.
Ctrl + VPastes the entry from the clipboard.
Ctrl + WCloses the active workbook or window.
Ctrl + XCuts the current selection to the clipboard.
Ctrl + YRepeats the last workbook action.
Ctrl + ZUndo/Redo the last workbook action.
Shift + EnterEnters the contents of the active cell and moves to the cell above (by default).
TabEnters the contents of the active cell and moves one cell to the right.
Shift + TabEnters the contents of the active cell and moves one cell to the left.
Alt + =Enters the SUM() function (AutoSum) to sum the adjacent block of cells.
Alt + EnterEnters a new line (or carriage return) into a cell.
Ctrl + 'Enters the contents from the cell directly above into the active cell.
Ctrl + ;Enters the current date into the active cell.
Ctrl + Shift + ;Enters the current time into the active cell.
Ctrl + Shift + EnterEnters the formula as an Array Formula.
Shift + InsertEnters the data from the clipboard.
Alt + Down ArrowDisplays the Pick From List drop-down list.
EscCancels the cell entry and restores the original contents.
DeleteDeletes the selection or one character to the right.
BackspaceDeletes the selection or one character to the left.
Shift + DeleteCuts the selection to the clipboard.
Ctrl + DeleteDeletes text to the end of the line.
Ctrl + -Displays the Delete dialog box.
Ctrl + Shift + =Displays the Insert dialog box.
Ctrl + \Selects the cells in a selected row that do not match the value in the active cell.
Ctrl + Shift + | (Shift + Backslash)Selects the cells in a selected column that do not match the value in the active cell.
Ctrl + /Selects the array containing the active cell.
Alt + ;Selects the visible cells in the current selection.
Ctrl + *Selects the current region (using the * on the number keyboard).
Ctrl + [Selects all the cells that are directly referred to by the formula in the active cell.
Ctrl + Shift + [Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell.
Ctrl + ]Selects all the cells that directly refer to the active cell (dependents).
Ctrl + Shift + ]Selects all the cells that directly (or indirectly) refer to the active cell.
Ctrl + Shift + Arrow Key Extends the selection to the next cell adjacent to a blank cell in that direction.
Ctrl + Shift + Page DownSelects the active worksheet and the one after it.
Ctrl + Shift + Page UpSelects the active worksheet and the one before it.
Ctrl + Shift + SpacebarSelects all the objects on the worksheet when an object is selected.
Ctrl + SpacebarSelects the current column.
Shift + Arrow keysSelects the active cell and the cell in the given direction.
Shift + BackspaceSelects the active cell when multiple cells are selected.
Shift + SpacebarSelects the current row.
Ctrl + Shift + EndExtends the selection to the last used cell on worksheet.
Ctrl + Shift + HomeExtends the selection to the beginning of the worksheet.
Shift + Arrow KeysExtends the selection by one cell in that direction.
Shift + HomeExtends the selection to the first column.
Shift + Page DownExtends the selection down one screen.
Shift + Page UpExtends the selection up one screen.
End + Shift + Arrow KeysExtends the selection to the next non-blank cell in that direction.
End + Shift + EndExtends the selection to the last cell in the current row*.
End + Shift + HomeExtends the selection to last used cell on the worksheet.
Alt + 'Displays the Style dialog box.
Ctrl + Shift + @ (Shift + 2)Applies the Time format (h:mm AM/PM) to the selection.
Ctrl + Shift + % (Shift + 5)Applies the Percentage format "0%" to the selection.
Ctrl + Shift + ~Applies the General format to the selection.
Ctrl + Shift + # (Shift + 3)Applies the Date format (DD-MMM-YY) to the selection.
Ctrl + Shift + & (Shift + 7)Applies the outline border to the selection.
Ctrl + Shift + _ (Shift + Minus)Removes all the borders from the selection.
Ctrl + TabMoves to the next open workbook or window.
Alt + TabMoves to the next application open on your computer.
Alt + Shift + TabMoves to the previous application open on your computer.
End + Arrow KeysMoves to the next non empty cell in that direction.
End + EnterMoves to the last cell in the current row that is not blank.
End + HomeMoves to the last used cell on the active worksheet*.
Page DownMoves to the next screen of rows down.
Page UpMoves to the previous screen of rows up.
Shift + EnterMoves to the cell directly above (opposite direction to Enter).
Shift + TabMoves to the cell directly to the left (opposite direction to Tab).
Alt + Page DownMoves you one screen of columns to the right.
Alt + Page UpMoves you one screen of columns to the left.
Ctrl + HomeMoves to cell "A1" on the active sheet.
Ctrl + EndMoves to the last used cell on the active worksheet*.
Ctrl + Up ArrowMoves to the first row in the current region.
Ctrl + Down ArrowMoves to the last row in the current region.
Ctrl + Left ArrowMoves to the first column in the current region.
Ctrl + Right ArrowMoves to the last column in the current region.
Ctrl + Page UpMoves to the previous worksheet in the workbook.
Ctrl + Page DownMoves to the next worksheet in the workbook.
Ctrl + Shift + TabMoves to the previous open workbook or window.
Scroll Lock + Arrow Keys Moves the workbook or window one cell the corresponding direction.
Scroll Lock + EndMoves to the last cell in the current window.
Scroll Lock + HomeMoves to the first cell in the current window.
Scroll Lock + Page DownMoves you down one screen (current selection unchanged).
Scroll Lock + Page UpMoves you up one screen (current selection unchanged).
Ctrl + .Moves clockwise to the next corner within a selection.
Shift + TabMoves from right to left within a selection (opposite direction to Tab).
Alt + Ctrl + Left ArrowMoves to the left between non adjacent cells in a selection.
Alt + Ctrl + Right ArrowMoves to the right between non adjacent cells in a selection.
=Starts a Formula.
Ctrl + `Toggles between the value layer and the formula layer.
Ctrl + InsertCopies the current selection to the clipboard.
Ctrl + Shift + (Unhide any hidden rows within the selection.
Ctrl + Shift + )Unhide any hidden columns within the selection.
Ctrl + Shift + | (Shift + Backslash)Selects unequal cells.
AltToggles the activation of the old Menu Bar.
Alt + Shift + Left ArrowDisplays the (Data > Group and Outline > Ungroup) dialog box.
Alt + Shift + Right ArrowDisplays the (Data > Group and Outline > Group) dialog box.
Alt + SpacebarActivates the Control Box in the top left corner.

MS PowerPoint

1. Presentation software program of Microsoft Office package.
2. Uses a graphical approach to present in the form of slide shows that accompany the oral delivery of the topic.

Tabs of MS PowerPoint

Tabs: File, Home, Insert, Design, Transition, Animation, Slideshow, Review and View

FILE: We can open, save, share, export, print and manage our presentation.

Home: Clipboard, Slides, Font, Paragraph, Drawing and Editing

1. Slides group contains commands to insert new slide, choose slide layout, reset the positions and formatting the slide.

INSERT: We can add pictures, shapes, charts, links, text boxes, video in the slides.

DESIGN: We can add theme or colour scheme, or format the slide background.

TRANSITIONS: Set up how your slides change from one to the next on the transitions tab.

ANIMATION: Used to choreograph the movements of things on the slides.

SLIDE SHOW: Sets up the way that we want to show our presentation to others.

REVIEW: Lets you to add comments, run spell-check, or compare the presentation with another and language translation features also.

VIEW: Allows us to look at our presentation in different ways.

1. View names are Normal, outline view, slide sorter, note page, etc.

Shortcut Keys for PowerPoint

Shortcut KeyFunction
Ctrl + NCreate a new presentation
Ctrl + OOpen an existing presentation
Ctrl + SSave a presentation
Ctrl + F4Close a presentation
Ctrl + QSave and close a presentation
Ctrl + ZUndo an action
Ctrl + YRedo an action
Ctrl + F2Print preview view
F7Check spelling
Ctrl + FFind in a presentation (Ctrl + H for replace).
EscEnd the slideshow
F5Start the presentation from the beginning

Computer Science Exam Resources: 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

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

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

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.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

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.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

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.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

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.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

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.