CBSE Class 11 Informatics Practices Worksheet Set 09 Solved

1. What is the task of a word processing software? 

2. What do you mean by ‘Status Bar’? 

3. Write any two uses of spreadsheet.

4. How to move data within a spreadsheet? 

5. List the components of the main screen of OpenOffice Writer. 

6. Define i) Scroll bar ii) Work Area

7. How is Find and Replace option useful in OpenOffice Writer? 

8. What is the difference between Save and Save As command? 

9. What do you mean by formatting data in spreadsheet?

10. How will you control the flow of text in a cell in a spreadsheet? 

11. What are the different types of cell alignments available in a spreadsheet?

12. What are the various type of data that can be entered in a cell in a spreadsheet?

VALUE POINTS 

1. A word processor is a software or a device that allows users to create, edit, and print documents. It enables you to write text, store it electronically, display it on a screen, modify it by entering commands and characters from the keyboard, and print it.

2. Status Bar: It displays information about the current open document. It displays the current page number, total pages in the document, zoom slider etc.

3. Managing financial data such as bank account information, budgets, transactions, billings and receipts. Handling inventory, reviews, employee information, surveys, etc.. (Any two uses)

4. For moving data from one cell to another we have the cut-copypaste functions.

5. Tabs, Ruler Bar, Status Bar,Scroll Bar,Work area

6. i)Scroll Bar: There are two scroll bars – horizontal and vertical. They help to scroll the content or the body of document.

ii)Work area: It is the working area where the text of the document is typed.

7. Find and Replace: This is used to find words and then replace it with the new one. Go to the Edit menu ,click Find and Replace option enter the word you want to search and enter the word you want to replace with.

8. The save command is used to save a file for the first time. A save as command can be used to save a file for the first time as well as to save an existing file in a different name so that a copy of the same file with another name can be created.

9. Formatting a spreadsheet means adding elements of style and presentation to spreadsheet to improve the readability and make them more attractive. To enhance the appearance of spreadsheets various formatting options are available in the Formatting Bar and Format Menu such as alignment, font, size, and style.

10. In order to control the flow of text within cells, Calc provides various ways: a)Merging / Splitting Cells

b)Wrap Text: It means to break the text into multiple lines i.e., adjusting the row height to fit the text within the cell but keeping the column width of the cell same.

11. Left Align : The left edge of the text is along the left cell border.

Center Align : Both the left and right edges are equally distant from the left and right cell borders respectively.

Right Align : The right edge of the text is along the right cell border.

Justify : Aligns the text to the left and the right cell borders.

12. Labels b) Numbers or Values   c) Formulas- Explanation of each 

Please click on below link to download CBSE Class 11 Informatics Practices Worksheet Set I Solved