Vesrn Technologies

COPA Computer Operator and Programming Assistant (COPA) Exp No Trade Practical Trade Theory CBT Exam Study Material Video Lesson 1 1 1 Study Material Video Lesson 2 2 2 3 3 3 4 Installing Window Operating System Operating System 5 MS-DOS Commands Operating System 6 Linux Commands Operating System 7 Create new document, open existing document, edit document and save the documents Ms Word 8 Formatting text, inserting objects, tables, hyperlinks, autocorrect features, thesaurus, spelling and grammar Ms Word 9

 About My ITI Slide - 1 Welcome to ITI Govt. ITI., Salur, Viziangaram Dist. Slide - 2 Administration Slide - 3 Trades

  Slide Transition : Select the slide you want to add a transition to. Select the Transitions tab and choose a transition. Select a transition to see a preview. Select Effect Options to choose the direction and nature of the transition. ... Select Preview to see what the transition looks like. You can add an animation to grouped objects, text, and more. Press Ctrl and select the objects you want. Select Format > Group > Group to group the objects together. Select Animations and choose an animation. Insert an embedded object Click in the slide where you want to place the object. On the Insert tab, in the Text group, click Object. Do one of the following: If the object does not already exist, click Create new. ... Do one of the following: To display the content in your presentation, clear the Display as icon check box.

  How to open MS PowerPoint, Edit, Save Powerpoint presentation In Windows 8/above: Step 1:  Press  Windows + c  to open the search bar Step 2:  Type  PowerPoint  & click on the  MS Office  version you are having in your system. MS Office window will pop up. In Windows 7 or below: Step 1:  Go to the program section in the windows start menu. Step 2:  Go to  MS Office  & click on it. A drop-down list is seen Step 3:  Click on  MS PowerPoint  & MS PowerPoint window will pop up. Creating a Presentation Once your MS PowerPoint Window pops up, you can create & save the file by: Step 1:  Click on the  Microsoft  button on the top left. Step 2:  Click on  new , a new Presentation window will pop up. Step 3:  Click on  Create  & a new presentation will be created. Note:  Shortcut for New:  Ctrl +n Saving a Presentation Once you have created a presentation, it can be easily saved with the help of following steps: Step 1:  Click on the  Microsoft  icon Step 2:  Click on the 

Opening Ms-Paint Application: Procedure  Choose Start > Search> Paint to open the main Paint Window. Title Bar:                      It is positioned top of windows. It shows the name of the application, document                 or File name. Menu Bar:                   It is positioned below the title bar. It contains File, Edit, View, Image, Options,                   and Help etc. Tool Box                   It has 16 Tools like Pencil, Eraser, and Line Etc. We can you these tools for                   Drawing Something. Color Box- It has many Colors. You can you these Colors for your painting. Status Bar- It shows the status of our Mouse Pointer and other options. Scroll Bar: [Horizontal and Vertical]:         We used this option when the document does not fit in the window or Zoomed. Minimize Button:         With the help of this option you can reduces the window to an icon and         arranges it on the desktop. This option does not quit the application. Maximize Button

 Sample Project using Excel for Employee salary Bill I have completed all things for Employee Salary Bill HRA --> 12% DA --> 26% TA --> 5% PF - 14% IT - 11% Gross = HRA + DA + TA NET = GROSS - (PF + IT)

 I have learned how to create charts, applying filters, sorts, and pivot tables in ms excel Create a chart Select data for the chart. Select  Insert  >  Recommended Charts . Select a chart on the  Recommended Charts  tab, to preview the chart. Select Chart OK Create Filter Select any cell within the range. Select Data > Filter. Select the column header arrow . Select Text Filters or Number Filters, and then select a comparison, like Between. Enter the filter criteria and select OK. Sort text Select a cell in the column you want to sort. On the  Data  tab, in the  Sort & Filter  group, do one of the following: To quick sort in ascending order, click   ( Sort A to Z ). To quick sort in descending order, click   ( Sort Z to A ). Create a PivotTable in Excel for Windows Select the cells you want to create a PivotTable from. Note:   Your data should be organized in columns with a single header row. Select  Insert  >  PivotTable . This will create a PivotTable based on an existi

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

  Formatting Text in MsWord Open the document, and apply different formatting to selected text. Bold : Select the text and apply Bold option, it results the text will display in boldness Italic : it result the text will display italic formatting Underline: Applies underline to selected text Alignments: left, right, center, justify Applying different font features: Font Color, Font Face, Font Size Inserting Objects: I am also inserting objects from my custom files to current document. like, Microsoft Equation, Bit map image e.t.c., Insert --> Objects --> Select Create new Tab or Create from file tab from dialogbox.  Tables I am also learned how to draw tables in Msword. Select Insert Menu--->Choose Table option -- > Insert Table--> Then a dialog box will appear, and I will give rows and columns from spinning boxes. Inserting  Hyperlink Select the text and select Insert Menu -- > Links --> Hyperlink option. Then dialog box will appear and select required file we

Mail Merge Using Mail Merge, you can easily customize form letters for individual recipients. Mail merge is also used to create envelopes or labels in bulk In a blank Microsoft Word document, click on the  Mailings  tab, and in the  Start Mail Merge  group, click  Start Mail Merge Click  Step-by-Step Mail Merge Wizard Select your document type. In this demo we will select  Letters . Click  Next: Starting document . Select the starting document. In this demo we will use the current (blank) document. Select  Use the current document  and then click  Next: Select recipients . Note that selecting  Start from existing document  (which we are not doing in this demo) changes the view and gives you the option to choose your document. After you choose it, the Mail Merge Wizard reverts to  Use the current document Select recipients. In this demo we will create a new list, so select  Type a new list  and then click  Create . Create a list by adding data in the  New Address List  dialog box and cl