Posts

KEYBOARD SHORTCUT KEY

Image
Important Shortcuts Keys For Computer Ctrl+A =Select All  Ctrl+X  = cut Ctrl+C = Copy Ctrl + V = Paste Ctrl + Z =Undo Ctrl +B  = Bold Ctrl+U =Underline Ctrl + l = Italic F1 =Help F2 =Rename selected object F3 =Find all files F4 =Opens file list drop-down in dialogs F5 = Refresh current window F6 =Shifts focus in Windows Explorer F10 = Activates menu bar options ALT+TAB  = Cycles between open applications ALT+F4 =Quit program, close current window ALT+F6  =Switch between current program windows ALT+ ENTER= Opens properties dialog ALT+SPACE = System menu for current window ALT+¢ =opens drop-down lists in dialog boxes BACKSPACE = Switch to parent folder Ctrl+ESC =Opens Start menu Ctrl+ALT+DEL = Opens task manager, reboots the computer Ctrl+TAB = Move through property tabs Ctrl+SHIFT+DRAG =Create shortcut (also right-click, drag) Ctrl+DRAG = Copy File ESC =Cancel last function SHIFT =Press/hold SHIFT, insert CD-ROM to bypass auto-play SHI...

STUDENT RESULT IN MICROSOFT EXCEL

STUDENT results in Microsoft Excel  Name Age Gender  Subject  Tom: Total obtainable mark Tmo: Total mark obtained  Average  Position. ° TOM: =  100×Number of Subject  ° TMO: type  = Sum  than double click on Sum  and high-key from the to the last subject than you close the bracket and press enter. ° Average: type Average double click on Average and highlight from the first to the last subject then close the bracket and press enter.  ° Position: type Rank a list of option will show then you double click on rank and highlight from the first to the last Average then put your comma, put dollar sign and put the first alphabet write another dollar sign put the first number then you put Column then put dollar sign again and put second alphabet then you close the bracket and press enter. ° Grade: type IF  then a list of option will appear double click on IF  then you will click on the first Average then write >=100, "A", then w...

MICROSOFT EXCEL

                             Microsoft Excel  Microsoft Excel: This is an electronic spread sheet package that is used to Create, Analysed, Calculate, Manage and store data with the help of rows and columns.  Excel: is part of the Microsoft Office suite and is available for Windows, macOS, and mobile devices.    The place where rows and column meet is called Cell. Key features of Microsoft Excel: 1. Title bar:  Display the names of programme and document you are currently working on. 2. Ribbon bar:  Display option used in managing data  3. Quick access bar: Display option represented as icon  4. Formula bar: Display the content of an active cell/display the formula use in calculation. 5.  Heading: Is the identity of rows and columns  6. Workbook: displays worksheet.  Worksheet: Is the working environment of Microsoft word. 7. Scroll bar:  Is used to nav...