Vesrn Technologies

In Excel, I have learned some functions, these are  Financial Functions: 1) PMT     Ex: =PMT(10%,3,10000) Returns -402.11 2) Rate      Ex:  = RATE (6, -200, 1000, 0.1)         = 5% Logical Functions: 1) And Ex:     =AND(m>25,m<50)      here m value must greater than 25 and less than 50. 2) OR Ex:     =OR(m>25,x>50)     here m value greater than 25 or x value greater than 50.  3) NOT Ex:     =NOT(x>25)     here x value is not greater than 25 Text Functions 1) UPPER Ex:     =UPPER("vesrn")               Returns VESRN 2) TRIM    Ex:     =TRIM(" vesrn ")               Returns vesrn 3) PROPER     Ex:     =PROPER("vesrn technologies")               Returns Vesrn Technologies

  Create, Open, Edit, Save, Save As in MsExcel work book Creating new Workbook :       Open Excel Workbook --> Click on Office Button --> Select New Option Open Workbook     Open Workbook --> Click on Office Button ---> Select Open Workbook --> Choose existing workbook Save Workbook     Click on Office Button ---> Select Save option ---> Dialogbox will appear and give customized name              and click on the save button. Save As Workbook     Click on Office Button --> Select SaveAs option --> Dialogbox will appear and give customized name            and click on the save as button.

 MS-Word Shortcut Keys I practiced so many times these shortcut keys . To do this Press Open  document. Ctrl+O Create  new document. Ctrl+N Save  document. Ctrl+S Close document. Ctrl+W Cut the selected content to the Clipboard. Ctrl+X Copy the selected content to the Clipboard. Ctrl+C Paste the contents of the Clipboard. Ctrl+V Select all document content. Ctrl+A Apply bold formatting to text. Ctrl+B Apply italic formatting to text. Ctrl+I Apply underline formatting to text. Ctrl+U Decrease the font size by 1 point. Ctrl+Left bracket ([) Increase the font size by 1 point. Ctrl+Right bracket (]) Center the text. Ctrl+E Align the text to the left. Ctrl+L Align the text to the right. Ctrl+R Cancel a command. Esc Undo the previous action. Ctrl+Z Redo the previous action, if possible. Ctrl+Y Adjust the zoom magnification. Alt+W, Q, then use the Tab key in the  Zoom  dialog box to go to the value you want. Split the document window. Ctrl+Alt+S Remove the document window split. Alt+Shift+C o