Class 9 ICT

Page 259

• A1. Gaudy A2. Contrasting
• B1. Writing too much information on a slide will reduce the visibility of the text and it will also make it difficult for the audience to read and understand it.
• B2. Knowing your topic well will give you a better chance of presenting of your ideas than a person will less knowledge.

Page 264

• A1. C A2. A A3. B A4. B
• B1 Kingsoft Presentation, Microsoft Power point, prezi, Open office Impress
• B2. A process of displaying information in a sequence of slides is called a slideshow.
• B3. The slide pane displays thumbnail of slides and allows you to add new slide, delete existing slide or rearrange slides in order.

Page 264

• B4. To make a blank presentation, use the New option of File tab.
• B5. Use the save button on quick access toolbar or press the shortcut key Ctrl+ S.

Page 273

• A1. A A2. B A3. B A4. A A5. A A6. A A7. B A8C A9. C A10. B
• B1. To create your own template: (i) Click the file tab. (ii) Use the Save As option. (iii) Use the the suitable extension for making your file as a template. (*.pot)
• B2. To change the slide layout: Slide layout button of Home tab is used.
• B3. To add a new slide, use the new slide button of Home tab or press Ctrl +M shortcut key.

Diapositiva 5

• B4. To duplicate a slide, Ctrl+D shortcut key can be pressed.
• B5. To insert text in a slide, the available placeholders on the slides are used.
• B6. The orders of slides can be changed by drag and drop method in slide sorter view.
• B7. Slides can be deleted from a presentation by pressing the delete key on the slide in slide pane in normal view.

Diapositiva 6

• B8. Reading View: This view hides tabs, groups, ribbons and other elements of the screen and provides a full space to view or read the contents of a slide.
• Slide Sorter view: This view shows you all the slides in a miniature form.
• Notes pane of Normal View: This view allows you to view the notes page to edit the speaker notes as how they will look when you print them out.

Page 274, 275

• B9. We can move around a place holders by using a mouse pointer.
• A1. A A2. A A3. B
• B1. Changing the appearance of the text is called text formatting.
• B2. Font color of the text can be changed by: (i) Select the text. (ii) Use font color option on the Home tab.
• B3. There are two type of lists available in power point: Buletted list, Numbered list.

page 281

• A1. A A2. B
• B1. To insert a new row to the table: table tools tab is used.
• B2. Row height and column width can be changed using the mouse pointer.
• B3. To set a table style for a table: table design tab is used.

Page 286

• A1. A A2. A A3. C
• B1. An object (clipart, shapes) can be rotated using the rotate handle.
• B2. The size of the image can be increased by using the corner handles.

Page 289

• A1. C A2. B A3. B
• B1. (i) Go to view tab. (ii) Use the slide master option.
• B2. The slide master view is used to apply uniformity to all the slides of a presentation.

Diapositiva 11

• A1. C A2. B A3. A A4. C A5. B A6. C A7. B A8. A A9. C A10. A
• All. B A12. A
• B1. A digital presentation is a process of providing information to an audience using text, audio, video and graphics.
• B2. (i) Click on the Start button. (ii) Search for the Microsoft Power Point option. (iii) Click on the link to open it.

Diapositiva 12

• B3. The dotted box on a slide which accepts the text value is called a place holder.
• B4. To run a slide show, Slide show button of view tab/ status bar can be clicked. We can also use its shortcut key F5.
• B5. The slides pan shows the miniature of all the slides of a presentation.

Diapositiva 13

• B6. The visual effect which takes place when the slide changes in the slide show view is called slide transition.
• B7. By using 'Group' option after pressing Ctrl key while selecting all the shapes, we can group all the shapes.
• B8.We can use the shortcut key Ctrl +X (cut), Ctrl + C (copy) and Ctrl +V for paste option.

Diapositiva 14

• C1. The two good qualities of a good presenter are: Confidence, Sincerity, mastery of the subject and a friendly feeling for the audience.
• C2. To open a blank presentation: (i) Click the file tab. (ii) Click the Blank presentation option.
• C3. The slides pane shows the miniature of all slides in a presentation.
• C4. The notes pane is used to write speaker notes for the presenter.
• C5. The slide show view displays all the slides one after the other in full screen mode with all the applied effects and timings.

Diapositiva 15

• C6. Text formatting can be done by using the various options on the Home tab.
• C7. The slide sorter view is primarily used for rearrangement of slides.
• D1. To create a master slide: (i) Use the View tab. (ii) Choose the Slide master option.
• D2. To copy, move and delete contents of a slide, normal view is used.
• D3. To add a table to a slide: (i) use the content slide layout. (ii) Click the table icon and specify the number of rows and columns to make a table.

Diapositiva 16

• D4. We can modify the row height and column width by moving the mouse pointer over the row border or column border and then by dragging it.
• D5. (a) The quick access toolbar is found just near home tab. It has buttons to save, undo and redo options.
• (b) Window management buttons are found on the title bar. These are used to resize, close and minimize the window.
• D6. We can use the zoom slider to control the size of a view.

Page 239

• A1. A A2. C A3. C
• B1. A spreadsheet is divided into row and columns to receive input data from the user. It is used to apply various functions upon the data and calculate the results.
• B2. A range can be understood as a contiguous group of cells.
• B3. An active cell can be identified by a dark black border around its 4 sides.

Page 241

• A1. A A2. A A3. B A4. C A5. B
• B1. Three type of data can be entered in a cell. Text, Numbers and functions.
• B2. Text data type includes a combination of letters, numbers and special characters.
• B3. Some common functions in excel are: power, max, min, average, sum.
• B4. To calculate average of values: = average (A1: A5)

Page 248

• A1. C A2. C A3. A
• B1. 2.00E03
• B2. To change a date format to another date format: (i) Select the data values by clicking upon the cells. (ii) Right click over the cell and choose 'Format' option. (iii) In the dialog box, click on date type and choose appropriate date format.

Page 249

• A1. C A2. A
• B1. Absolute cell reference is used when we do not want to change the address of a cell while copying the format to another cell.
• B2. Mixed cell referene is a combination of relative and absolute cell references. In this, either a row or a column remains constant.

Page 254

• A1. B A2. C
• B1. (a) A pie chart shows the parts of the whole items that make up a data series to the sum of the items.
• (b) A line chart shows trends in data at equal intervals.
• (c) A column chart is a type of chart which shows data changes over a period of time or defines comparisons among individual items.

Diapositiva 22

• B2. The X axis or horizontal axis is called Category Axis. The Y axis or vertical axis is called Value axis.
• B3. The total region of the chart in which the chart is defined, is called chart area.
• The area of the chart in which your data is plotted, is called Plot Area.

Page 255

• A1. A A2. C A3. C A4. B A5. A A6. A A7. B A8. C A9. B A10. A
• B1. The unique address of a cell is known as cell reference.
• B2. To insert a new worksheet: Click on the, new worksheet button next to sheets tab.
• B3. '&' is known as concatenation operator. It is used to join text strings. = A1&B1 will join the contents of these 2 cells.

Diapositiva 24

• B4. Enter buttons applies the formula to the cells and Cancel button cancels the formula.
• B5. The save options save the file with the given name but save As can be used to make a new workbook file.
• B6. Dates are interpreted in various available formats in excel

Diapositiva 25

• C1. Excel is a popular spreadsheet program.
• C2. Please see these 2 answers: B2 Page241 and B3 Page 255
• C3. A name box shows the address of the active cell in a worksheet.
• C4. Please see B2 answer on page 248
• C5. A function is a pre-defined expression in excel. ex. sum, max, min etc.

Diapositiva 26

• D1. =Average(A2:D2)
• D2. Some common elements of excel 2010 interface are: Title bar, Quick Access Toolbar, Tabs, Ribbon, Rows, Columns, Sheet, Cell etc (refer page 236)
• D3. We should use the increase decimal and and decrease decimal buttons available on Home tab.
• D4. The number data type accepts numbers of all types in a cell as whole number, fractional number, positive or negative numbers.