Computer: computer is an electronic device that accepts data as input process it at gives information as output.
Computer hardware:
computer contains three devices. Input device: that gives instruction to the computer. Ex: mouse and keyboard. CPU: CENTRAL PROCESSING UNIT. It contains three units. Alu (arithmetic and logical unit): to perform calculations and comparisons. CU (control unit): to control the entire computer. Memory unit: where the data is stored. Computer understands machine language that is binary system contains 1's and 0's. This is called binary digit (or bit). Memory measurement 8bits: 1byte 1024 bytes: 1 kilo byte 1024 kilo bytes: 1 mega byte 1024 mega bytes: 1 gega byte 1024 gega bytes: 1 tera byte Output device: to get the output of the the data that the system system processed. Ex: monitor, printer. When we switch on the computer. The screen that appears on the monitor is divided into two parts. Desk top: contains icons of applications. So that the user can open certain application directly by double clicking on that icon that represents the application. Task bar: that contains start button and clock. It shows all the applications opened by the user. Folder: folder is a container to hold file file and folders. How to create a folder on desk top: 1) Right click on the empty space on the desk top. 2) Pop up menu appears. Select new-> folder option 3) Type the folder name u want to give it. How to create a shortcut for ms-word Click on start button->all programs -> msoffice ->msoffice word 2003 -> right click -> send to -> desktop (create shortcut) How to change the background or wallpaper of the desktop: 1) Right click on the empty space of the desktop 2) Context menu or popup menu appears 3) Select properties option from the menu 4) Display properties window appears 5) Go to desktop tab 6) Select the picture from the background list box 7) Click on OK button or o r press enter key.
Screen saver: A moving picture or pattern that appears on your screen when you have not used the mouse or keyboard for a specified period of time. How to set the screen saver: 1) Right click on the empty space of the desktop 2) Context menu or popup menu appears 3) Select properties option from the menu 4) Display properties window appears 5) Go to screen saver tab 6) Select the screen saver from the dropdown list box. 7) The number of minutes specified in Wait will make the screen saver to appear on the screen if the computer is idle for the time limit that has been specified in wait. 8) Click ok button
Msword - document file File extension - .doc File contains - pages or papers Used to store text data.
Msexcel - workbook File extension - .xls File contains - work sheets Used to store numeric data Mspowerpoint - presentation File extension - .ppt File contains - slides Used to prepare presentation
Edit Menu
1) Undo: this this is to undo undo or cancel cancel or delete delete or discard discard the last last action action u have done within our document. (Ctrl + Z) 2) Redo: this this is to to redo the action action that u have undo in the the document. document. (Ctrl (Ctrl + Y) 3) Cut: to move move selected selected content content from one one location location to another another using using cut and paste paste options. (Ctrl + X) 4) Copy: this this is to to make duplicat duplicatee copy of the selecte selected d content in in your document document using copy and paste options. (Ctrl + C). 5) Paste: Paste: this is is to paste paste the selected selected content content that has has been selected selected using using cut or copy copy option. (Ctrl + V) 6) Office Office Clipboard: Clipboard: this this is a panel panel which contain containss the slots slots of contents contents that that have been cut or copied. It can contain 24 multiple different contents. 7) Clear: a. Format Formats: s: to clear clear the the format format of selec selected ted conte contents nts.. b. Contents: Contents: to delete delete the selected selected contents contents from from the the document. document. (del) (del) 8) Select Select All: to to select the the entire entire contents contents within within the document document.. (Ctrl + A) 9) Find: to find find certain certain text within within your documen document. t. (Ctrl (Ctrl + F). 10) Replace: to replace some text with with given text. (Ctrl + H). 11) Goto: to go to a particular page, or section, or bookmark etc. (Ctrl + G)
View Menu:
1) There There are are 5 view to to view view a documen document. t. They They are are a. Normal b. Web Layout c. Print La Layout d. Read Readin ing g Lay Layou outt e. Outline 2) Task Pane: Pane: to view the the task pane pane onto to right right side side of the window. window. 3) Tool Bars: Bars: to to view the the tool bars bars existi existing ng with in msword. msword. 4) Rule Ruler: r: to to view view the the rule ruler. r. 5) Document Document map: List List all the the heading within within the documen document. t. Document Document headings headings must be formatted with built-in heading styles in order to display in the Document Map. Click a heading in the Document Map you want to navigate to. The insertion point in the document will move to the selected heading. 6) Thumbnails Thumbnails:: to view all all the pages towards towards the the left side side of the the window. And And navigate using the pages. 7) Header and and Footer: Footer: to view the the header and and footer of of the document document where where you can insert a title, author name, page number, number of pages, time and date. 8) Footno Footnotes tes:: to view view footn footnote otes. s. 9) Full Screen: Screen: to view your your document document in a full full screen. screen. 10) Zoom: You can "zoom in" to get a close-up view of your document or "zoom out" to see more of the page at a reduced size.
Insert Menu:
1. Break: Break: to to have have a page page break. break. (Ctr (Ctrll + Enter Enter)) 2. Page Number: Number: to insert insert page page number into the the footer footer and we can format format the page page number such as integer, roman number, alphabet. We can decide the position of page number such as left, centre, right, outside, inside. 3. Date and and Time: to insert insert current current date date and time time into into your document. document. 4. Auto Auto text text:: to to inse insert rt auto auto text text.. 5. Symb Symbol ol:: to ins inser ertt a symb symbol ol.. 6. Pictu Picture: re: to insert insert a pictu picture. re. 7. Text Text box: box: to ins inser ertt a text text box. box. 8. Diagra Diagram: m: to insert insert a diag diagram ram.. 9. File: File: to insert insert the the entire entire content content of a file into into your your document. document. 10. Object: to insert an external external object such as Calendar, Excel chart, chart, Video clip etc. 11. To insert insert an an index index a. prep prepar aree the the doc docum umen entt b. go to insert insert->r ->refe eferen rence-> ce->ind index ex and tables tables c. inde index x and and tabl tables es win windo dow w is open open d. clic click k on Mark Mark ent entry ry butto button n e. Mark Mark Inde Index x Entr Entry y windo window w is open open f. select select the headin heading g from from your your docum document ent g. click on the Main entry text box and click on Mark Mark button button h. continue continue the 6th and and 7th steps steps until u mark all the the headings headings i. Clos Closee the the windo window w of mar mark k entr entry y inde index. x. j. place place the curso cursorr in the the first first page where where u want want to inser insertt the index index k. go to inser insertt->re >refer ferenc ence->i e->index ndex and and tables tables l. Select Select the the format format of of the inde index x and no. no. of colum columns ns of the the index. index. m. clic click k on OK OK butt button on 12. To insert insert a bookmark bookmark a. place place the the curso cursorr in front front of the headin heading g b. go to to ins inser ertt->bo >book okma mark rk c. type type the the nam namee of the the book bookma mark rk d. clic click k on on ADD ADD butt button on 13. To insert a hyperlink. hyperlink. We can create 3 types of hyperlinks a. link link wit withi hin n your your docum documen entt i. sele select ct the the tex textt to to whi which ch u want want to plac placee crea create te a lin link k ii. ii. u can can link link wit with h in the the docu docume ment nt usi using ng boo bookm kmar ark k or by by usin using g heading iii iii. go to inser nsertt->h >hyp yper erli link nk iv. iv. Edit dit Hy Hyper perlink link win windo dow w is is ope opene ned d v. Sele Select ct Pla Place ce in thi thiss docu docume ment nt slo slott from from the the lef leftt side side of the the window. vi. vi. sele select ct the the book bookma mark rk or or head headin ing g for for whic which h u want want to to crea create te the the link vii. click OK button b. link link to anot another her file file
i. ii. iii. iii. iv. c. link ink to to i. ii. iii. iii. iv.
Sele Select ct the the text text to whi which ch u wan wantt to plac placee crea create te a lin link k Select Select Existi Existing ng File File or Webp Webpage age slot slot from from the left left side side of of the the window. Sele Select ct the the fil filee with with in in u syst system em to to whic which h u want want to to link link Click on OK button a web web pag pagee Sele Select ct the the text text to whi which ch u wan wantt to plac placee crea create te a lin link k Select Select Existi Existing ng File File or Webp Webpage age slot slot from from the left left side side of of the the window. At the bottom bottom of the the wind window ow in in Addre Address ss text text box box type type the the whol wholee website address to which u want to link Click on OK button
Format Menu:
1. Font: to format format the the font of of the select selected ed content. content. Short Short cut keys keys of font: font: Bold: Ctrl + B Italic: Ctrl + I Underline: Ctrl + U Underline only words: Ctrl + Shift + W Double underline: Ctrl + Shift + D Increase font size by 2: Ctrl + Shift + > Decrease font size by 2: Ctrl + Shift + < Increase font size by 1: Ctrl + ] Decrease font size by 1: Ctrl + [ All Caps: Ctrl + Shift + A Small Caps: Ctrl + Shift + K To superscript: Ctrl + Shift + = To subscript: Ctrl + = To select font style tool on the formatting toolbar: Ctrl + Shift + F To select font size tool on the formatting toolbar: Ctrl + Shift + P To copy the format pattern of the text: Ctrl + Shift + C To paste the format pattern on to the text: Ctrl + Shift + V To clear the format: Ctrl + Spacebar 2. Paragraph Paragraph Format: Format: to format format the the selected selected paragraph paragraph Alignment: i. Left: Ctrl + L ii. Center: Ctrl + E iii. Right: Ctrl + R iv. Justify: Ctrl + J b. Line Spacing i. Single Line: Ctrl + 1 ii. 1.5 inch Line Spacing: Ctrl + 5 iii. Double Line Spacing : Ctrl + 2 c. Clear Paragraph Formatting: Ctrl + Q
To create index 1) Prepare the document 2) Go to insert->reference->index and tables 3) Index and tables window is open 4) Click on Mark entry button 5) Mark Index Entry window is open 6) Select the heading from your document 7) Click on the Main entry text box and click on Mark button 8) Continue the 6th and 7th steps until u mark all the headings 9) Close the window of mark entry index. 10) Place the cursor in the first page where u wants to insert the index 11) Go to insert->reference->index and tables 12) Select the format of the index and no. of columns of the index. 13) Click on OK button Create bookmark 1) Place the cursor in front of the heading 2) Go to insert->bookmark 3) Type the name of the bookmark 4) Click on ADD button Create hyperlink We can create 3 types of hyperlinks 1) Link within your document 2) Link to another file 3) Link to a web page 1) Link within your document a) Select the text to which u want to place create a link b)u can link with in the document using bookmark or by using heading c) Go to insert->hyperlink d) Edit Hyperlink window is opened e) Select Place in this document slot from the left side of the window. f) Select the bookmark or heading for which u want to create the link e) Click OK button 2) Link to another file a) Select the text to which u want to place create a link b) Select Existing File or Webpage slot from the left side o f the window. c) Select the file with in u system to which u want to link d) Click on OK button 3) Link to web page a) Select the text to which u want to place create a link b) Select Existing File or Webpage slot from the left side o f the window. c) At the button of the window in Address text box type the whole website address to which u want to link d) Click on OK button
Macro: Macro is a set of instruction grouped together and executed in one stroke or at one run. To create Macro 1) Plan the instructions 2) Create a blank document 3) Go to tool menu->macros->record new macro 4) Record macro window appears 5) Type the name of the macro 6) Click on Toolbars button 7) Customize window is opened 8) Go to Toolbars (tab) and click on new button to create a new tool bar by specifying spec ifying the name of the toolbar. 9) Go to Commands (tab). Drag the macro tool from commands panel and place on the toolbar. 10) Click on Keyboard button and an d assign shortcut key for the macro and close the windows 11) Give the instructions within the document. 12) Click on stop recording tool on the Stop recording tool bar. 13) Thus the macro is created. How to run a macro 1) Go to tool menu -> macros -> macros 2) Select the macro name and click on run button (Or) 1) Click on the tool on the macros toolbar u has created. (Or) 1) Press the shortcut key u have assigned for the macro Template is a preformatted content file that can be used any number of times to create a new file using that content. How to create a template 1. Type the common content into the document. 2. Go to file menu -> save as 3. In save as window. At the bottom select document template option for Save as type. Then provide file name. And it is saved under templates folder. How to create a file using template 1. Go to file->new. Click on my computer link at the right side panel under templates category. And select the template. And click on ok button
To fill numeric series A) Option1 1) Provide two initial numbers in the series. 2) Select the cells which contains the two numbers 3) Place the cell pointer at the bottom right of cell such that it converts into fill handles using the mouse 4) Drag the mouse until u gets the required series.
b) Option2 1) Provide the first number in the series 2) Select the cell where the number is placed 3) Go to edit menu->fill->series 4) Series window is open 5) Select the option of rows or columns in which u want to place the series. 6) Type the number in step value to generate the series I) positive number for increasing series ii) Negative number for decreasing series 7) Provide the last number in the series at stop value 8) Click on OK button. Template is a preformatted content file that can be used any number of times to create a new file using that content. How to create a template 1. Type the common content into the worksheet. 2. Go to file menu -> save as 3. In save as window. At the bottom select template option for Save as type. Then provide file name. And it is saved under templates folder. How to create a file using template 1. Go to file->new. Click on my computer link at the right side panel under templates category. And select the template. And click on ok button
Logical functions 1) And Syntax: =AND (cond1, cond2, cond3,) And function is used to combine more than one condition where all the conditions should be true. It returns TRUE or FALSE value 2) Or Syntax: =OR (cond1, cond2, cond3,) Or function is used to combine more than one condition where any one of the conditions should be true. It returns TRUE or FALSE value. 3) If Syntax: =IF (cond, truepart, falsepart) In if function true part is evaluated or calculated if the condition is true and false part is evaluated or calculated if the condition is false. 4) Not Syntax: =NOT (condo) Not function is used to find negation of a condition. It returns TRUE value if the condition is false and returns FASLE value if the condition is true.
A scenario is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results. Consolidate To consolidate data, you combine the values from several ranges of data.
