Skip to main content

Posts

Showing posts with the label GCC-TBC

Excel Shortcut keys

⌨ A to Z MS Excel For Daily Work CTRL + A      ALL select CTRL + B     Apply Bold format to the text CTRL + C      Copy the selected data. CTRL + D      Duplicate the Data CTRL + E      Activate Flash Fill CTRL + F      Find CTRL + G      Go to     CTRL + H      Replace CTRL + I      Apply Italic format to the text CTRL + J      - CTRL + K      Hyperlink CTRL + L      Create Table CTRL + M      - CTRL + N     Create a  New Black workbook CTRL + O      Opens an existing Workbook CTRL + P      Print the active sheet CTRL + Q      Quick Analysis (If data is selected) CTRL + R      Fill Right CTRL + S      Save the Active Workbook CTRL + T      Create Table CTRL + U      Underline the selected text CTRL + V      Paste cut or copied data/cells  CTRL + W      Close Window CTRL + X      Cut selected data CTRL + Y      Redo the last Action (Repeat) CTRL + Z      Undo the last Action Shortcuts using Functions keys F1     :  Help F2     :

File Extensions

 File Formats with their Extensions File extension or File Formats are like identifiers where we can identify their file types in our computer. If the file data is organized in correct format then only we can access those file by their file type software.  To see file type/extension in computer : Select the file ⇾ right click ⇾ Go to Properties ⇾ General ⇾ type of file .TXT :  Text file created using Notepad .DOC : Document file created using MS word Application (version 97-2003) .DOCX : Document file created using MS word Application (version 2007-2019 and till) .XLS : Excel File created using MS Excel Application (version 97 - 2003) .XLSX :  Excel File created using MS Excel (Application version 2007-2019 and till) .PPT : Presentation File created using MS PowerPoint Application (version 97-2003) .PPTX :  Presentation File created using MS PowerPoint Application (version 2007-2019 till) .PDF : Parable Document Format. This format is from Adobe software Created for Document Exchan

Input and Output Devices of Computer

Input Devices and Output devices along with their Explanation: Input and Output Devices Input Devices      Feeding information into computer or the information provided to the computer is known as Input. The set of devices which are helps to provide input to the computer is called Input unit/Input devices. Ex: Keyboard, Mouse, Joystick, Scanner, Microphone, Touchpad, Digital Camera etc... Most common used Input devices are Keyboard and Mouse . Keyboard  ⌨ Keyboard is an input device. Keyboard is used to enter data into computer. Standard Type Writer keys:  A-Z, Standard type writer keys are also called Alpha/Alphabetical  keys. Numeric Keypad : 0-9, we use numeric keypad to type data which are in the form of number. Functions keys:  Function keys are labeled as F1, F2 to F12. We can see these keys at the top of the keyboard. We use these function keys as a Shortcut key in various programs. Special purpose keys:   Combination keys: We cannot use these keys independently we combin

30wpm letter format- GCC TBC

 GCC-TBC Letter :  30 wpm Total Time = 30 Min Total Marks = 15 Typing Marks = 7.5 Presentation Marks = 7.5  Type all details by seeing the letter given in your document (Do not give any format while typing)  In GCC-TBC Letter 30wpm format  Use Total 6 Enters In 5 places (Refer the given Image)    Use minimum 3 and maximum 5 TABs in between Ref. No & Date (while typing the letter do not use any space direct you may use TABs) Use 2 TABs for both Subject and Reference lines. Use single TABs for Every Paragraphs. Use Justify alignment for all paragraphs from alignment group. Heading lines should be center alignment and 1st line of the heading should be Bold and Underlined. Use Bold effect to the Subject and Reference. Complimentary close: Indent 3.5; alignment: Center; Computer History & Generation

Computer History and Generations

  Computer History Ancient Computers: The most ancient computer was Abacus. It was first automatic computer which was used for the purpose of calculating and counting. Blaise Pascal invented the Pascaline. this device could perform simple addition, subtraction multiplication division. Modern Computers Charles Babbage: On 19th century (1837) English mathematician Charles Babbage created a machine for calculation purpose. He named it as a Analytical Engine.   Charles Babbage considered as " The father of computer/the father of modern day computing" Computer Generations: First Generation Computer (1940-1956) Vaccum tubes  (valves) were used Second Generation Computers: (1956-1963)   Transistors were used More speed as compared to first generation. Third Generation computer (1964-1971) Integrated circuits (IC) were used Speed increased as compared to previous generations. It never became warm. Fourth Generation computers: (1971-1990) Microprocessors  are used in forth generation

MS Word Shortcut Keys

Microsoft Word  All Shortcut Keys Ctrl+A        =       All select Ctrl+E        =       Center Alignment Ctrl+L        =       Left Alignment Ctrl+R        =       Right Alignment Ctrl+J        =       Justify  Ctrl+>        =       Increase the Font size Ctrl+<        =       Decrease the Font size Ctrl+B        =       Bold the selected text Ctrl+I         =       Italic Ctrl+U        =       Underline Ctrl+F        =       Find Ctrl+V        =       Paste the  Ctrl+X        =       Cut the selected text Ctrl+P        =       Print   Ctrl+H       =       Replace   Ctrl+K       =       Add Hyperlink   Ctrl+C        =       Copy selected text   Ctrl+Z        =