Digital Book class-6 2nd edition With Coding

["To Start MS-Word. Steps to Follow: Step-1\t:\t Type the Ms-word in search box. Step-2\t:\t You get Ms-Word App. Step-3\t:\t Click the Ms-Word App. Step-4\t:\t Now, you get document template. Step-5\t:\t Click the 'Blank document' template. The blank document Ms- word starts. To know the components of Word Screen. Quick Access Tool bar Tabs Ribbon Title Bar Control Buttons Horizontal Ruler Up\/Down Scroll bar Document Area Vertical Ruler Status Bar View Buttons Zoom Slider Smart Computer Science Book-6 145","Create New Document Steps to follow: Step-1 : Click the 'File Tab'. Step-2 : Click the 'New' Step-3 : Click the 'Blank Document' Step-4 : Type the following paragraph. Lab Activity Save a Document Steps to follow: Step-1\t:\t Click the 'File Tab' Step-2\t:\t Click the 'Save As' option. Step-3\t:\t Click the Browse option. You get 'Save as' dialog box. Step-4\t:\t Type a file name and click the 'Save' button. Tricks & Tips To save a document with new name, you have to select 'Save As' command, then displays Save As dialog box. To save a document with same name, just you have to use 'Save' command. 146 Word Processing","Close Your Document Steps to follow: Step-1\t:\t Click the 'File Tab'. Step-2\t:\t Click the 'Close' option. Now, your document is closed down. Open Your Document Steps to follow: Step-1\t:\t Click the 'File Tab' Step-2\t: \t Click the 'Open' option. Step-3\t:\t Click the 'Browse' button and find your file, and select and Click the 'Open' button. Step-4\t:\t Now, you can work in the document. Save Document in New Name Steps to follow: Step-1\t:\t Click the 'File Tab'. Step-2\t:\t Click the 'Save As' option. You get 'Save as' dialog box. Step-3\t:\t Find your drive and folder by clicking on 'Browse' button. Step-4\t:\t Type your new file name and click the 'Save' button. Page Setup\/Formatting Page setup is a set of specific parameters involving the display and layout of a printed page. These parameters include page margins, orientation, paper size and layout. Smart Computer Science Book-6 147","Steps to Follow: Step-1\t:\t Click the 'Layout' tab. Step-2\t:\t Find the 'Page Set- up' group. Step-3\t:\t Click the 'Drop down' button of Margins. Step-4\t:\t Click the 'Custom Margin'. You get a 'Page setup' dia- log box. Step-5\t:\t Apply the top, bot- tom, left and right margins value as given. Step-6\t:\t Select the orienta- tion. Step-7\t:\t Click on 'Paper' tab of dialog box. Step-8\t:\t Select the paper size: A4 by clicking on drop down button. Step-9\t:\t Finally click the 'Ok'. Lab Activity 1. \tOpen a document that you have saved as file named article and change the page setup parameters as follows: \u2022\t Top and Bottom Margin 0.75 inch. \u2022\t Left and Right margin 0.5 inch. \u2022\t Orientation: Portrait. \u2022\t Paper size : A4 148 Word Processing","Fast Access a. Ctrl+N : To Create new document b. Ctrl+S : To save a file c. Ctrl+X : To exit from MS-Word. Knowledge Test 1. Answer the following questions: a.\t Why do you use office button? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... b.\t What do you mean by page formatting? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... c.\t Where do you find 'Page setup' commands? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... d.\t Differentiate between portrait and landscape orientation. Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... .................................................................................................................................... FORMATTING DOCUMENT Formatting document refers to arrangements of content such as text, image, layout of page, table, charts, artistic work, etc. The formatting document includes the following types: 1. Character Formatting 2. Table Formatting 3. Paragraph formatting 4. Picture or image formatting 5. Page formatting (header, footer, page number, margin, column, etc) Smart Computer Science Book-6 149","Character Formatting Character formatting in MS-Word refers to apply formatting properties to enhance the appearance of individual text characters. It can be applied to a single character, word, sentence or a line of text without affecting the entire current paragraph. Character formatting includes those you find in the Font dialog box (such as bold, italic, underline, font, size, color, superscript, subscript, scaling, animation effects, etc.) highlight, change case, etc. Steps to follow: Step-1\t :\t Click the 'Home' tab from the ribbon. Step-2\t:\t Highlight the text in which you apply the formatting. Step-3\t:\t Find the 'Font' group. Step-4\t :\t Select the desire Formatting options. Step-5\t :\t You can activate Font dialog box by clicking on 'Flyer' button of 'Font Group' and change a lot of character formatting parameters. Lab Activity 1. \tType the following text and format as indicated: Character Formatting Character formatting in MS-Word refers to apply formatting properties to enhance the appearance of individual text characters. It can be applied to a single character, word, sentence or a line of text without affecting the entire current paragraph. Character formatting includes those you find in the Font dialog box (such as bold, italic, underline, font, size, color, superscript, subscript, scaling, animation effects, etc) highlight, change case, etc. 150 Word Processing","Fast Access c. Ctrl+U : To make underline a. Ctrl+B : To make Bold b. Ctrl+I : To make Italic Paragraph Formatting Paragraph formatting is a change appearance of text that affects the complete paragraph. You get the paragraph formatting parameters in the paragraph formatting dialog box as well as paragraph group of Home tab in the ribbon. It includes, line spacing, paragraph spacing, indenting, alignment, etc. Steps to follow: Step-1\t :\t Highlight the text in which you want to apply the formatting. Step-2\t:\t Click the 'Home' tab from the ribbon. Step-3\t:\t Find the 'Paragraph' group. Step-4\t:\tSelect the desired Formatting options and change their parameters. Step-5\t:\tYou can activate Paragraph dialog box by clicking the 'Flyer' button of 'Paragraph Group' and change a lot of paragraph formatting parameters as you like. Step-6\t :\t Click the 'Ok' button. Smart Computer Science Book-6 151","Lab Activity 1.\t Create a new document and type an application to your class teacher to grant two days sick leave. You have to format your document in the basis of given parameters: \u2022\t Font face is 'Arial', size is 11 pt. and multiple line spacing with the value 1.3 pt. for whole text \u2022\t Address and Date: Right alignment \u2022\t Heading declaration: Left alignment. \u2022\t For the Subject: Font size is 13 pt., Center alignment, Bold, Underline, Paragraph spacing after\/before by 12 pt \u2022\t Body text: Justify alignment, Paragraph spacing Before\/After 6 pt., and Indentation Special first line by 0.5\\\" \u2022\t Closing detail: Right alignment \u2022\t Finally, document looks like as given below Motigada 15th August 2021 The Class Teacher, Motigada English Boarding School, Giaghat, Motigada. Sub: Application for leave Dear Sir, \t I'm sorry to inform you that I had a minor accident yesterday. I fell on rock while I was playing in the playground located in front of Bagha Chowk. I got small cut in my leg. I cannot walk because of the pain. The doctor says I shall be able to walk after two or three days. I hope I will be able to attend school after two days. \t I request you to grant me leave of absence for this period. Your Obediently Pranjal Khadka Grade:VI Section : A Roll: 2 152 Word Processing","Knowledge Test 1. Answer the following questions: a. What do you mean by formatting document? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... .................................................................................................................................... .................................................................................................................................... .................................................................................................................................... b.\t Differentiate between paragraph formatting and character formatting. Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... c.\t What do you mean by alignment? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... d.\t What do you mean by indentation? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... .................................................................................................................................... e.\tHow many types of spacing can you set in word document? Name them. Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... Smart Computer Science Book-6 153","f.\t What do you mean by character formatting? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... g.\t Where do you find the parameters of character formatting? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... h.\t What are the parameters of character formatting? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... News Paper Style You have seen that all newspapers and many magazines present article and news in more than one column. This is because shorter lines always aid the eye and increase reading speed. MS-Word also support to create a document in two or more columns. Steps to Follow: Step-1\t :\t Select the typed text. Step-2\t:\t Select 'Layout' tab. Step-3\t:\t Find 'Page setup' group. Step-4\t:\t Click the 'Columns' drop down button. Step-5\t:\t Select and click the 'More columns' option. You get the column 154 Word Processing","dialog box as given. Step-6\t:\t Set the number of columns. Step-7\t:\t Change other parameters from dialog box as you need. Step-8\t:\t Click the 'ok' button. Lab Activity 1.\t Create a new document and prepare the two columns news article as given by using page formatting, character and paragraph formatting features. Ebola vaccine trials next month: UN PARIS: Clinical trials of a preventive the start of clinical trials, first in the vaccines for the Ebola virus United States and certainly African made by British pharma company countries, since that's where we have GlaxoSmithKline may begin next the cause,\\\" Jean Marie Okwo Bele, month and made available by 2015, the WHO's head of the vaccines and the world health organization said on immunization, told French radio. He Saturday . said he was optimistic about making the vaccine commercially available. \\\"We are targeting September for (AFP) Knowledge Test 1. Answer the following questions: a. Why do you create newspaper style? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... Smart Computer Science Book-6 155","b.\t Where do you get commands to create news paper style? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... c.\t How many columns are supported by MS-Word by default? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... d.\t Write the name of parameters of News paper style dialog box. Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... .................................................................................................................................... CREATING AND FORMATTING TABLE Sometimes you have to present your data in tabular form. In such a case, MS-Word supports you to create and formatting table. Create\/Insert Table Steps to Follow: Step-1\t:\t Select 'Insert' tab. Step-2\t:\t Find 'Tables' group Step-3\t:\tClick the drop down button of 'Table' icon. Step-4\t :\t Click the 'Insert Table' option. You get a 'Insert Table' dialog box. Step-5\t:\tEnter number of columns and number of rows. 156 Word Processing","Step-6\t:\t Click the 'Ok' button. Step-7\t:\t Now, you get your table of given number row and columns. Lab Activity 1.\tCreate a table with 4 columns and 5 rows and enter name, roll numbers, class and section of four friends and save with file name 'mytable' . Name Roll Class Section Tarakant 01 VI A Misrilal 02 VI B Santu 06 VI A Pemba 08 VI B Modify the table Structure Once you have created a table, sometimes it may need to modify and reformat. Modify table means adding or deleting row and columns, in- creasing and decreasing the row height and column width and merging rows and columns. Insert one more column Step-1\t:\t Click the desire column, where you want to insert a column. Step-2\t:\t Click the 'Layout' tab. Step-3\t:\t Find the Rows & Col- umns group. Step-4\t:\t Click the 'Insert column to Right\/Left' button. Step-5\t:\t Now, You get new column on which you click to insert. Smart Computer Science Book-6 157","Insert one more row Step-1\t :\t Click the cell of row where you insert row. Step-2\t:\t Click the 'Layout' tab. Step-3\t:\t Find the 'Row and Columns' group. Step-4\t:\t Click the 'Insert Rows Above\/Below' button. Now, you get new row. Merge Multiple Cell of Step-1\t:\t Select Multiple Cell. Step-2\t:\t Find 'Merge' group 'Layout' tab. Step-3\t:\t Click the 'Merge Cell' Delete Cell Step-1\t:\t Select Cell. Step-2\t:\t Click the 'Layout' tab. Step-3\t:\tClick the drop down button of 'Delete' icon from 'Row & Columns' group. Step-4\t:\tSelect and click on 'Delete Row\/Column' option. Now you notice that your row is deleted. 158 Word Processing","Lab Activity 11. .OOppeennyo'Muyr tfailbele'm' fyilteabalned.dmoco'daifnydams ogdivifeynabsegloivwe:n below: Student's Detail Name Roll Class Section House Tarakant 01 VI A Red Misrilal 02 VI B Green Santu 06 VI A Blue Pemba 08 VI B Green Tasi 09 VI B Red Knowledge Test 1. Answer the following questions: a.\t When do you create table? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... b.\t What do you mean by row? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... c.\t What do you mean by column? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... Smart Computer Science Book-6 159",".................................................................................................................................... .................................................................................................................................... d.\t When do you merge cell? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... WORD ART (ARTISTIC WORD) WordArt is a text modifying feature in Microsoft Word. It includes effects such as shadows, outlines, colors, gradients, and 3D effects that can be added to a word or phrase. WordArt can also bend, stretch, skew, or modify the shape of the text. Now, Let's discuss how to insert WordArt into the document. Insert WordArt Steps to Follow: Step-1\t:\t Select 'Insert' tab. Step-2\t:\t Click the dropdown button of 'WordArt' from Text group. You get WordArt gallery. Step-3\t:\t Select the WordArt style that you want. Step-4\t:\t Type your text for WordArt. 160 Word Processing","Throw Option 161 Steps to Follow: Step-1\t:\t Click the object. Step-2\t:\t Click the 'Format' tab. Step-3\t:\t Find 'Arrange' group. Step-4\t:\tClick the drop down button of 'Text Wrap' from 'Arrange' group. Step-5\t:\t Click the 'Throw' option. Step-6\t:\t Now you can easily move your object. Resize the Object Steps to Follow: Step-1\t:\t Click the object once. Step-2\t:\t You get different types of selection handle. Step-3\t:\t Click and drag the resizing handle as you like. Editing WordArt Steps to Follow: Step-1\t:\t Right mouse click on the WordArt object. Step-2\t :\t Click the 'Edit Text' option. Step-3\t:\t You get 'Edit WordArt Text' dialog box. Step-4\t:\t Now, you can change font face, font size as well as Text. Smart Computer Science Book-6","Grouping the Object Steps to Following Step-1\t:\tSelect the mul- tiple objects with 'CTRL+Click'. Step-2\t:\t Right mouse click on the selected object. Step-3\t:\t Got to the 'Group' option, and Click the 'Group'. Lab Activity 1.\t Using WordArt feature write your name in different style as given and save with file 'myname'. Formatting WordArt Steps to follow: Step-1\t :\t Click the object. Step-2\t :\t Click the 'Format tab' from 'Drawing Tools'. Step-3\t :\t You can select the desire option from 'Word Art style' group. Step-4\t :\t You can set the 'Text fill', Text Outline, Text Effects'. 162 Word Processing","Lab Activity 1. Insert WordArt for heading and format your document as given: WordArt is a text modifying feature in Microsoft Word. It includes effects such as shadows, outlines, colors, gradients, and 3D effects that can be added to a word or phrase. Change the Shape of object: Steps to follow Step-1\t:\t Insert your WordArt. Step-2\t:\t Click the object. Step-3\t:\t Click the 'Format' tab. Step-4\t:\tClick the drop down button of 'Changes Shape' icon from 'WordArt Style' group. Step-5\t:\t You get different types of shapes. Step-6\t:\tSelect your required shapes as given. Lab Activity 2.\t Insert the WordArt and change the shape of object as given below: \u2022\t Circle \u2022\t Double wave1 \u2022\t Ring inside Smart Computer Science Book-6 163","Knowledge Test 1. Answer the following questions: a.\t What is the function of WordArt? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... .................................................................................................................................... .................................................................................................................................... b.\t Where do you get 'WordArt' command? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... c.\t Write some parameters included in formatting the WordArt. Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... d.\t Write the name of some shapes of WordArt. Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ................................................................................................................................. SHAPE You can add shape to your Microsoft Office document or combine mul- tiple shapes to make a drawing. Available shapes include lines, basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and callouts. After you add one or more shapes, you can add 164 Word Processing","text, bullets, numbering, and format them. Insert Shape Steps to Follow: Step-1\t:\t Click the 'Insert' tab. Step-2\t:\t Find 'Illustrations' group and click the drop down button of 'Shapes' icon. Step-3\t:\t Select your desired shape. Step-4\t:\t Move your cursor in your desire area. Step-5\t:\t Click and drag your mouse. Step-6\t:\t Now you get your shape as a drawing. To change the line style and color and fill with color. Steps to Follow: Step-1\t :\t Select you shape. Step-2\t:\t Click the 'Format' tab. Step-3\t:\t Find the 'Shape style' group. Step-4\t:\tYou can set 'Shapes Fill', 'Shapes Outline' and 'Shapes Effects'. Step-5\t:\t You can click the flyer drop down button to activate more feature of shapes formatting. You can adjust a lot of features. Smart Computer Science Book-6 165","To type inside the shape. Steps to Follow: Step-1\t :\t Select the Shape. Step-2\t :\t Right mouse click the shape Step-3\t :\t Select and click the 'Add Text' option from the menu. Step-4\t :\t Type your text. Step-5\t :\t Save your document with the file name. Apply Shadow Effect in the Shape Steps to follow: Step-1\t :\t Click the 'Shape'. Step-2\t :\t Click the 'Format' tab. Step-3\t:\t From 'Shapes Style' group. Step-4\t:\t Click the 'Shapes Effect' drop down button. Step-5\t:\tSelect the desired Shadow. Lab Activity 1. Draw rectangle shapes and using shape formatting technique, design the following ID card and save as the file name. Name \t : \t Puja Danuwar Photo Class \t : \t VI Roll \t : \t 14 Section \t: \t \\\"A \\\" School \t : \t Mt. Everest School, Lahan-3 166 Word Processing","Insert ClipArt ClipArt is a collection of pictures or images that can be imported into a document from online store. ClipArt galleries contains hundreds of thousand ready made images. To insert ClipArt follow the following steps. Steps to Follow: Step-1\t:\t Click the 'Insert' tab. Step-2\t:\t From the 'Illustration' group, click the 'Online picture'. You get the following dialog box. Step-3\t :\t Type ClipArt search 167 word in the search box. In this exam- ple it is typed, clip art of book. Step-4\t :\t You get this given dialog box with numbers of clip arts. Step-5\t:\t Select the desired clip art and Click the 'Insert' button. Now, notice clip art is inserted. Smart Computer Science Book-6","Lab Activity 1. \tCreate a new document and write an article about 'Scope of computer' and insert an image of computer from ClipArt. The document should be formatted as given below. A computer is one of the useful machines created by human being which has made our life easier. Computers have made a great impact on our everyday life. They have changed our lifestyle. Scope of computer today ranges from a simple video game to medical diagnosis, TV programs, weather forecasting, launching of satellites, data processing in offices and so on. Its presence is felt in almost every walk of life. Insert Image Image is the most important media for the document. So, it is necessary to insert images in the document. To insert an image, do the following: Steps to Follow: Step-1\t :\t Click the 'Insert' tab. Step-2\t:\t Click the 'Picture' icon from 'Illustration' group. Step-3\t:\tNavigate the picture's location. Step-4\t :\t Click the desire picture. Step-5\t:\t Click 'Insert' button. Step-6\t:\t Now, Format tab is activated. Step-7\t :\t On the 'Ribbion', 'Format' tab, 'Arrange group', Click the 'Text Wrapping' drop down button Step-8\t:\t Click 'Through' option from this menu. Step-9\t :\t Now, resize and move easily. 168 Word Processing","Lab Activity 1. \tPrepare the following document and save as the file name 'story'. The Greedy Lion It was an incredibly hot day, and a lion was feeling very hungry. He came out of his den and searched here and there for fool. He could find only a small hare. He caught the hare with some hesitation. \u201cThis hare can\u2019t fill my stomach\u201d thought the lion. As the lion was about to kill the hare, a deer ran that way. The lion became greedy. He thought; \u201cInstead of eating this small hare, let me eat the big deer.\u201d He let the hare go and went behind the deer. But the deer vanished into the forest. The lion now felt sorry for letting the hare off. Knowledge Test 1. Answer the following questions: a.\t What do you mean by ClipArt? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... b.\t Where do you get Insert Clip Art option? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... c.\t Where do you get insert Picture option? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... .................................................................................................................................... .................................................................................................................................... Smart Computer Science Book-6 169","Points to Know \u2022\t Word processing is an application program used to create, edit, format, print and store documents like, application, letter, article, magazine, etc. \u2022\t Page setup is a set of specific parameters involving the display and layout of a printed page. \u2022\t Character formatting in MS-Word refers applying formatting properties to enhance the appearance of individual text characters. \u2022\t Character formatting can be applied to a single character, word, sentence or a line of text, without affecting the entire current paragraph. \u2022\t Paragraph formatting is a change of the format of text that affects the complete para- graph or is different from other paragraphs in a document. \u2022\t Word Art is a text modifying feature in Microsoft Word. \u2022\t Clip art is a collection of pictures or images that can be imported into a document or another program. Terms to Know Word processing \t: \t Modification of text in electronic version Document \t : \t Collection of related information under a single roof Page Layout \t : \t An arrangement, plan or design of page Dialog Box \t : \t A window that appears on a computer screen, presenting informa- tion or requesting input Row \t : \t Horizontal arrangement of data or information Column \t :\t Vertical arrangement of data or information WordArt \t : \t Special effects in Microsoft Word that change the appearance of text Text Wrap \t : \tTo surround a picture or diagram with text ClipArt \t : \t Collection of ready made pictures or images that can be imported into a document Indentation\t:\tBlank spaces used to separate a paragraph from the left or right Orientation\t:\tDirection in which a document is displayed or printed Portrait\t:\tPage taller than wide Landscape\t:\tPage wider than height 170 Word Processing","Worksheet Objective Questions 1. Fill in the blanks: a. MS-Word is a .............................. ................................ application program. b. MS-Word comes with .................................................. package. c. ..............................................is a group of options dictating the way a document is formatted to print. d. Parameters of a character formatting available in........................... dialog box. e. .................. is a collection of pictures or flat images that can be inserted in the document. f. ..................................... is text modification feature in MS-Word. 2. State whether the following statements are true or false: a. MS-Word is developed by Microsoft Company. b. Row is a vertical arrangement of data. c. Column is a horizontal arrangement of data. d. Throw command is used to move object easily. e. Text wrap bind the object through text. f. ClipArt is a ready made picture. g. Page Layout is a plan of document's page. Descriptive Questions 1. Answer the following questions: a. Differentiate between Save and Save As command. Ans: ............................................................................................................................ Smart Computer Science Book-6 171","..................................................................................................................................... ..................................................................................................................................... b. What is Word processing? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... c. What is Ms-Word? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... d. Why do you use word processing software? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... e. Differentiate between character formatting and paragraph formatting. Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... 172 Word Processing","..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... f. What do you mean by Space After Before? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... g. What do you mean by line spacing? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... h. What do you mean by indentation? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... i. What do you mean by alignment? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... Smart Computer Science Book-6 173","j. What do you mean by news paper style of page? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... k. What do you mean by merging cell? Ans: ............................................................................................................................ ..................................................................................................................................... .................................................................................................................................... l. What dose modification of table include? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... m. What do you mean by grouping the object? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... n. Why do you use shape? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... o. Why do you use WordArt? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... 174 Word Processing","Case Study and Application-based Questions 1. Niru Ghale has inserted a picture in MS-word, but she is unable to move. When she tries to move, it doesn't move. Due to this problem, she can not complete her project work. Now, to solve this problem, what would you suggest her? Solution: ................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... 2. \tLakpa has inserted a Word Art, when he starts to resize that becomes skew, it does not resize properly, and it looks very funny and untidy. Now, what may be the problem of Lakpa? How would this problem be solved? Solution: ................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... 3. \tWhen Bismita starts typing in MS-Word, she is not getting anything. She is shocked ! When she types randomly, she only gets spelling error underlined. Now, what may be the problem Bismita faced? How would it be solved ? Solution: ................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... Smart Computer Science Book-6 175","Lab Project-1 a. Prepare the following time table: Daily - Time Table 1. Sunday Monday Tuesday Wednesday Thursday Friday 2. Nepali Nepali Nepali Nepali Byakaran Byakaran 3. Social Social Math-I Math-I Arithmetic Arithmetic 4. Math-II Math-II Math-II Computer Computer Computer 5. Eng-II Eng-II Eng-II Eng-I Grammar Grammar Break Time 6. GK GK Sports PL PL Library 7. Algebra Algebra Social Social ECA Social 8. Eng-I ENG-I ENG-I ECA ENG-I ENG-I 9. Science Science Sci-Lab Science Science Science b. Your School is planning to organize a charity fate on the auspicious festival of Bada Dashain. Design the following poster to display in the mela using WordArt and ClipArt . As far as possible draw a picture of Mata Devi in Ms-Paint and use here. 176 Word Processing","Lab Project-2 1. Prepare the following news Bulletin. HAMRO NEWS BOARD DAILY UPDATED Stop Child Labour psychologically and\/or morally harmful for children. Worldwide, as many as 152 Powering ships with million children plastic in Amsterdam have jobs. They earn a few for In the Port of hours and they Amsterdam, simply do not a new factory have enough is being built time to go to that could school and improve their future revolutionize prospects. the way we dispose of plastic waste. Utilizing ground breaking technology, 72 million children are forced to the facility will use previously work in dangerous and unhealthy unrecyclable plastic to create fuel for conditions. Terre des Hommes is diesel powered cargo ships. committed to millions of children who face these worst forms of child The group behind the facility is labour. These children are forced Bin2Barrel, a Dutch company to work in plantations, mines, founded in 2012 by waste factories, as domestic slaves, management entrepreneurs Floris etc. They perform exhausting Geeris and Paul Harkema. While the work for many hours in a row, chemical recycling technology used often in unhealthy and hazardous in the past has worked, Bin2Barrel conditions. The work is physically, is the first company to utilize it commercially. Smart Computer Science Book-6 177","Electronic Spreadsheet CHAPTER 11 Learn and Act.. Teacher\t: \tWell, listen to me, we heard computer is extremely intelligent. But how does computer analyze the data set, like, marks of students, income and expenses of home, and office, sales and purchase in business? Do you have any idea ? Miku\t : \tNo, Ma'am ! I have heard it is possible in computer, but how is it? Teacher\t : \tOf course! There are electronic spreadsheet programs, like a register. Its function is to maintain and keep records of data set. Very large scale of data calculation and imagination are possible in the electronic spreadsheet. Let's discuss it in detail. BASIC OF SPREADSHEET Spreadsheet is a software tool that lets us enter, calculate, manipulate and analyze sets of data which help to take right decision in the official financial activities. It consists of rows and columns. So, data are managed in tabular form. Once you enter data on a spreadsheet, you can perform different types of calculations such as arithmetic, trigonometric, statical and other calculation. MS-Excel, Lotus 1-2-3, Open Office Calc are example of Spreadsheet software. 178 Electronic Spreadsheet","Introduction of MS Office Excel MS Office Excel is one of the popular spreadsheet software which is developed by Microsoft company, in USA. It comes with MS-Office package. It is similar to the manual spreadsheet used by accountant with pencil, eraser, paper and calculator but it is in electronic version. It is useful in every office and business industry for entering, calculating, manipulating and analyzing data. Basic Features of MS Office Excel 1. \t Results-oriented user friendly interface\t 4. \t Easy formula writing 2. \t More rows and columns 5. \t Easy for sorting and filtering data 3. \t Rich conditional formatting 6. \t New looks for charts Components of Excel Window Wen you start MS-Excel, you get the Excel window as given. Cell Address Bar Menu Tab Title Bar Ribbon Column Heading Active Cell Row Heading Cell Scroll Bar Formula Bar Worksheet Tab Status Bar Smart Computer Science Book-6 179","Work Sheet : Worksheet is a grid made-up rows and columns where you can input your data and formula. Just as a note book has number of pages, MS-Excel workbook has many number of worksheets. By default, there are three worksheet named Sheet1, Sheet2, Sheet3. But you can insert more Work Sheet in a Work Book. Title Bar : The bar which displays name of work book is called title bar. It is placed in the top of the window. Menu Bar : It is the bar on which all the commands menus are placed. It is available just below the Title Bar. Ribbon : Ribbon is an organization of commands and instructions. When you click on menu option, respective commands are displayed in organized form on the ribbon. Workbook : Document which you create in MS-Excel is called Workbook. Generally MS-Excel file represents the Workbook where you can create a lot of worksheets like as book's pages. Row : The horizontal arrangement of cells in the worksheet is known as row. Rows are named using the number 1, 2, 3...from top to bottom. There are 1 to 1048576 rows in the MS-Excel 2016. Column : The vertical arrangement of cells in the worksheet is known as column. Columns are labeled using alphabets such as A, B, C,.............. from left to right. The last column name is XFD in MS-Excel 2016. There are 16384 columns. Cell : It is a unit of spreadsheet, which is formed by the Intersection of row and column on which a piece of data or formula is placed. Each cell has unique address which is formed by the combination of column letter and row number like A1. 180 Electronic Spreadsheet","Active Cell : The cell in which your pointer is placed and ready to type data is called active cell. Only one cell can be active at a time. The name of the active cell is shown in the cell address bar. Formula Bar : The bar which is used to display or edit the data or formula present in the active cell is known as the formula bar. Status Bar : The bar which displays various messages regarding the task being carried out on the worksheet is known as status bar. It appears at the bottom of the spreadsheet. Scroll Bar : The bars which allow us to view the different areas of the Excel worksheet is known as scroll bar. The Excel worksheet has two scroll bars one is horizontal scroll bar and another is vertical scroll bar. Start MS-Excel Steps to follow: Step-1\t:\t Type Ms-Excel in search box. Step-2\t:\t You get Excel App. Step-3\t:\t Click the Excel App. Step-4\t:\t Now, you get start up Ms-Excel screen. Step-5\t:\t Click the 'Blank Work Book'. You notice that the blank work book document of MS-Excel start. Smart Computer Science Book-6 181","Entering data in the Worksheet,save and close worksheet. Steps to Follow Step-1\t:\t Type the data title Step-2\t:\t Sn. in A1 Step-3\t:\t Name is in B1 Step-4\t:\t Address is in C1 Step-5\t:\t Phone is in D1 Step-6\t:\t Now, enter sn. , name, address and phone in the appropriate cell as given. Step-7\t :\t Save your work book by clicking the 'Office button'=> 'Save'. Step-8\t:\t Give the file name 'info'. Step-9\t:\t Close a workbook by clicking the 'Office button'=> 'Close' Tricks & TIPS You can cancel the data entry before pressing the enter key, by pressing the Esc key. 182 Electronic Spreadsheet","Cursor movement action: Key & combination Action will be taken Up\/Down, Left\/Right arrows One cell move in the respective direction PgUp and PgDn One page move in the respective direction Ctrl+Right arrow Move the cursor to the last column of current row Ctrl+Left arrow Move the cursor to the first cell of current row Ctrl+Up arrow Move to the top of the cell of the current column Ctrl+Down arrow Move the cursor to the bottom of the cell of the current column Ctrl+Home Move the cursor to the first cell A1 Ctrl+End Move the cursor to the last cell content Home Move the cursor beginning of the row F5 Move the cursor in the desired cell Creating New Work Book Steps to Follow: Step-1\t:\t Click the 'File' tab. Step-2\t:\t Click the 'New'. You get the New blank workbook dialog box. Step-3\t:\tClick the Blank workbook. Your Ms-Excel new work- book document is started. Selecting Range of Cells A range refers to a rectangular block of contiguous cells which are attached together. Some operation may need to be performed on a range of cells. Before performing any range of operation on a range of cells, you need to select the range. To select the range, do the followings: Smart Computer Science Book-6 183","Steps to Follow: Step-1\t: \tPlace the cell pointer at any corner cell of the range to be selected. Step-2\t: Now, holding the left mouse button, drag the mouse pointer (thick plus sign) to the diagonally opposite corner cell. \t\t For example, if the range B3 to C5 is to be selected, place the mouse pointer at cell B3. Hold the left mouse button and drag it diagonally to the C5. Fast Access Action that will be taken Selection A Cell Just click on the desired cell A range of cells Click the desired first cell and drag the mouse in the Entire worksheet desired location Random cell Press 'Ctrl+A' An entire row Hold down the control key to select the next cell or range of cells Click once on the row heading An entire column Click once on the column heading Contiguous (adjacent) range of Hold down the Shift key and click next desired cell cells. Select the first item row or column and hold down the Ctrl Random rows or columns key for the next item 184 Electronic Spreadsheet","Lab Activity 1. \tCreate a new workbook and enter your 10 friends' name and their ob- tained marks as given and then save your workbook 'marks' file name. a.\t Move the cursor to the last cell h.\t Select the column A and the content. column F. b.\t Move the cursor to the 1st cell A1. i.\t Save your work book as 'led- c.\t Move the cell pointer to the cell B6. ger' d.\t Select the cells from F5 to H7. e.\t Select the row of Pemba. j. \t Move cursor to the 1st cell f.\t Select the column \\\"A\\\". content current row. g.\t Select the data from cell A2 to F5. k. \t Move cursor to the last cell content. Smart Computer Science Book-6 185","Knowledge Test 1. Answer the following questions: a.\t When do you use spreadsheet? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... b.\t Differentiate between workbook and worksheet. Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... c.\t What do you mean by cell? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... d.\t What do you mean by cell selection? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... e.\t How do you select range of cell? 186 Electronic Spreadsheet","Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... .................................................................................................................................... f. How do you select entire worksheet? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... g. How do you move your pointer to desired cell? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... h. How do you select entire column? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... i.\t How do you make random selection? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... j.\t How do you make range of selection? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... Smart Computer Science Book-6 187","Editing Cell Content Editing refers to change or modification of existing data in the cell. To edit data in a cell, first you need to put a cell in activate mode. You can active the cell by selecting the cell and pressing F2 or simply clicking inside the cell and edit data. Steps to Follow: Step-1\t:\tDouble click the cell that contains the data to be ed- ited. This allows you to make changes to the data in the cell. Step-2\t:\t Edit the data. Step-3\t:\t Press enter key or click out- side the cell to accept the changes made to the cell. Here, it is ready to edit cell B4. Remove the Cell content This is the feature to delete the content of cell or range of cell. Steps to Follow: Step-1\t:\t Select a cell or range of cell Step-2\t:\t Press 'Del' key from the keyboard. Here it is selected B4 to B5 cell range. 188 Electronic Spreadsheet","Copy and Paste The Copy and Paste is used to make a duplicate copy of data in the new place of worksheet: Steps to Follow: Step-1\t:\t Select a cell or range of cell which you want to copy. Step-2\t:\t Click the 'Home' tab Step-3\t:\t Find the 'Clipboard group' and click the 'Copy' option. Step-4\t:\t Select the destination cell where you want to paste . Step-5\t:\t Click on 'Paste' option from the clipboard group of 'Home' tab. It is ready to copy cell range B2 to cell D3 . Cut and Paste The Cut and Paste feature is used to move your data in the new loca- tion. Steps to follow Step-1\t:\t Select a cell or range of cell which you want to copy. Step-2\t:\t Click the 'Home' tab. Smart Computer Science Book-6 189","Step-3\t:\t Find the 'Clipboard group' and click the 'Cut' option. Step-4\t:\t Select the destination cell where you want to paste . Step-5\t:\t Click the 'Paste' option from the clip board group of 'Home' tab. Delete row or column Steps to Follow: Step-1\t:\t Select the Row or Column by clicking the Row or Column header. Step-2\t:\t Find the 'Home' tab. Step-3\t:\t Find 'Cell' group. Step-4\t:\t Click the 'Delete Sheet Rows' option. Let's see, in given picture row 3 and 4 are selected and ready to delete. 190 Electronic Spreadsheet","Insert row Steps to Follow: Step-1\t:\t Click on a cell above which you want to enter new row Step-2\t:\t Find the 'Home' tab. Step-3\t:\t Find the 'Cell' group. Step-4\t:\t Click on 'Insert' drop down arrow. Step-5\t:\t Click 'Insert Sheet Row'. Step-6\t:\t Now, your row is inserted to above as given in the picture. Smart Computer Science Book-6 191","Insert Column Steps to Follow: Step-1\t:\t Click a cell on the left of which you want to insert a new column. Step-2\t:\t Find the 'Home' tab. Step-3\t:\t Find 'Cell' group. Step-4\t:\t Click the 'Insert' drop down arrow. Step-5\t:\t Click the 'Insert Sheet column'. Step-6\t:\t Now, your column is inserted to left. Insert Cell Sometimes it is not necessary to insert entire row or column, however you need only few cells. In such a case, you can insert a block of cells and select to move the existing cells in the any direction. To insert range of cells, do the following. Steps to Follow: Step-1\t: \t Select the range of cells where you want to insert the block of cells. Step-2\t:\t Find the 'Home' tab. Step-3\t:\t Find the 'Cell' group 192 Electronic Spreadsheet","Step-4\t:\t Click the 'Insert' drop down arrow. Step-5\t:\t Click the 'Insert Cells...' You get small dialog box as given. Step-6\t: Select option 'Shift Cells right' or 'Shift Cells down' Re-sizing single Column Steps to Follow Step-1\t:\t On the column header, move your pointer to the column's right boundary. The mouse pointer will become a cross. Step-2\t :\t Clicking this pointer on the same position to drag the boundary on the Left\/Right side until the column width becomes in the size that you want. Smart Computer Science Book-6 193","Re-sizing single row MS-Excel adjusts row height automatically, when you enter character on the basis of character height. Sometimes it may not be appropriate for you. So, in order to adjust row height yourself, do the following: Steps to Follow Step-1\t:\t On the row header, click on the below row boundary. Step-2\t:\t Drag the boundary up\/down until the row height becomes in size that you want. Here, 2nd row is going to resize. Re-sizing Multiple Columns Steps to follow Step-1\t :\t Select multiple columns by dragging the cursor along the col- umn heading. Step-2\t:\t Click the 'Format' drop down arrow in the 'Cells' group of the 'Home' tab. Step-3\t:\t Click the 'Column width'. you get a small dialog box. Step-4\t:\t Enter the new 'Width'. 194 Electronic Spreadsheet"]