Flip Book class-6

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 195

..................................................................................................................................... ..................................................................................................................................... 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: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... 196 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 197

j. What do you mean by news paper style of page? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... k. What do you mean by merging cell? Ans: ............................................................................................................................ ..................................................................................................................................... .................................................................................................................................... l. What dose include in modification of table? 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: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... 198 Word Processing

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 mela on the auspicious fes- tival of Bada Dashain. Design the following Poster to display in the mela. Use Word Art and Clip Art . As far as possible draw a picture of Mata Devi in Ms-Paint and use here. Smart Computer Science Book-6 199

Lab Project-2 1. Prepare the following news Bulletin. Draw picture in MS-Paint use here. HAMRO NEWS BOARD DAILY UPDATED Stop Child Labour dren. Terre des Hommes is com- mitted to millions of children who Worldwide, as face the worst forms of child la- many as 152 bour. million children have jobs. They Powering ships with earn a few for plastic in Amsterdam hours and they simply do not In the Port of have enough Amsterdam, time to go to a new factory school and improve their future is being built prospects. that could rev- olutionize the 72 million children are forced way we dispose of plastic waste. to work in dangerous and un- Utilizing ground breaking technol- healthy conditions. Terre des ogy, the facility will use previously Hommes is committed to millions unrecyclable plastic to create fuel of children who face these worst for diesel powered cargo ships. forms of child labour. These chil- dren are forced to work in plan- The group behind the facility is tations, mines, factories, as do- Bin2Barrel, a Dutch company mestic slaves etc. They perform founded in 2012 by waste man- exhausting work for many hours agement entrepreneurs Floris in a row, often in unhealthy and Geeris and Paul Harkema. While hazardous conditions. The work the chemical recycling technol- is physically, psychologically ogy used in the past has worked, and/or morally harmful for chil- Bin2Barrel is the first company to utilize it commercially. 200 Word Processing

Case Study 1. Niru Ghale has inserted a picture, but she is unable to move. When she tries to move, it doesn't move. Due to this problem, she could not complete her project work. Now, to solve this problem, how would you suggest her? Solution: ................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... 2. Lakpa has inserted a Word Art, when he starts to resize that becomes skew, it won't resize properly, it looks very funny and untidy. Now, what may be the problem of Lakpa? How would this problem be solved? Solution: ................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... .................................................................................................................................... 3. When Bismita starts typing in MS-Word, She is not getting any thing. She is shocked ! When she types randomly, she only gets spelling error underlined. Now, What may be the problem of Bismita? How would it be solved ? Solution: ................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... Smart Computer Science Book-6 201

Electronic Spreadsheet CHAPTER 12 Teacher : Well ! Listen to me, We This chapter includes: heard computer is so ge- nius. But how to analyze • Basic of Spreadsheet. the data set ? Like, marks • Cursor movement and of students, income and expenses of home, office. selection technique Sales and purchase ? Do • Creating and saving you have any idea, Miku ? Worksheet. • Concept of basic calcu- lation Miku : No, Sir ! I heard it is possible in computer, But how is it? Teacher : Of course ! There is elec- tronic spreadsheet programs, like register. Its function is to main- tain and keep record of setting of data. Very large scale of data calculation and imagination are possible in the electronic spread- sheet. Lets, discuss in it detail.......... BASIC OF SPREADSHEET Spreadsheet is a software tool that lets us to enter, calculate, manipu- late and analyze sets of data which helps to take right decision in the official financial activities. It consists of rows and column. So, data are managed in tabular form. Once you enter data on a spreadsheet, you can perform different types of calculations such as arithmetic, trigono- metric, statical and other calculation. MS-Excel, Lotus 1-2-3, Open Of- fice Calc are example of Spreadsheet software. 202 Electronic Spreadsheet

Introduction of MS Office Excel MS Office Excel is one of the popular spreadsheet software which is developed by Micro Soft 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 every office and business industries for entering, calculating, manipulating and analyzing data. Basic Features of MS Office Excel 5. Easy formula writing 1. Results-oriented user friendly interface 2. More rows and columns 6. Easy for sorting and filter- 3. Office themes and Excel styles ing data 4. Rich conditional formatting 7. New looks for charts Components of Excel Window Wen you start MS-Excel, you get the Excel window as given. Cell Address Bar Menu Bar Title Bar Ribbon Column Heading Row Heading Worksheet Tab Cell Scroll Bar Formula Bar Active Cell Status Bar Smart Computer Science Book-6 203

Work Sheet : Worksheet is a grid made up row and columns where you can input your data and formula. It is just as a note book has number of pages, an MS-Excel workbook has a 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 : The bar on which all the commands menus are placed. It is available just below of 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. Work Book : Document which you create in MS-Excel is called Work- Book. Generally MS-Excel file represents the Workbook where you can create a lot of worksheets as 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...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 top to bottom. The last column name is XFD in MS-Excel 2016. There are 16384 columns are there. Cell : It is a unit of spreadsheet, which is formed by the Intersection of row and column on which a pice of data or formula is placed. Each cell has unique address which is formed by combination of row number and 204 Electronic Spreadsheet

column letter like A1. 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 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 ap- pears 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 in Steps to follow: Step-1 : Type Ms-Excel search box. Step-2 : You get Excel App. Step-3 : Click the Excel App. Step-4 : Now, you get start up Ms-Excel screen. Step-5 : Click the 'Blank Work Book'. The blank work book document of MS-Excel will start. Smart Computer Science Book-6 205

Entering data in the Worksheet,save and close worksheet. Steps to Follow Step-1 : Type the data title Step-2 : Sn. in A1 Step-3 : Name is in B1 Step-4 : Address is in C1 Step-5 : Phone is in D1 Step-6 : Now, enter sn. , name, address and phone in the appropriate cell as given. Step-7 : Save your work book by clicking the 'Office button'=> 'Save'. Step-8 : Give the file name 'info' Step-9 : Close a workbook by clicking the 'Office button'=> 'Close' Trick & TIP You can cancel the data entry before pressing the enter key, by pressing the Esc key 206 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 col- umn. Ctrl+Home Move the cursor the cursor to the first cell A1. Ctrl+End Move the cursor to the last cell content. Home Move the cursor the cursor beginning of the row. F5 Move the cursor in the desired cell. Creating New Work Book Steps to Follow: Step-1 : Click the 'File' tab. Step-2 : Click the 'New'. You get the New blank workbook dialog box. Step-3 : Click 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 at- tached each other. 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 rang: To select the range, do following: Smart Computer Science Book-6 207

Steps to Follow: Step-1 : Place the cell pointer at any corner cell of the range to be se- lected. Step-2 : Now, holding the left mouse button, drag the mouse pointer (thick plus sign) to the diagonally opposite corner cell. 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 Entire worksheet Click on the desired first cell and drag the mouse in the Random cell or range of cells desired location. An entire row Press 'Ctrl+A' or click on the Select all option from the Edit menu. Select a cell or range of cells, then 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. Sequential rows or columns Hold down the Shift key and drag the mouse. Random rows or columns Select the first item row or column and hold down the Ctrl key for the next item. 208 Electronic Spreadsheet

Lab Activities 1. Create 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. Move the cell pointer to the end of g. Select the data from cell A2 to the last column and again move to F5. the first cell. h. Select the column A and the b. Move the cell pointer to the last row column F. of the worksheet. i. Save your work book as 'led- c. Move the cell pointer to the cell B6. ger' d. Select the cells from F5 to H7. j. Move cursor to the 1st cell content. e. Select the row of Pemba. k. Move cursor to the last cell f. Select the column \"A\". content Smart Computer Science Book-6 209

Knowledge Test 1. Answer the following questions: a. When do you use spreadsheet? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... b. Differentiate between workbook and worksheet. Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... c. What do you mean by cell? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... d. When do you make selection? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... e. How do you select range of cell? 210 Electronic Spreadsheet

Ans:…………………………………………………………………………………………... .................................................................................................................................... f. How do you select entire worksheet? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... g. How do you move your pointer to desired cell? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... h. How do you select entire column? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... i. How do you make random selection? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... j. How do you make range of selection? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... Smart Computer Science Book-6 211

Editing Cell Content Editing refers to change or modify existing data in the cell. To edit data in a cell, you first need to put a cell in active mode. You can active the cell by selecting the cell and pressing F2 or simply clicking inside the cell. You can then type at the end of the data. Steps to Follow: Step-1 : Double 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 : Edit the data. Step-3 : 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 : Select a cell or range of cell Step-2 : Press 'Del' key from the keyboard. Selected to delete B3 to B5 Cell range. 212 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 : Select a cell or range of cell which you want to copy. Step-2 : Click the 'Home' tab Step-3 : Find the 'Clipboard group' and click the 'Copy' option. Step-4 : Select the destination cell where you want to paste . Step-5 : 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 : Select a cell or range of cell which you want to copy. Step-2 : Click the 'Home' tab. Smart Computer Science Book-6 213

Step-3 : Find the 'Clipboard group' and click the 'Cut' option. Step-4 : Select the destination cell where you want to paste . Step-5 : Click the 'Paste' option from the clip board group of 'Home' tab. Delete row or column Steps to Follow: Step-1 : Select the Row or column by clicking the row or column header. Step-2 : Find the 'Home' tab. Step-3 : Find 'Cell' group. Step-4 : Click the 'Delete Sheet Rows' option. Lets see, in given picture row 3 and 4 are selected and ready to delete. 214 Electronic Spreadsheet

Insert row Steps to Follow: Step-1 : Click on a cell above which you want to enter new row Step-2 : Find the 'Home' tab. Step-3 : Find the 'Cell' group. Step-4 : Click on 'Insert' drop down arrow. Step-5 : Click 'Insert Sheet Row'. Step-6 : Now, your row is inserted to above as given in the pic- ture. Smart Computer Science Book-6 215

Insert Column Steps to Follow: Step-1 : Click the a cell on the left of which you want to insert a new column. Step-2 : Find the 'Home' tab. Step-3 : Find 'Cell' group Step-4 : Click the 'Insert' drop down arrow. Step-5 : Click the 'Insert Sheet column' Step-6 : Now, your column is inserted to left. Insert Cell Some times it is not necessary to insert entire row or column, though 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. In order to in- sert range of cells, do the following. Steps to Follow: Step-1 : Select the range of cells where you want to insert the block of cells. Step-2 : Find the 'Home' tab. Step-3 : Find the 'Cell' group 216 Electronic Spreadsheet

Step-4 : Click the 'Insert' drop down arrow. Step-5 : Click the 'Insert Cells...' You get small dialog box as given. Step-6 : Select option 'Shift Cells right' or 'Shift Cells down' Re-sizing single Column Steps to Follow Step-1 : On the column header, move your pointer to the col- umn's right boundary. The mouse pointer will become a cross. Step-2 : Clicking this pointer on the same position to drag the bound- ary on the Left/Right side until the column width get in the size that you want. Smart Computer Science Book-6 217

Re-sizing single row MS-Excell adjusts row height automatically, when you enter character in the basis of character height. Though, some times it may not appropri- ate for you. So, in order to adjust row height yourself, do the following: Steps to Follow Step-1 : On the row header, click on the below row boundary. Step-2 : Drag the boundary up/down until the row is the height be- come in size that you want. Here, row 2 is going to resize. Re-sizing Multiple Columns Steps to follow Step-1 : Select multiple columns by dragging the cursor along the col- umn heading. Step-2 : Click the 'Format' drop down arrow in the 'Cells' group of the 'Home' tab. Step-3 : Click on 'Column width'. you get a small dialog box. 218 Electronic Spreadsheet

Step-4 : Enter the new 'Width'. Step-5 : Click on 'Ok'. Or Step-6 : Select the multiple columns by dragging along the column head- ing. Step-7 : Drag the boundary of a single selected column to re-size the column. Step-8 : The selected columns will be changed in their width. Resizing Multiple Row Steps to Follow: Step-1 : Select the multiple rows by dragging the cursor over the row heading. Step-2 : Click the 'Format' arrow in the 'Cells' group of the 'Home' tab. Step-3 : Click on 'Row height'. you get dialog box. Step-4 : Enter the new 'Height' Step-5 : Click on 'Ok'. Smart Computer Science Book-6 219

FORMATTING DATA IN THE WORK SHEET Formatting refers to arrangement of data set for good presentation, and appearance on a printed page or visual display . To present the data in effective way, some data can be placed in bold type, italic , in different font face, size and color. This make worksheet attractive and easy to read. There are different aspects of data formatting i.e. number format- ting, date/time formatting, text formatting: here we learn how to make text formatting . Steps to Follow: Step-1 : Select the Cells you want to format. Step-2 : Click the 'Home' tab. Step-3 : Use the Font and Alignment group for basic formatting. Here selecting B1 to D1 and making bold face text formatting. Merging & Center Cell Join the selected cells into one larger cell and center the content into new cell. This is often used to create labels that spans multiple columns. Let's follow the following steps, in order to merge and center the cell. 220 Electronic Spreadsheet

Steps to Follow Step-1 : Select the cell. Step-2 : Click the 'Merge & Center' drop down option of 'Alignment' group of 'Home' tab Step-3 : Select the 'Merge Center' option. Here, it is selected cell range B1 to D3 to merge and center a obtained new cell center to write. Insert Worksheet Steps to Follow: Step-1 : Click the 'Home' tab. Step-2 : Click the 'Insert Sheet' option from the cell group of 'Home' tab. Smart Computer Science Book-6 221

Deleting Worksheet Steps to Follow Step-1 : Click the 'Home' tab. Step-2 : Click the 'Delete' op- tion from the Cell group of the 'Home' tab. Step-3 : Select the 'Delete Sheet' option. Alignment of data Steps to Follow Step-1 : Select data. Step-2 : form 'Home' tab of 'Alignment' group. Click the appropriate Alignment option, Style of Data in sheet Steps to Follow Step-1 : Select data. Step-2 : Form 'Home' tab of 'Style' group. Click the appro- priate Style op- tion. If you are willing to explore more style, click the more drop down arrow. 222 Electronic Spreadsheet

Lab Activities 1. Prepare the following Worksheet and perform the following tasks: a. Look in the row 4, the name is g. Increase the row height as you typed 'Uma' that should be Muna. like and column H Social that is So- cial. h. Increase the column width for Name and add their sur name. b. Similarly in the row 6, name is typed 'Kamala' that is 'Kamal i. Insert a column between Science and Social and add one more sub- c. In the row 10, Rahul is not in this ject 'Moral Science' . list. He is in another section. You have to remove it. j. Insert a row between row 8 and 9 and add one more record of He- d. Copy the row number 2 in row 10 manta . and change the name Sumnima an Roll is 9. k. Increase the font size 14 pt and change font style. The heading e. Move your entire data in row 3. should be changed bold. f. Align the data heading as left alignment. Smart Computer Science Book-6 223

Knowledge Test 1. Answer the following a. What do you mean by row and column? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... b. When do you increase row height and column width? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... c. When do you insert worksheet? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... d. What do you mean by re-sizing row and column? Ans:…………………………………………………………………………………………... ..................................................................................................................................... .................................................................................................................................... e. When do you insert row and column? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... 224 Electronic Spreadsheet

f. What do you mean by formatting worksheet? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... g. What do you mean by alignment? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... h. Differentiate between Copy and Cut. Ans:…………………………………………………………………………………………... ..................................................................................................................................... i. What do you mean by Merging Cell? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... FORMULA IN MS-EXCEL We can use formulae in MS-Excel to carry out calculations. Formulae always begin with an equal to (=) sign. Formulae are typed in formula bar. The formula is consisted by following elements: a. Values: Value may number (Numeric like 10, 20, 50.5,) or string (al- pha character\" b. Cell Address : A2, B10, C5, etc c. Function : SUM, AVERAGE, MIN, MAX, etc. d. Operator : +, -, /, *, >, <, =, ^, , %,( ) etc. Smart Computer Science Book-6 225

Example of Formulae: = A1+B1 = A1 *10/100 =B5*C5 =SUM(G5:G10) In this example, the formula =C2*D2 is entered in the cell E2 . Due to this formula, the result 12000 is obtained. Copy Formula It is not necessary to write same formula frequently, Once a formula is written, it can be copied for other cells. We can copy formula in two methods: a. Using Copy and Paste command b. Using Fill Handle. Using Copy and Paste Command Steps to follow: Step-1 : Select the cell where formula is applied. Step-2 : Click the 'copy' from 'Home' tab of 'Clip Board' group . 226 Electronic Spreadsheet

Step-3 : Click Paste in the 'Clip Board' group of 'Home' tab In this example, it is copied formula from cell E2 to cell range E3 to E6 : Using Fill Handle A fill handle is a small black square at the bottom right corner of an active cell or range of Cells. It is used to copy a formula and display series of data in continues scale such as, 1, 2, 3..........., Sunday, Monday............ Saturday, January, February................December. Steps to Follow Step-1 : Select the cell containing the formula. Step-2 : Click the Fill Handle and drag it over the range to be filed. Step-3 : The formula gets pasted to all the cells. In the given example, the fill handle of cell address A1 to C2 is drag and drop up to A12 to C12 in the up comming sequence.. Smart Computer Science Book-6 227

Lab Activities 1. Prepare the following Worksheet and perform the given task : a. Calculate Gross Total (Quantity ×Rate) b. Find the discount 10 % of Gross total c. Find the Net total (Gross Total-Discount) d. Find the Net Total Amount. a. Calculate Gross Total Step-1 : Place your cursor in E2. Step-2 : Click on formula bar and type the formula as: =C2*D2 and press enter key. 228 Electronic Spreadsheet

Step-3 : Now you get the value in the E2 cell. Step-4 : Click on the E2. Step-5 : Click in the fill handle and drag the mouse till E6 to copy formula. Now you get all the values of Gross Total. Calculate Discount Step-1 : Place the cursor in F2. Step-2 : Click on formula bar. Step-3 : Type the formula as: = (10*E2)/100 and press enter key. Step-4 : Copy the formula by clicking and dragging the fill handle till F6. Calculate Net Total Step-1 : Place the cursor in G2. Step-2 : Click on formula bar. Step-3 : Type the formula as: = E2-F2 and press enter key. Step-4 : Copy the formula by clicking and dragging the fill handle till G6. Calculate Total Amount Step-1 : Place the cursor in G7. Step-2 : Click on drop down button of 'AutoSum' from 'Edit- ing' group of 'Home' menu. Or Step-3 : Type the formula in formula bar as: =SUM (G2:G10) and press enter. Finally you get your worksheet as given below: Smart Computer Science Book-6 229

Knowledge Test 1. Answer the following questions: a. Where do you write formula? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... b. What do you write in the beginning of the formula? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... c. What may the content of formula be ? Ans:…………………………………………………………………………………………... ..................................................................................................................................... ..................................................................................................................................... 230 Electronic Spreadsheet

d. Write the method to copy a formula. Ans:…………………………………………………………………………………………... ..................................................................................................................................... Points to Know • Spreadsheet is a software tool that lets us to enter, calculate, manipulate and analyze sets of data which helps to take right decision in the official different types of activities. • It is similar to the manual spreadsheet used by accountant with pencil, eraser, paper and calculator but it is in electronic version. • MS-Excel is a one of the popular spreadsheet software which is developed by Micro Soft company, in USA. It comes with MS-Office package. • Worksheet is a grid made up row and columns where you can input your data and for- mula. It is just as a book has number of pages. • Document which you create in MS-Excel is called Workbook. • The horizontal arrangement cells of worksheet is known as row and vertical arrange- ment of cells is called column. • The cell is a unit of a worksheet which is formed by the intersection of row and column. • The cell in which your pointer is placed and ready to type data, is called active cell Terms to Know Cell Pointer : The active cell and is highlighted by a bolder rectangle. Range of Cell : A collection of selected cells in a spreadsheet.. Cell : Intersection between a row and a column on a spreadsheet. Operators : Symbols used in formulae. Cell Reference : A range of cells on a worksheet and can be used in a formula. Column : A vertical series of cells. Row : A horizontal series of cells. Smart Computer Science Book-6 231

Worksheet Objective Questions 1. Fill in the blanks: a. ........................................ is a software where you enter, calculate, manipulate and analyze data. b. Spread sheet is a consisted by ............................... and ............................. c. MS-EXcel comes with ..................................... package. d. Worksheet where you can input ............................. and ............................... e. ................................... displays the name of workbook. f. ...................................... is a document you create in MS-Excel. g. There are .................................. rows and ................................ columns in MS- Excel 2007. h. ........................... are used to carry out calculation. 2. State whether the following statements are true or false: a. Data remanaged in the paragraph form in the spreadsheet. b. Ms-Excel is a popular word processing software. c. Title bar is placed in the top of the window. d. Ribbon is an organization of commands and instructions. e. Workbook comes inside a worksheet. f. Vertical arrangement of cells is called row. g. Horizontal arrangement of cells is called column. h. Cell is the biggest unit of a spreadsheet. 232 Electronic Spreadsheet

3. Match the following: a. Ctrl+Home Views the different area of a worksheet. b. F5 Copy a formula and display continues series of data c. Scroll Bar Spreadsheet software. d. Lotus 1-2-3 Move the cursor to the desired cell. e. Fill Handle Move the cursor to the first cell. Descriptive Questions 1. Answer the following questions: a. What is spreadsheet software? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... b. Write the features of MS-Excel. Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... c. What do you mean by active cell? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... d. What does formulae include? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... e. Why do you use fill handle? Smart Computer Science Book-6 233

Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... Lab Project-1 1. Prepare the following Worksheet perform the given task : a. Selct the range A1 to C5 b. Select the range A1 : B5 and D1 : D5 c. Select third and fourth row d. Select the E and F column e. Calculate total marks 2. Prepare a worksheet with the detailed information of your computer accessories such as serial number, name of ac- cessories, brand name, tenta- tive price. Now, find out cost of your computer. 234 Electronic Spreadsheet

Lab Project-2 1. Suppose your school has or- ganized an athletic meet last week. Now you have to pre- pare a worksheet on the num- ber of each type of medal(Gold, Brown, Sliver) medals to be owned by each house out of green, yellow, red and blue house. 2. Rasmita has been assigned a task to prepare the following work- sheet in practical exam. She has made the following mistakes. a. Make Science and English instead of Sci and Eng respectively. b. In B2 cell the name should be Rahul instead of Rahuk c. In B5 cell instead of Shyamu, it should be Shyam d. In Cell B3, Correct the name Subu to Shambu e. Insert one column right hand side of name and add cast as Sing, Karki, Sherpa, Chudary, Gupta, Thapa. Now, You have to make correction in this worksheet. s Smart Computer Science Book-6 235

Lab Project-3 1. Khusmila Updhya typed the following data in the worksheet. But finally realized she has typed wrong data cell in the cell range C2 to F9. Now prepare the following of Khusmilla's worksheet and make correction. 2. Hikmat Pulami prepared the fol- lowing worksheet. However, he typed roll number in column D, it should be in column C. Now, pre- pare same worksheet and make correction using suitable tech- nique. 236 Electronic Spreadsheet

Lab Project-4 1. Raghuji Mahaseth has been assigned a project work focusing in the final examination. He has prepared the following worksheet and per- form the given work. Now, as Raghuji you have to prepare the given worksheet for doing the same as given below. a. In the column A, compete the f. Insert more four rows after the current serial number using fill handle. third row and add records . b. Insert one more column after g. Now, Kamla and Shubu have alredy column E and add one more left the school, Delete their records. subject Nepali and tentative marks. h. Move the marks of math after the marks of Science. c. Insert three rows in the top of the worksheet and merge center i. Make the duplicate copy of this work- range of cell C1: D3 and type sheet in the new worksheet. the name of School, address, and Telephone Number. j. Computer marks of Shyamu should be 87 instead of 78. d. Format heading data bold, for name of school font size 18, font k. Practice cursor movement technique face bold. and selection technique given in this chapter. e. Adjust the row and column height and width, if it is needed. l. Calculate total marks and copy the formula in other cells. Smart Computer Science Book-6 237

13Presentation with PowerPoint CHAPTER Miku : Wow, So interesting! Let's see, Electronic Presenta- tion. This chapter includes: • Introduction of pre- Teacher : Of course, Onward today, sentation. you will make any presenta- • Basic of PowerPoint • Formatting Text & tion in electronic Version, Shapes. Miku : How do we make attrac- • Slide transaction, ani- tive and effective presenta- mation & Slide Show tion sir ? Teacher : PowerPoint software is used to make presentation. There are a lot of features : You can place text, image, shapes and drawing, sound as well as video in your presentation. You can create animation and a lot of interest- ing slide transaction features. You are getting fun and learn. Let's start, don't be late. INTRODUCTION Presentation software is a tool used to create visual presentations. These presentations are usually created in a slide show format with a variety of programs. The programs make it possible to combine text and graphic elements to convey important information to a group of people all at once. Common uses for this type of software include teaching a new or complex concept to a group of students, announcing the launch a 238 Presentation with powerpoint

new product or service campaign to employees, training for employees on key concepts or new policies, or presenting a proposal to a group. One of the popular presentation software is Microsft PowerPoint. Microsoft PowerPoint Microsoft PowerPoint is a powerful multimedia presentation program, which comes with Microsoft office package. It is developed by Microsoft Company. Using the PowerPoint, we can create a presentation contain- ing text, graphics, sound, animation and videos. A presentation made up of a number of slide in the Powerpoint which comes in sequential order to create a presentation. Features of PowerPoint a. Create presentation slide b. Graphical object can be added c. Sound and animation can be added d. Support art gallery e. Can be create handouts notes f. Timings can be rehearsed How to Start MS-Power point Step-1 : Click the ‘Start’ button Step-2 : Type Powerpoint in search box. Step-3 : You get the PowerPoint App as given in picture. Step-4 : Now click the Power- Point App once. Step-5 : You can see start up PowerPoint and get the home screen. The PowerPoint Window When you start Microsoft PowerPoint, you get it's window which looks as given: Smart Computer Science Book-6 239

Quick Access Tool Bar Ribbon Title Bar Tab Order of Slide Slide Status Bar Notes Place Holder View Buttons Zooming Create New Presentation Step-1 : Click the File tab Step-2 : Click on ‘New’ Step-3 : You get a 'New Presen- tation' dialog box. Step-4 : Select the desired Tem- plate or 'Blank Presenta- tion' Step-5 : Click on ‘Create’ Step-6 : Now, you get your new presentation window. 240 Presentation with powerpoint

Select the Presentation Layout Step-1 : Click the ‘Drop Down’ button of ‘Layout’ op- tion from ‘Slide’ group of ‘Home’ Tab. Step-2 : You get the ‘Office Them’ dialog box. Step-3 : Select your desire Lay- out them from the Of- fice Theme gallery. Step-4 : Her, ‘Title Slide’ Them is selected. Select Slide design Step-1 : Click the 'Design' Tab. Step-2 : Select the desire ‘Design’ theme form ‘Themes’ group. In this slide ‘Office Them used by All slide’ is selected. Insert Slide 241 Step-1 : Click the ‘Home’ tab. Step-2 : Click the ‘New slide’, icon from ‘Slides’ group. Step-3 : Now, You get new slide. Smart Computer Science Book-6

Insert Text Box Steps to follow: Step-1 : Select the 'Insert Tab. Step-2 : Select 'Text Box' from 'Text' group. Step-3 : Draw a text box on the slide by dragging the mouse. Step-4 : Type your text. Insert Image Step-1 : Click the ‘Insert’ tab. Step-2 : Click in ‘Picture’ icon option. Step-3 : Find location. Step-4 : Select your Image/ picture. Step-5 : Click the ‘Insert’ tab. FORMATTING TEXT Formatting text refers to change the appearance of the text which in- cludes font style, size, color, alignment, indentation, bold, italic, etc. You can format text using 'Font' and 'Paragraph' group of 'Home' tab. Formatting from Font group Steps to Follow: Step-1 : Select Text. 242 Presentation with powerpoint

Step-2 : Click the 'Home' tab. By default, it is selected. Step-3 : Find the 'Font' group. You can find a lot of formatting pa- rameters such as Bold, Italic, Font style, size, strike through, shadow, character spacing, change case, color,etc. Step-4 : You can select and change as you like. Step-5 : You can activate Font dialog box for advance character for- matting, by clicking the 'Flyer' menu of 'Font' group. Formatting from Paragraph Group Steps to Follow: Step-1 : Select Text. Step-2 : Click the 'Home' tab. By default, it is selected. Step-3 : Find the 'Paragraph' group where you can find a lot of paragraph formatting parameters such as Alignment, Columns, Bullet and Number list, Increase Decrease list level, Line spacing, Text direction, Align Text, SmartArt, etc. Step-4 : You can select and change the parameters as you like. Step-5 : You can activate 'Paragraph' dialog box for advance para- graph formatting, by clicking on 'Flyer' menu of 'Paragraph' group. Smart Computer Science Book-6 243

How to Delete Slide Step-1 : Select the Slide to delete and right mouse click Step-2 : You get the context menu. Step-3 : Click the ‘Delete’, option Step-4 : Now, Slide will be deleted. Organizing Slide Re-arrange the slides in slide pane is known as the organizing the slide. Some time, you need to change the place of slide, in such a case you have to do this task. Steps to Follow: Step-1 : Select the slide in the Slide Pane. 244 Presentation with powerpoint