CBSE Class 11 Informatics Practices Worksheet Set 10 Solved

1. What is the need of word processing software? 

2. What do you mean by ‘Work Area’? 

3. What is a spreadsheet? 

4. What are the two methods to OpenOffice Calc? 

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

6. Define i) Scroll bar ii) Tabs 

7. How is Find and Replace option useful? 

8. What is the difference between Cut text and Copy text? 

9. What is autofill feature in a spreadsheet? Write the steps to use it? 

10. Explain different data types that can be entered to a cell in Calc. 

11. What do you mean by formatting data in a spreadsheet? 

12. Write and explain any two tool bars available in Calc.

VALUE POINTS 

1. A word processing software is required for the creation of documents that are text-based. It has tools that allow the user to edit, format and print document.

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

3. A spreadsheet stores data in the form of a table comprising of rows and columns. It is used to store, arrange, and sort data, and perform calculations on numeric data.

4. i)As a Windows application, you can click Start ->Programs ->OpenOffice

ii) Double click the OpenOffice icon on the desktop

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)Tabs: (File, Edit, View, Insert, etc.) contain drop down menu which have commands provided by the tab.

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. Cut a text means its removing the text from current location to another location whereas copying a text means its creating only a copy of the text and original text remains in its position.

9. This feature in Calc is used to automatically generate sequence of numbers(data) based on a defined series. Eg:Type 1 in first cell , 2 in second cell drag the autofill dark rectangle down to remaining cell vertically or horizontally.

10. a) Labels b) Numbers or Values c) Formulas- Explanation of these 

11. Formatting a document means adding elements of style and presentation to documents 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.

12. a)Title Bar   b)Menu Bar   c) Help   d)Standard tool Bar   e) Find Barn   f) Formula Bar. Explanation of any two

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