Class 9 Part B Term 2

Commonly used Application Softwares

Sample Paper

Unit III: DIGITAL DOCUMENTATION

Videos

1. What is OpenOffice Suite?
Ans. OpenOffice is a powerful and free office suite, used by millions of people around the world. Its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. OpenOffice includes several applications that make it the most versatile Free and Open Source office suite on the market. Some of its applications are: Writer (word processor), Calc (spreadsheets), Impress (presentations). 

2. What are the different components of the openoffice writer?
Ans. The OpenOffice Writer window has the following components: 

1. Title Bar - Displays the name of current document and application. It also contains control buttons.
2. Menu Bar - It contains all the menu options. Example - File, Edit, View etc.
3. Standard Toolbar - It displays the icon of the commonly used commands (like Save, Undo, Redo, New, Open etc.)
4. Formatting Toolbar - It contains the formatting commands (Font name, Font Size, Font color etc.)
5. Rulers
6. Document Area
7. Scroll Bars
8. Status Bar
9. View buttons
10. Zoom Slider
11. Sidebar

 3.Explain the Application and Document windows of the Openoffice Writer window?
Ans.  The larger window is called the Application window and the smaller window, which is inside the application window, is called the Document window. The Application window helps the user to communicate with the OpenOffice Writer program. The Document window is used for typing, editing, and formatting the text. 

4. How can you save a document in OpenOffice Writer?
Ans. You can save a document by using either the Save command or the Save As command. To save a file, do one of the following: 
• Press Ctrl+S. Or Under the File menu, choose Save. Or Click on the Save icon on the Standard toolbar. 
• If the file is new, the Save As dialog appears. Enter the file name, verify the file type and location, and click on Save. The file will be saved with the extension .odt. 
• If the file has already been saved, then nothing else needs to be done. The file gets re-saved with the same name and settings.
• If you have done some changes in a saved file and want to save it with a new name, then click on the Save As option under the File menu. This will ask you to save the existing file with a new name, and will keep the original file as it is. 

5. How do you open an existing file in OpenOffice Writer?
Ans. Once a document is saved on your computer, it can be retrieved any time it is required. When no document is open, then follow any one of the below mentioned steps to open an existing document. 
• Click on Open File or Remote Files in the main startup window of OpenOffice. Or Choose File > Open /Open Remote File from the Menu bar. Or Press Ctrl+O on the keyboard. If a document is already open, the second document opens in a new window. 
To open another document: 
• Click the Open icon on the Standard toolbar. Or Use File >Open /Recent Documents to select the file you want 
• Click on Open. The Open dialog box appears. 
• Locate your file and select it. 
• Click on the Open button. The selected file will open immediately in existing window or new window (if a document is already open). 

6. Describe the use of Navigator.
Ans. Navigator in Writer is a useful tool which is used for working with large and complex documents. A large document has multiple objects like tables, headings, sections, hyperlinks and comments associated with it. The Navigator facilitates easy access and navigation between these objects. In the Navigator window, all the objects are displayed in the form of a list. To access an object, simply double-click on the object name. 

7. Describe I-Beam mouse pointer.
Ans. The mouse pointer, when brought over the text, generally changes its shape into I-beam. In this situation, it is referred to as a Text Select cursor. One can edit the text by moving the I-beam over the text and clicking on the desired text to edit it. 

8. What is the difference between Find and Find & Replace option?
Ans. The Find feature only searches for a particular text or format in the document, whereas, the Find & Replace feature can also replace the found text or format with another text/format. 

9.What is the difference between Replace and Replace All? 
Replace option replaces each occurrence of the found one by one (asks before each replacement) with the desired text, whereas, Replace All option replaces all the occurrences of the found text at once with the desired text. 

10.Describe text formatting.
 Text formatting is applied in a document to enhance the appearance of text and individual characters. It increases the readability of the document. From font sizes to font styles, text positioning to text attributes, text formatting includes all attributes that can be used to define the arrangement and visual display of text. To apply formatting, you first select the text and then apply the required text formatting. 

11. What is the difference between superscript and subscript?
Superscript: It places the selected text slightly above the line of text. Subscript: It places the selected text slightly below the text baseline. 

12.What is indent?How do you insert indent in you document?
Ans. The distance between the text boundaries and the page margins is called Indent. The indenting feature is used to move the complete paragraph or the first line to a specific number of places between the left or right margins. To indent a paragraph, follow these steps: 
• Select the paragraph to be indented, or place the cursor before the paragraph. 
• Click on the Increase Indent button on the Formatting toolbar. The selected text will shift ½ inch away from the left margin. 
• Click on the Decrease Indent button on the Formatting toolbar to move the text ½ inch closer to the left margin.

13. How do you open the page style dialog box? 
Ans. Open the OpenOffice Writer on your computer. Click on the Format menu and choose the Page option. The Page Style dialog box appears. 

14. What is page Break?
Ans. Page break is an important feature of OpenOffice Writer. It allows you to insert a break in the page, and moves the cursor on the new page. 

15. How can you insert symbols in your documents?
Ans. To insert a symbol, follow these steps: 
• Place the cursor at the position where you want to insert a symbol. 
• Click on the Insert menu and select the Special Character option. 
• The Special Character dialog box appears. 
• Choose the desired symbol and click on the Insert button. Selected symbol will appear at the cursor's position.

Unit IV: Electronic Spreadsheet

1.Why do you need formatting features in Calc?

Ans. Formatting features help to beautify the data and make the worksheet presentable. Formatting helps to enhance the overall look of the workbook. 

2. How to format numbers into labels and scientific notations in Calc?
Ans.To format numbers into labels, follow these steps: a. Select the range of cells to be formatted as labels. b. Right-click and select Format Cells option. c. Click on the Number tab. d. Select Text under the Category section. e. Click on OK. f. Observe that the data formatted as labels appear left-aligned. The Scientific format (also referred to as Standard or Standard Index Form) is a compact way to display very large or very small numbers. To format numbers into scientific format, do the following: a. Select the range of cells to be formatted as scientific. b. Right-click and select Format Cells option. c. Click on the Number tab. d. Select Scientific under the Category section. e. Click on OK. f. Observe that the data formatted in scientific format. 

3. Write the mechanism of changing the text alignment.

Ans. The Alignment tab is used to set the horizontal and vertical alignment of data in cells. 
To set a particular alignment, follow the given steps: 
• Select the cell or range of cells to be aligned. 
• Right-click and select Format Cells option. 
• Select the Alignment tab from the dialog box. 
• Select the desired horizontal alignment from the Horizontal drop-down list. 
• Select the desired vertical alignment from the Vertical drop-down list. 
• Click on OK. You can now notice the change in the alignment of the text. 

4. How can you change the orientation of text written in the spreadsheet cells?
Ans. To change the text orientation, do the following: 
• Select the cell or range of cells and Right-click and select Format Cells option. 
• Open Alignment tab from the Format Cells dialog box. 
• Under the Text orientation section, specify the angle in Degrees. If you enter a positive value, the text will rotate to the left and vice-versa. 
• Select the desired Reference edge to indicate the cell edge from which to write the rotated text. 
• Click on OK and note the change in text orientation.

5.How will you format cells to enter date?
Ans. Calc provides a variety of predefined Date and Time formats for different locales. To enter date type data use ‘/’ to separate month, day and year. 

6. What is the benefit of using Fill Handle?
Ans.Fill Handle is a feature that allows the user to extend and fill a series of numbers, dates, or even text to a desired number of cells. In the active cell of the spreadsheet, the Fill Handle is a small black box at the bottom right corner. Fill Handle tool eases the work of entering data. It is a shortcut way to fill cells by dragging the Fill Handle in the direction you want to fill. If the cell contains a number, the number will be filled in the series. If the cell contains text, the same text will be filled in the direction you choose. 

 

7. Explain cell referencing and its types with example.
Ans.A cell reference refers to a cell or range of cells on a spreadsheet, that can be used in a formula or function from one cell to the next along the row or column. A cell reference can be used to refer to the: 

• data from one or more contiguous cells on the worksheet. 

• data contained in different areas of a worksheet. 

• data on other worksheets in the same workbook. 
There are three types of cell referencing.

They are: 

a.Absolute cell reference-

A dollar sign ($) is added to both the column letter and row number. For example, $A$1. Absolute references remain the same when copied or filled into other cells. 

b. Relative cell reference-

No dollar signs are used. For example, A1. Relative references change when copied or filled into other cells, based on their position. 

c. Mixed cell reference-

A dollar sign is added to either the column letter or row number, but not both. For example, $A1 or A$1. Mixed references have one fixed coordinate and one that changes.

8. What is a chart? Why do you use chart in Calc?

Ans.A chart is a graphical representation of data in a worksheet. In a Calc worksheet, chart helps to provide a better understanding of large quantities of data. Charts make it easier to draw comparison, see growth and relationship among the values and trends in data. They provide an accurate analysis of information. 

9. How will you insert chart on a Calc spreadsheet?
Ans. Follow these steps to insert a chart in Calc: 
• Select the range of cells from the worksheet that contains the source data for the chart. 
• Open the Chart Wizard dialog box using one of the two methods: 
• Click on the Chart icon present on the Standard Toolbar. Or 
• Click on lnsert > Chart.

UNIT V: DIGITAL PRESENTATION

1. What are the different ways to insert a table in a slide?
Ans. A table can be inserted in a slide through the following two ways: 
a. Insert menu 
b. Title and Content slide layout To insert a table using Insert menu, follow these steps: 
• Choose Insert > Table. 
• The Insert Table dialog box appears. 
• Define the number of columns and rows. 
• Click on OK. 
• A table will be displayed according to the defined columns and rows. 
To insert a table using Title and Content slide layout, follow these steps: 
• Click on the Properties icon and choose Title and Content option. 
• Now, click on the Insert Table icon in the slide. 
• The Insert Table dialog box will open. 
• Enter the values in the fields of the Number of columns and Number of rows respectively. 
• Click on OK. 

2. In which menu the Image option found?
Insert 
3.What are the three options at the bottom of the Insert Picture dialog box?
 Link, Open, and Cancel 
4. How will you insert a link of a picture in Impress?
While inserting image, select image and check the Link option. 
5. In which menu is the gallery of shapes present?
Tools 
6. How can you resize a shape?
To increase or decrease the size of a shape: 
• Select the shape. 
• Bring the pointer to any of the eight resizing handles on the selected shape, and drag the handle inward to decrease and outward to increase the size of a shape. 
• If you want to resize the shape uniformly, then hold down the 
• Ctrl/Shift key while dragging the resizing handle 
7.How can you add text in a shape?
 To add text inside a shape: 
• Double-click on the shape. 
• The insertion point appears in the shape object. Now, type the text. 
• After typing the text, click on the blank area of the slide. 
• The text gets added into the shape. 
8.How will you add various effects to a graphical object?
 To add effects to a graphical object, do the following: 
• Select any shape object. 
• Click on the Format menu. 
Select the Area option from the drop-down menu. 
• The Area dialog box appears. Select the Shadow tab. 
• Click on the Use shadow checkbox in the Properties section. 
• Define the Distance between the object and its shadow, Color, and Transparency in their corresponding text boxes. Click on OK. 
• The object will appear with a shadow 
9. How can you change the color of a scheme?
To change the colour of a theme: 
• Click on the Properties button from the Sidebar. The Properties bar is displayed. 
• Choose the Background drop-down option and select Color to colour the slide background. 
• From the palette of colours, choose your desired colour for the slide background. 
10.In which dialog box and tab is the Solid fill option found?
 Area dialog box and Area tab. 
11.What do you understand by transition effects?
 Transition effects are special effects that are used to enhance the interest of the audience and make the slides attractive. To give a presentation the professional touch, you need to add Transition effects to the slides. 
12. How do you apply a sound effect to a slide? How do you check how it sounds?
To apply sound effect to a slide: 
• Click Insert > Audio or Video. 
• Select the audio file and click Open. The audio icon appears on the slide. 
To check how it sounds: 
• Select the audio icon on the slide by clicking on it. 
• Choose the Properties sidebar. 
• Click on Play in the Media Playback section. 
13.How do you set the advancement so that each slide advances to the next slide after 15 seconds?
 To set auto-advancement of the slides to 15 minutes, do the following: 
• Click on Slide > Slide Transition or click on the Slide Transition tab from the sidebar. 
• Select Automatically After for automatic advancement to the next slide. 
• Specify the duration of 15 minutes. 
• Click on the Apply Transition to All Slides button. 
• Click on the Slide Show button to watch the effect.