Wednesday, December 11, 2019

Excel short cuts

கணினி பயன்படுத்துபவர்கள் அவசியம் தெரிந்துகொள்ள

Save Your time with Short Cut 📌

Ctrl + A - Select All
Ctrl + B - Bold
Ctrl + C - Copy
Ctrl + D - Fill
Ctrl + F - Find
Ctrl + G - Find next instance of text
Ctrl + H - Replace
Ctrl + I - Italic
Ctrl + K - Insert a hyperlink
Ctrl + N - New workbook
Ctrl + O - Open
Ctrl + P - Print
Ctrl + R - Nothing right
Ctrl + S - Save
Ctrl + U - Underlined
Ctrl + V - Paste
Ctrl W - Close
Ctrl + X - Cut
Ctrl + Y - Repeat
Ctrl + Z - Cancel
F1 - Help
F2 - Edition
F3 - Paste the name
F4 - Repeat the last action
F4 - When entering a formula, switch between absolute / relative references
F5 - Goto
F6 - Next Pane
F7 - Spell Check
F8 - Extension of the mode
F9 - Recalculate all workbooks
F10 - Activate Menubar
F11 - New graph
F12 - Save As
Ctrl +: - Insert the current time
Ctrl +; - Insert the current date
Ctrl + "- Copy the value of the cell above
Ctrl + '- Copy the formula from the cell above
Shift - Offset Adjustment for Additional Functions in the Excel Menu
Shift + F1 - What is it?
Shift + F2 - Edit cell comment
Shift + F3 - Paste the function into the formula
Shift + F4 - Search Next
Shift + F5 - Find
Shift + F6 - Previous Panel
Shift + F8 - Add to the selection
Shift + F9 - Calculate the active worksheet
Shift + F10 - Popup menu display
Shift + F11 - New spreadsheet
Shift + F12 - Save
Ctrl + F3 - Set name
Ctrl + F4 - Close
Ctrl + F5 - XL, size of the restore window
Ctrl + F6 - Next Workbook Window
Shift + Ctrl + F6 - Previous Workbook Window
Ctrl + F7 - Move window
Ctrl + F8 - Resize Window
Ctrl + F9 - Minimize the workbook
Ctrl + F10 - Maximize or Restore Window
Ctrl + F11 - Inset 4.0 Macro sheet
Ctrl + F1 - Open File
Alt + F1 - Insert a graph
Alt + F2 - Save As
Alt + F4 - Output
Alt + F8 - Macro dialog
Alt + F11 - Visual Basic Editor
Ctrl + Shift + F3 - Create a name using the names of row and column labels
Ctrl + Shift + F6 - Previous Window
Ctrl + Shift + F12 - Printing
Alt + Shift + F1 - New spreadsheet
Alt + Shift + F2 - Save
Alt + = - AutoSum
Ctrl + `- Toggle value / display of the formula
Ctrl + Shift + A - Insert the argument names in the formula
Alt + down arrow - automatic view list
Alt + '- Format Style Dialog
Ctrl + Shift + ~ - General Format
FOR MORE INFO VISIT https://eeeviews.blogspot.com/ WWW.INPERVILA.CO.IN

Tuesday, November 26, 2019

NPTEL Results Declared....


Normally NPTEL results  will be declared after 10 days of the written exam.

Based upon How many weeks course , the result date may vary

https://results.nptel.ac.in

How to reach Government College of Engineering, Srirangam from Chattram Bus stand

  • First you need to catch the bus from Chattram and reach the Central Bus stand, Trichy.

                The cost of travel is Rs.7 or Rs.8
  • Secondly you need to catch the Veeralimalai Bus  from Central Bus stand, Trichy.


  • Goverment college of Engineering , Srirangam Bus stop name :Sethurapatti 


  • There was totally 15 stops to reach the destination
    • Trichy Junction
    • Police Battalion
    • Craw ford
    • SBI stop
    • Ramachandra Nagar
    • Saranathan Engineering college
    • Leyland Service
    • Mekkudi
    • Kokila Colony
    • Autthu palam
    • Central Market
    • Venu's Township
    • Nagamangalam
    • Alandhur
    • Government College of Engineering, Srirangam, Sethurappati
              The cost of travel is Rs 14 or 15.




  • The total duration from Chattram to Goverment College of Engineering, Srirangam is around 1 Hour.

Viralimalai Bus available Time:

  • 9.00 A.M