The IT Mentor: Navigating the World of Technology with DISHA INSTITUTE

Ctrl + Shift + L : This shortcut toggles the filter on or off for the selected range. It's handy for quickly applying or removing filters without using the mouse. Alt + E + S : This shortcut sequence opens the Paste Special dialog box, allowing you to choose specific paste options such as values, formats, formulas, and more. Alt + Enter : While editing a cell, pressing Alt + Enter allows you to insert a line break within the cell. This is useful for creating multi-line text entries. Ctrl + ' (Apostrophe) : This shortcut copies the value from the cell above the currently selected cell. It's a quick way to fill down a column with the value from the cell above. Ctrl + Alt + V : This shortcut opens the Paste Special dialog box directly in Values mode. It's a quicker way to paste values compared to using Alt + E + S followed by the V key. Ctrl + ; (semicolon) : This shortcut inserts the current date into the selected cell. Similarly, Ctrl + Shift + ; (semicolon) inserts the ...

 Exercises: 1. State whether the following statements are True or False. a. Ms. Excel is a spreadsheet package. b. Ms. Excel is used to create documents like letters, essay etc. c. Columns are labeled as A, B, C …………. IV. d. MM300 is a valid cell address. e. A cell is the basic unit for data entry. f. There are 256 columns in Ms. Excel. g. You can not perform calculation with DATE and TIME. h. Ctrl key is used to select the non continuous data. i. Column widths are fixed in Ms. Excel. j. Goal Seek changes the target value with respect to the supporting cell. k. Chart is a graphical representation of data in worksheet. l. Many types of chart can be created using the same data. m. Non-printing lines on the worksheet is called grid. n. Rows are labeled as A, B, C ………… o. A cell is addressed by its column heading and row number. p. = sign is given before entering formula. q. A cell range is enclosed in a parenthesis. 2. Describe Ms. Excel in brief. 3. What is a cell? How is it addresse...

  F1 – Normally this key will open the help screen when pressed. By pressing the Windows key + F1 you can open the Microsoft Windows help and support center. When online, pressing the Ctrl + F1 enables a task pane, a small window that explains or details your current page.  F2 – When a file menu is displayed the F2 key enables the renaming function of a highlighted file. Alt + Ctrl + F2 opens a new document when using Microsoft Word. Ctrl + F2 displays the print preview window in Microsoft Word.  F3 – This key opens a search Find window when using Microsoft Explorer enabling the typing of the word or phrase of a file or window you wish to locate.  F4 – This key opens the address bar when using Microsoft Explorer. In Microsoft Word it will repeat the last action. Alt + F4 will close the program currently active in MS Windows.  F5 – In most Internet browsers the F5 key will refresh or reload the page or document window. It will start a slideshow when using MS Powe...

  CTRL + SHIFT Shortcuts From A-Z: CTRL + SHIFT + C =Copy Formats CTRL + SHIFT + D = Double Underline text CTRL + SHIFT + E = Track changes CTRL + SHIFT + F = Change the font CTRL + SHIFT + H = Apply hidden text formatting CTRL + SHIFT + K = Format letters as small capitals CTRL + SHIFT + L = Apply the List style CTRL + SHIFT + M = Remove a paragraph indent from the left CTRL + SHIFT + N = Apply the Normal Style CTRL + SHIFT + P = Change the font size CTRL + SHIFT + Q = Change the selection to the Symbol font CTRL + SHIFT + S = Apply a style CTRL + SHIFT + T= Reduce a hanging indent CTRL + SHIFT + V =Paste Formats CTRL + SHIFT + W = Underline words but not spaces Other CTRL Shortcuts CTRL + ] = Increase size of selected text by one point CTRL + [ = Decrease size of selected text by one point  CTRL + SHIFT+ > = Increase font size CTRL + SHIFT + < = Decrease font size CTRL + 1 = Single-space lines CTRL + 2 = Double-space lines CTRL + 5 = 1.5 space lines CTRL + 0 = Add/remo...

CTRL Shortcuts from A-Z: CTRL + A = Select text CTRL + B =  Bold  text CTRL + C = Copy text CTRL + D = Open font formatting window CTRL + E = Center text  CTRL + F = Find a phrase  CTRL + G = Go To a specific page or bookmark CTRL + H = Replace text with another text or replace text with different formatting CTRL + I =  Italicize  text CTRL + J = Justify text CTRL + K = Open  Insert Hyperlink  window CTRL + L = Left align text CTRL + M = Indent a paragraph from the left CTRL + N = Open new Word document CTRL + O = Open an existing Word document CTRL + P = Print Word document CTRL + Q = Remove paragraph formatting CTRL + R = Right align text CTRL + S = Save Word document CTRL + T = Create a hanging indent CTRL + U = Underline text CTRL + V = Paste text CTRL + W = Close Word document CTRL + X = Cut text CTRL + Y = Redo an action previously undone OR repeat an action CTRL + Z = Undo a previous action