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 pres...

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. Scro...

 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. Sele...

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 Techn...

  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 t...

  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 re...

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...