information technology class 10 ncert solutions

Electronic Spreadsheet Class 10 NCERT Solutions – The CBSE has changed the previous textbook and the syllabus of Std. X. The new notes are made based on the new syllabus and based on the New NCERT textbook. These notes are made in collaboration with many expert teachers. All the important Information are taken from the NCERT Textbook Information Technology (402).

The revised syllabus includes LibreOffice in Class 10 instead of OpenOffice.

Electronic Spreadsheet Class 10 NCERT Solutions

Chapter 4 – Analyze Data using Scenarios and Goal Seek

A. Multiple choice questions

1. Which of the following features is not used for data analysis in spreadsheets?
   (a) Consolidating data
   (b) Goal Seek
   (c) Subtotal
   (d) Page layout

2. Which of the following office tools is known for data analysis?
   (a) Writer
   (b) Calc
   (c) Impress
   (d) Draw

3. Which of the following operations cannot be performed using LibreOffice Calc?
   (a) Store and manipulate data
   (b) Create graphical representation of data
   (c) Analysis of data
   (d) Mail merge

4. What is the extension of a spreadsheet file in Calc?
   (a) .odb
   (b) .odt
   (c) .odg
   (d) .ods

5. The default function while using Consolidate is __.
   (a) Average
   (b) Sum
   (c) Max
   (d) Count

6. Group by is used in _ tool to apply summary functions on columns.
   (a) Consolidate function
   (b) Group and Outline
   (c) What-if scenario
   (d) Subtotal tool

7. Which tool is used to predict the output while changing the input?
   (a) Consolidate function
   (b) What-if scenario
   (c) Goal seek
   (d) Find and Replace

8. Which of the following is an example for absolute cell referencing?
   (a) C5
   (b) $C$5
   (c) $C
   (d) #C

9. _ analysis tool works in reverse order, finding input based on the output.
   (a) Consolidate function
   (b) Goal seek
   (c) What-if analysis
   (d) Scenario

B. State whether the following statements are True or False

1. A Consolidated function is used to combine information from two or more sheets into one.

2. The Consolidated function cannot be used to view and compare data.

3. Link to source data is checked and updates the target sheet if any changes made in the source data.

4. Using subtotal in Calc needs to use filter data for sorting.

5. The Subtotal tool can use only one type of summary function for all columns.

6. Only one scenario can be created for one sheet.

7. What-if analysis tool uses one array of cells.

8. Goal seek analysis tool is used while calculating the output depending on the input.

9. The output of What-if tool is displayed in the same cell

C. Fill in the blanks

1. Consolidate function is used to combine information from multiple sheets to ___________ the information.

2. Data can be viewed and compared in a single sheet for identifying trends and relationships using __ function.

3. ____ under the Data menu can be used to combine information from multiple sheets into one sheet to compare data.

4. The _____ tool in Calc creates the group automatically and applies functions on the grouped data.

5. ___ scenario is used to explore and compare various alternatives depending on changing conditions.

6. __ is a planning tool for what-if questions.

7. What-if analysis tool uses _ array of cells, one array contains input values and the second uses the __.

8. _ helps in finding out the input for the specific output.

D. Answer the following questions

1. Define the terms

(a) Consolidate function

Answer: The consolidate function is used to combine data from various sheets into one place for summary purposes. It helps to compare and analyze the data from the several data sources in one place to identify the relationships and trends of the data.

(b) What-if analysis

Answer: What-if tool is a planning tool for what-if questions. What-if tool uses a drop-down list to display the output based on the input. What-if tool is the process where we can understand how the values are changing in the cell and how it will affect the outcome of the formula in the cell.

(c) Goal seek

Answer: Goal seek is a method of finding the correct input only when the output is known. Goal seek helps to predict the output, we try to make changes of the input values for the desired output.

2. Give one point of difference between

(a) Subtotal and What-if

Answer: What-If scenarios involve for constructing hypothetical situations for analysis, whereas subtotals are used to summarize information within a dataset.

or

The Subtotal tool in Calc automatically groups the data and applies standard functions to it, such as sum and average. What-if tool is a planning tool for hypothetical scenarios that use a drop-down list to display the output based on the input.

(b) What-if scenario and What-if tool

Answer: A collection of possibilities known as a “what-if scenario” can be applied to the spreadsheet’s calculations. The multiple scenarios can be made on a single sheet. What-if tools are used to plan scenarios for hypothetical questions. This employs a drop-down list to display the output based on the input.

3. Give any two advantages of data analysis tools.

Answer: A data analysis helps in the analysis of data according to specific criteria. Using a Consolidating data, Subtotal, Goal Seek or what-if tool makes it simple to determine the greatest or minimum value, average, or sum in the spreadsheet.

Advantages of data analysis tools is –

• Identify opportunities to reduce costs
• Data analysis can predict future outcomes
• Analysis of the large dataset based on the real time information.

4. Name any two tools for data analysis.

Answer: There are many different types of tools available in LibreOffice calc to analyze the data, for example, Consolidating data, Subtotal, Goal Seek, What-if Scenarios and Multiple Operation.

• Consolidation data – Consolidating is a function which helps to combine data from the multiple sheets into one place to summarize the data.
• Subtotal – Subtotal creates a group of data and applies common functions like average, sum on the grouped data for data analysis.
• Goal Seek – Goal Seel helps to find the input for the specific output.
• What-if Scenarios – What-if scenarios is a set of values which can be used inside the calculation to create several scenarios.
• Multiple Operation – Multiple Operation tools can create a formula array to display the result. This tool uses two arrays of cells: one array contains the input values and second contains the formula.

5. What are the criteria for consolidating sheets?

Answer: “Consolidate by” provides two options. Labels for rows and columns. If you wish to match the labels to consolidate it, check either the row label, the column label, or both.

6. Which tool is used to create an outline for the selected data?

Answer: Group and Outline in LibreOffice calc helps to create an outline of the selected data and helps to group rows and columns together with only a single click, one can collapse (-) to hide or expand (+) the selected data.

Chapter 5 – Using Macros in Spreadsheet

A. Multiple choice questions

1. Macro Recordings can be enabled from the __ option in the menu bar.
   (a) Sheet
   (b) Data
   (c) Tools
   (d) Window

2. Which of the following is an invalid Macro Name?
   (a) 1formatword
   (b) format word
   (c) format*word
   (d) Format_word.

3. Which of the following Libraries contains modules with pre recorded macros and should not be changed?
   (a) My Macros
   (b) LibreOfficeMacros
   (c) Untitled1
   (d) Test

4. Identify which of the following is a programming Language?
   (a) Calc
   (b) BASIC
   (c) Writer
   (d) Macro.

5. The Module can be executed from the IDE by pressing _____.
   (a) F3
   (b) F4
   (c) F5
   (d) F6

5. Which of the following is the default name of the Macro ___.
   (a) Default
   (b) Main
   (c) Macro1
   (d) Main_Macro

B. Fill in the blanks

1. __ library is automatically loaded when the document is opened.

2. IDE stands for ___________________.

3. Macro as a function is capable of accepting and returning a _.

4. Macro ____ allows us to add, delete a module.

5. The code of macro begins with _ followed by the name of the macro and ends with _.

6. By default a macro is saved in the _ .

C. State whether the following statements are True or False

1. Macro is a group of instructions executing a single instruction.

2. Once created, Macro can be used any number of times.

3. By default, the Macro recording feature is turned on.

4. It is not possible to stop recording a Macro.

5. Every Macro should be given a unique name.

6. A macro once created can be edited later.

D. Answer the following questions

1. What is a Macro? List any two real life situations where they can be used.

Answer: A macro is a single command that carries out several commands. These instructions can be a series of keystrokes or commands that are useful as many times as necessary in the future.

Two real life example of Macro is –

• Automatically data entry in spreadsheets.
• Creating templates
• Replace a repetitive series of keyboard actions.

2. List the actions that are not recorded by a macro.

Answer: The following actions are not recorded from the macro –

• Opening of windows
• Actions performed in a different window
• Window switching
• Action that is not related to the spreadsheet.

3. How is LibreOffice Macros Library different from my Macros?

Answer: The library office provides the LibreOffice Macros library, which consists of modules with pre-recorded macros that shouldn’t be modified, whereas Our Macros is made up of macros that we create or add to LibreOffice.

4. Differentiate between predefined function in Calc and Macros as a function

Answer: Macros give customized functionality to create your own function but predefined functions perform some specified calculation. We are not allowed to modify the predefined function but Macros can be modified.

5. List the rules that should be kept in mind while naming a macro.

Answer: Rules for naming a Macros, Module or a Library are –

• Begin with a letter
• Not contain spaces
• Not contain special character except underscore ( _ )

6. Give any one advantage of macros.

Answer: The advantages of macros are –

• A macro can be used again and again
• A macro can be used as function
• A macro does not check any type error

Chapter 6 – Linking Spreadsheet Data

A. Multiple choice questions

1. Insert Sheet dialog can be invoked from ___.
   (a) sheet
   (b) insert
   (c) tools
   (d) Windows

2. __ refers to cell G5 of sheet named My Sheet.
   (a) $My Sheet.’G5’
   (b) $My Sheet_’G5’
   (c) $ ‘MySheet’.G5
   (d) $ ‘MySheet’_G5

3. The path of a file has __ forward slashes.
   (a) four
   (b) three
   (c) two
   (d) one

4. Which of the following features is used to jump to a different spreadsheet from the current spreadsheet in LibreOffice Calc?
   (a) Macro
   (b) Hyperlink
   (c) connect
   (d) Copy

B. Fill in the blanks

1. A relative hyperlink stores the location with respect to the _ location.

2. While inserting tables from a webpage _ selects the entire HTML document.

3. The extension of LibreOffice base is __.

4. __ are used to enclose sheet names as there might be a space within sheet names.

5. The From file option of _ Dialog box allows inserting a sheet from another file.

C. State whether the following statements are True or False notes

1. A sheet can only be added before the current sheet.

2. If the ‘sales’ sheet has a reference to the ‘cost’ sheet then any changes made to the ‘cost’ sheet will be reflected in the sales sheet as well.

3. It is not possible to link a sheet as a reference in another sheet.

4. We can insert data from a table created on a web page into a spreadsheet.

5. A hyperlink once created on a sheet cannot be deleted.

D. Answer the following questions

1. Name the two ways to link the sheets in a LibreOffice Calc.

Answer: In LibreOffice Calc there is two different ways to link other sheets –

• Creating reference to other documents using keyboard and mouse
• By linking external data.

2. Differentiate between Relative and Absolute Hyperlink.

Answer: A hyperlink can be either absolute or relative.

• Absolute Hyperlink: An absolute hyperlink stores the complete location where the file is stored. In absolute hyperlink if a file is deleted then the absolute hyperlink will not work. For example: C:\Users\ADMIN\Downloads\try.ods is an absolute link as it defines the complete path of the file.

• Relative hyperlink: A relative hyperlink stores the location with respect to the current location. For example: Admin\Downloads\try.ods is a relative hyperlink as it is dependent on the current location. In the relative hyperlink if the file is moved then also the relative hyperlink will work because it does not store the complete path.

3. Write steps to extract a table from a web page in a spreadsheet.

Answer: The spreadsheet allows you to insert tables from HTML documents or web pages into calc. You can use the External data dialog box for inserting tables from a HTML document or from the web pages .

The steps for extract a table from web page are –

• Step 1: Click on Sheet > Link to External Data
• Step 2: The External Data dialog box will be displayed
• Step 3: Type the URL of the source document or select the drop down list
• Step 4: Select the Language for import

4. Write steps to register a data source that is in *.odb format.

Answer: LibreOffice Calc allows linking spreadsheet documents with database and with other data sources. Steps for register a data source are –

• Step 1: Click Tools > Options > LibreOffice Base > Database
• Step 2: Click New button to open Create Database Link
• Step 3: Select location of the database using Browse option
• Step 4: Type the name to use as the registered name for the database
• Step 5: Click Ok

5. State advantages of extracting data from a web page into a spreadsheet.

Answer: The advantage of extracting data from a web page into spreadsheet are –

• Data will be accurate: Extracting data from the webpage will help you to reduce the risk of errors and the data will be accurate.
• Data will be consistent: Extracting data from the webpage will be consistent.
• It will save time: If you are adding one by one data in the Spreadsheet then it will take a lot of time. Instead you can extract the data from the web page to save time.

Chapter 7 – Share and Review a Spreadsheet

A. Multiple choice questions

1. Sharing allows to edit the spreadsheet by
   (a) single user
   (b) different users simultaneously
   (c) one by one users
   (d) one after other users

2. Sharing spreadsheet feature allows to save the changes in
   (a) multiple sheets
   (b) user’s sheet
   (c) in a same sheet
   (d) in different sheet

3. The Recording Changes feature of LibreOffice Calc provides different ways to record the changes made by __ in the spreadsheet.
   (a) one user
   (b) other user
   (c) the user
   (d) one or other users

4. In Calc, the comments are added
   (a) automatically
   (b) by author
   (c) by reviewer
   (d) all of above

5. The changes by team members in the spreadsheet can be accepted or rejected by
   (a) the team members
   (b) any of the user
   (c) owner
   (d) other users

B. State whether the following statements are True or False

1. Spreadsheet cannot be shared to work with more than one user?

2. Some of the features become unavailable when the spreadsheet is in shared mode.

3. You can record changes in the spreadsheet when the spreadsheet is opened in shared mode.

4. File menu is used to Record changes for the spreadsheet.

5. You can add a note or suggestion in the spreadsheet using Insert Comment.

6. Formatting comments can be used to change the font color of the comment.

C. Fill in the blanks notes

1. The title bar of the document shows ______ along with the filename for the shared mode of the spreadsheet.

2. The shared mode spreadsheet allows __ users to access and edit the spreadsheet at the same time.

3. Recording changes automatically __ the shared mode of a spreadsheet.

4. Click on the Edit menu, Track Changes and then select __ to record the changes in the spreadsheet.

5. The border color of the changed cell will be __.

6. __ is used to add notes or suggestions to a cell in a spreadsheet.

7. The comment box can be formatted just like formatting the __ (cell contents).

D. Answer the following questions

1. Define the terms

• (a) Sharing Spreadsheet: Sharing a spreadsheet helps to collaborate the sheet with other users, It allows multiple users to open and edit the same file at the same time.
• (b) Record changes: The record changes feature allows you to know a history of changes made in the document from the other users.

2. Write the commands to perform

• (a) Sharing Spreadsheet: Tools > Share Spreadsheet
• (b) Record changes: Edit > Track Changes > Record

3. Which menu is used to perform the functions

• (a) Track Changes: Edit menu
• (b) Saving Spreadsheet: Edit menu

4. What do you understand by reviewing the changes in the spreadsheet?

Answer: Before sending the final spreadsheet, the reviewer can examine all of the changes made by the team members using accept or reject options before creating the final spreadsheet.

5. Differentiate between Merging and Comparing Spreadsheet.

Answer: When a spreadsheet is returned with revision by the several reviewers. Instead of reviewing each change individually it may be quicker to examine them using compare documents.

If you have two separate versions of the same spreadsheet file and you want to combine these two sheets at once then you can use Merging features in LibreOffice Calc.

Employability skills Class 10 Notes

• Unit 1- Communication Skills Class 10 Notes
• Unit 2- Self-Management Skills Class 10 Notes
• Unit 3- Basic ICT Skills Class 10 Notes
• Unit 4- Entrepreneurial Skills Class 10 Notes
• Unit 5- Green Skills Class 10 Notes

Employability skills Class 10 MCQ

• Unit 1- Communication Skills Class 10 MCQ
• Unit 2- Self-Management Skills Class 10 MCQ
• Unit 3- Basic ICT Skills Class 10 MCQ
• Unit 4- Entrepreneurial Skills Class 10 MCQ
• Unit 5- Green Skills Class 10 MCQ

Employability skills Class 10 Questions and Answers

• Unit 1- Communication Skills Class 10 Questions and Answers
• Unit 2- Self-Management Skills Class 10 Questions and Answers
• Unit 3- Basic ICT Skills Class 10 Questions and Answers
• Unit 4- Entrepreneurial Skills Class 10 Questions and Answers
• Unit 5- Green Skills Class 10 Questions and Answers

Information Technology Class 10 Notes

• Unit 1- Digital Documentation Class 10 Notes
• Unit 2- Electronic Spreadsheet Class 10 Notes
• Unit 3- RDBMS Class 10 Notes
• Unit 4- Web Applications And Security Class 10 Notes

Information Technology Class 10 MCQ

• Unit 1- Digital Documentation Class 10 MCQ
• Unit 2- Electronic Spreadsheet Class 10 MCQ
• Unit 3- RDBMS Class 10 MCQ
• Unit 4- Web Applications And Security Class 10 MCQ

Information Technology Class 10 Questions and Answers

• Unit 1- Digital Documentation Class 10 Questions and Answers
• Unit 2- Electronic Spreadsheet Class 10 Questions and Answers
• Unit 3- RDBMS Class 10 Questions and Answers
• Unit 4- Web Applications And Security Class 10 Questions and Answers

Details of NCERT books –
NATIONAL COUNCIL OF EDUCATIONAL RESEARCH AND TRANING
Domestic Data Entry Operator
First Edition
DTP Cell Delhi: NCERT, New Delhi
November 2022

NATIONAL COUNCIL OF EDUCATIONAL RESEARCH AND TRANING [Dinesh Prasad Saklani] (Director). (2022). Domestic Data Entry Operator (First Edition) [English]. Anup Kumar Rajput. https://cbseacademic.nic.in/web_material/Curriculum25/publication/secondary/402_IT_X.pdf

Disclaimer : The Notes, MCQs, and Questions and Answers are made by expert teachers from different schools, but if you feel that there are any mistakes in the Electronic Spreadsheet Class 10 NCERT Solutions, please feel free to leave a comment below or please send mail to anuraganand2017@gmail.com.

The book and the study material are available on the CBSE official website and on the NCERT website also, the teachers have tried to make a summary and try to make it easy to understand which will help the students to improve their CBSE results.

Digital Documentation Class 10 NCERT Solutions – The CBSE has changed the previous textbook and the syllabus of Std. X. The new notes are made based on the new syllabus and based on the New NCERT textbook. These notes are made in collaboration with many expert teachers. All the important Information are taken from the NCERT Textbook Information Technology (402).

The revised syllabus includes LibreOffice in Class 10 instead of OpenOffice.

Digital Documentation Class 10 NCERT Solutions

Chapter 1: Introduction to Styles

A. Multiple choice questions

1. Which of the following features in LibreOffice Writer is/are used to create the given document?
   (a) Page borders
   (b) Envelope
   (c) Picture from File
   (d) Indexes and Tables

2. Styles menu (from sidebar) in Writer provides options to work on __.
   (a) Paragraph Styles
   (b) Frame Styles
   (c) Page Styles
   (d) All of the above

3. What is the style template in LibreOffice Writer?
   (a) Pre-determined form and mode of document file
   (b) One kind of model style
   (c) One type of document
   (d) Cluster of documents in Writer

4. Which of the following gives the status of your document like page numbers, number of pages?
   (a) Status bar
   (b) Standard toolbar
   (c) Formatting
   (d) Title bar

5. Which of the following can be used to access a style menu?
   (a) F11 function key
   (b) Sidebar Menu
   (c) Formatting toolbar
   (d) All of these

B. Fill in the blanks

1. A __ is a collection of different formats

2. Styles are especially handy in __.

3. Proper use of styles improves __ in a document.

4. The first five buttons at the top of the Styles window select the category of __.

5. Using a predefined __ creates Bookmark in the document.

6. On opening a new file _ Style is used for formatting the document.

7. In page layout documents, you can arrange __ like text boxes and graphics.

8. Character styles are often integrated in __ Style.

9. __ allows to apply style at different places in the document.

10. Predefined Style __ be updated by Drag and Drop method.

C. Short answer questions

1. What do you understand by styles in LibreOffice writer document?

Answer: Styles are predefined sets of formatting options in LibreOffice Writer that can be applied to text, paragraphs, lists, and other elements in a document. They make it possible to format the entire document effectively and consistently.

2. Write advantages of using Style over manual formatting, for designing a document.

Answer: The advantage of using style over manual formatting are –

• Styles enable us to format documents consistently. 
• We may easily change the current format by using styles. 
• Major formatting adjustments are made easy with styles.

3. What are the different categories of style in the LibreOffice writer document?

Answer: There are six different types of style categories you can use in LibreOffice Writer. 

• Page Style – Basic page layout like page size, its margin, placement of header and footer, footnote, borders and background.
• Paragraph Style – Paragraph formatting includes tab stops, text alignment, line spacing and borders.
• Character Style – Character styles allow changing the text color, text size, highlighting text and emphasizing it. 
• Frame Style – Frame Styles allows to format a frame by specifying its size, position, border and how the text is placed around the picture.
• List Style – List style can be used to style lists by putting numbering or bullets of a different kind or specify numeric format.
• Table Style – Table Style category allows to format a table by adding borders, using different text or border color(s), aligning text inside the table, having different patterns or text color.

4. Write down the steps to update a style.

Answer: To update style in LibreOffice Writer the steps are –

• Step 1: Select formatted paragraph
• Step 2: Go to Style menu and click on update button
• Step 3: Using the Style Action button click on Updated Selected Style.

5. What do you understand by custom styles in LibreOffice writer?

Answer: Custom styles are used when the existing styles do not match the requirement, then you can create a Custom Style. There are two different ways to create custom style a) From the selection b) By using drag and drop 

6. In a document Introduction paragraph is to be designed extensively by setting its font (face, size, weight, color), space above it and giving number to heading Given below are the steps used to do so.

• (i) Select the Introduction (paragraph)
• (ii) Open Font list from Toolbar
• (iii) Select the font
• (iv) Open Font size from Toolbar
• (v) Select the desired font size
• (vi) Select Font weight (Bold) from the toolbar
• (vii) Open Font color from Toolbar
• (viii) Select desired color
• (ix) Using Format menu option, select Spacing > Paragraph > Indent and Spacing
• (x) Edit space above paragraph
• (xi) Add number by Selecting Numbered list from Toolbar.

Answer: The below steps are given for the detailed process of formatting an introduction paragraph in a document. 

• (i) Using click and drag to highlight the introduction paragraph
• (ii) In the toolbar, Click on the dropdown menu to display the current font.
• (iii) In the toolbar, Click on the dropdown menu to select the font type
• (iv) In the toolbar, Select the font size from the dropdown menu.
• (v) In the toolbar, Click on the dropdown menu to select appropriate font size for the introduction paragraph
• (vi) The “B” icon in the toolbar is used to make the Font weight Bold.
• (vii) In the toolbar, Click on the font color icon to change the color of the text
• (viii) In the toolbar, You can use color palette for the desired color
• (ix) Click on Format menu then navigate to “Indent and Spacing” and find “Spacing” or “Paragraph” 
• (x) You can adjust the space before the paragraph 
• (xi) To select a number list you can click on Format > Bullets and Numbering.

7. Give two examples, where instead of Style, using manual formatting will be beneficial.

Answer: The two examples where manual formatting will be beneficial – 

• Editing a poster or flier
• Editing documents in some specific areas

8. Give one situation, in which you will prefer to use Fill Format for styling your document.

Answer: Fill Format method is very useful when the same style we want to apply in many places in the document. 

9. Write steps to load style(s) from a template.

Answer: Follow the following steps to load styles from a template –

• Step 1: In the style menu click on Load Style.
• Step 2: Select the document which you want to Load on the document
• Step 3: Click OK to copy the style

Chapter 2: Working with Image

A. Multiple choice questions

1. The text or image which appears faintly in the background of a page is called _____.
   (a) Watermark
   (b) Trade mark
   (c) Copyright
   (d) Embossing

2. JPG or JPEG in image format stands for _____.
   (a) Joint Photographic Experts Group
   (b) Joint Picture Experts Group
   (c) Joint Photographic Experts Graph
   (d) Joint Photographic Experts General

3. In the Drawing Object Properties toolbar, Grouping options provided are _____.
   (a) Exit Group
   (b) Ungroup
   (c) Enter Group
   (d) All of these

4. Which of the following is not the correct file extension for an image file?
   (a) GIF
   (b) JPEG
   (c) Odt
   (d) PNG

5. Image toolbar does not provide a tool for _____.
   (a) filtering
   (b) cropping
   (c) copying
   (d) flipping

B. Fill in the blanks

1. _ tool cuts off the non-desirable part of the image.

2. To change both brightness and contrast of the image ____ tool can be used.

3. To simulate the effect of time on a picture _ tool is used.

4. _ place image at the bottom of all objects.

5. An image can be deleted by __ it and pressing DELETE key.

6. In drawing tools, basic shapes list provide __ shapes.

7. Anchor acts as _ point for a drawing.

8. There are ____ options for aligning an image horizontally.

9. The _ handles of the image are used for rotating it.

10. Changing properties of an object _ creation, retain them throughout the session

C. Short answer type questions

1. What is a digital image? How can you create one?

Answer: A picture is a digital image, which is represented by a finite number of pixels, or digital values, that can be either 0 or 1. These are kept in several kinds of graphics files like GIF, JPG, JPEG, PNG, BMP, etc.

2. Write steps to insert an image from the gallery using Drag and Drop method.

Answer: You can use the Drag & Drop feature to insert images into the document. Usually, you can simply drag the image from its source and drop it where you want it to be on the page.

3. How is resizing of image different from cropping it?

Answer: Cropping removes unwanted areas from an image, while resizing modifies the images entire dimensions. Resizing effects on the file size and image quality. 

4. What are the tools available in drawing toolbar? Describe any five tools.

Answer: Drawing toolbar is a feature of LibreOffice Writer, this drawing toolbar is basically helpful when we want to draw shapes and graphics in a document. Some of the basic drawing toolbar tools are Cure, polygen, Rectangle, Circle, Flowchart, Textbox, basic shapes etc.

5. How is linking of an image different from embedding? Give a situation in which you would prefer to link an image.

Answer: In LibreOffice Writer embedding is used to embed the image and save the copy of the image in the document. Linking means when you link to the image file instead of saving a copy. The link is better than embedding because linking saves space in case multiple copies of the same image are required.

6. Write steps to change properties for drawing objects.

Answer: Drawing object properties can be modified either at the time of creation or after its creation. The steps to change properties for drawing objects are –

• Step 1: Select the object 
• Step 2: Click on Drawing Object Properties Toolbar and click on modified
• Step 3: Change the value of parameter
• Step 4: Repeat step 2 and 3 to change all desired properties.

7. What are the benefits and drawbacks of grouping drawing objects?

Answer: When an object is drawn with many shapes, it can be combined to work as a single entity using grouping.

8. Describe any two tools from Drawing Object Properties toolbar.

Answer: The Drawing Object properties toolbar contains different types of tools to manipulate shapes and graphics. The two tools are Ellips and textbox.

9. Write steps to insert an image in a basic drawing shape.

Answer: Steps for inserting image in a basic drawing shape are –

• Step 1: In document place the cursor where you want to insert image
• Step 2: Select and click on Insert > Image from menu bar.
• Step 3: Select the picture from Insert Image dialog box
• Step 4: Click on Open button to insert an image in document

10. Write factors controlling positioning of an image in a document.

Answer: Different factors control the positioning of an image in a document are Arrangement and Alignment.

Chapter 3: Advanced Features of Writer

A. Multiple choice questions

1. Which of the following is NOT true about Table of Contents, Index or Bibliography dialog box?
   (a) It has four tabs
   (b) On the Type tab, by default, the checkbox for Protected against Manual Changes option will be selected.
   (c) The Styles tab contains options to change the background color.
   (d) None of the above

2. Which of the following tabs is by default active when the Table of Contents, Entries or Bibliography dialog box is opened?
   (a) Entries
   (b) Background
   (c) Styles
   (d) Type

3. Which of the following tabs contains options to set styles for various entries in the ToC?
   (a) Entries
   (b) Background
   (c) Styles
   (d) Type

4. Which of the following can be added in the background of Table of Contents in LibreOffice Writer?
   (a) Color
   (b) Graphic
   (c) Both a and b
   (d) Neither a nor b

5. Which of the following is NOT true about templates?
   (a) The styles and formatting features can be reused.
   (b) LibreOffice provides online templates
   (c) We cannot create our own templates.
   (d) None of the above.

6. Which of the following is the shortcut key to open the Templates dialog box?
   (a) Ctrl+Alt+N
   (b) Shift+Ctrl+N
   (c) Ctrl+Alt+T
   (d) Shift+Alt+T

7. Which of the following buttons, in the Templates dialog box, will be clicked to save a template displayed in the list of templates?
   (a) Export
   (b) Import
   (c) Move
   (d) None of the above

8. Which of the following is the shortcut key to select the entire document?
   (a) Ctrl+S
   (b) Ctrl+A
   (c) Ctrl+D
   (d) Ctrl+B

9. Which of the following is the correct sequence of options to open the Templates dialog box?
   (a) File > Manage Templates > Templates
   (b) File > Templates > Manage Templates
   (c) Insert > Templates >Manage Templates
   (d) Insert > Manage Templates > Templates

10. Which of the following is true about the Track Changes feature of Writer?
    (a) You cannot record a change made in the document.
    (b) A comment of a particular author only can be deleted
    (c) Any change made to the document is permanent.
    (d) None of the above

11. Which of the following menus contains the Track Changes option?
    (a) File
    (b) Edit
    (c) View
    (d) Insert

12. Which of the following is the shortcut key to start recording the changes being made in the document?
    (a) Ctrl+Shift+C.
    (b) Alt+Shift+C
    (c) Ctrl+Alt+C
    (d) Shift+C+F2

B. Fill in the blanks

1. To navigate to the topic from the ToC, press _ key while clicking the mouse button on that topic.

2. To remove the applied paragraph styling in the ToC, select the outline level in the Levels list box, and then click the _ button.

3. If the checkbox for___________________ option is selected, the ToC is protected from any accidental change.

4. To update the ToC manually, right click and select _ option from the pop up menu.

5. The _ tab contains options to set the number of columns that we want to have in our ToC.

6. A ____________ is a preset layout that helps us to create professional and formal documents easily.

7. The default template in Writer is ________.

8. To find the template that is being used in the current document, select _ option from the File menu.

9. The ________ button is clicked in the Templates dialog box to view online templates.

10. The ______ feature of Writer offers us an alternative method to keep a record of all the changes made in the original document.

11. The shortcut key to start recording the changes is _.

12. After the Track Changes feature is ON, the added characters are shown as __ text.

C. State whether the given statements are True or False

1. The topics in Table of Contents are hyperlinked.

2. The Table of Contents in LibreOffice Writer can be updated automatically.

3. TABLE of Contents can be inserted even if the section headings are not styled.

4. Once a ToC is created, it cannot be edited.

5. We cannot add a graphic as a background of ToC.

6. A single template can be used for multiple documents.

7. A template cannot contain graphics.

8. All documents in Writer are based upon templates.

9. The online templates cannot be added to the list of templates in the templates dialog box.

10. A template once created can be edited again and again.

11. The changes recorded have to be accepted by the original author.

12. We can delete the comments added in a document by the user.

D. Answer the following questions

1. What is the need of table of contents?

Answer: Table of Contents is a feature which enables the automatic insertion of a table of contents (Index) to a document. The headers and subheadings of the document automatically become the source for the entries or contents of this table.

2. What will happen if the ‘Protected Against Manual Changes’ option is not selected in the Type tab of Table of Contents, Index or Bibliography dialog box?

Answer: The Protected against Manual Changes checkbox is checked by default. This protects the TOC against accidental modifications. The contents of the ToC can be edited directly on the document page, just like any other text on the document, if this box is left unchecked.

3. Name the five tabs present in the Table of Contents, Index or Bibliography dialog box.

Answer: The five tabs present in the Table of Contents are –

1. Index/Table – In this tab you can add Title, Type, protected against manual changes and evaluate up to level.
2. Entries – In this tab you can add structure and Formatting for example, E#, E, T, #, LS, LE etc. 
3. Styles – In this tab you can change the labels of heading, and you can add paragraph style.
4. Columns – In this tab you can add multiple columns, and you can set column width and spacing.
5. Background – In this tab you can set background color.

4. What do you mean by customization of ToC?

Answer: After the ToC is inserted, we can modify it depending on our requirements. To perform this, right-click on the ToC anywhere, then choose the Edit Index option from the popup menu.

5. How headings and sub-headings of a document differentiated in ToC?

Answer: LibreOffice Writer supports 10 levels of heading from H1 to H10 in LibreOffice Writer. You can also use sub headings in LibreOffice Writer to show the table of content in hierarchical form where H1 will show the top of the heading and H2 will show the sub heading of Heading 1. 

6. Define a template.

Answer: A template is a pre-designed arrangement that makes it simple to create formal and/or professional documents. Anything that can be found in a conventional document, including text, images, and a collection of styles, can also be found in templates. With LibreOffice, every document is built using templates.

7. Give any one advantage of using a template for your document.

Answer: Using templates makes creating documents easier. Using templates can reduce workloads, reduce stress, and boost productivity at the same time.

8. What is the difference between importing and exporting a template?

Answer: Once the template is constructed, it can be exported using the export template feature for later use or you can also download the template from the internet. You can also import the template into LibreOffice Writer and make it visible in the list of templates in the Templates dialog box.

10. When is exporting of templates useful? Give any one reason.

Answer: When you wish to use the same template in several documents or to share it with others, exporting templates might be useful.

11. What is the difference between Accept Track Change and Accept All Tracked Changes buttons?

Answer: the original author may approve changes made to the document by selecting the Accept All Track Changes button, which will approve all changes made. Accept Track Change will be accepted only once at a time. 

12. How do we prepare a document for review?

Answer: When a document is shared with one or more users for review or editing, the Track Changes capability is used. Therefore, it is important to ensure that any changes are documented before sharing the document.

This will guarantee that the original author of the document will have the choice to approve or disapprove the modifications made after the review is complete. Therefore, the original author should start documenting the modifications being made and prepare the document for review before sending it out for review.

Employability skills Class 10 Notes

• Unit 1- Communication Skills Class 10 Notes
• Unit 2- Self-Management Skills Class 10 Notes
• Unit 3- Basic ICT Skills Class 10 Notes
• Unit 4- Entrepreneurial Skills Class 10 Notes
• Unit 5- Green Skills Class 10 Notes

Employability skills Class 10 MCQ

• Unit 1- Communication Skills Class 10 MCQ
• Unit 2- Self-Management Skills Class 10 MCQ
• Unit 3- Basic ICT Skills Class 10 MCQ
• Unit 4- Entrepreneurial Skills Class 10 MCQ
• Unit 5- Green Skills Class 10 MCQ

Employability skills Class 10 Questions and Answers

• Unit 1- Communication Skills Class 10 Questions and Answers
• Unit 2- Self-Management Skills Class 10 Questions and Answers
• Unit 3- Basic ICT Skills Class 10 Questions and Answers
• Unit 4- Entrepreneurial Skills Class 10 Questions and Answers
• Unit 5- Green Skills Class 10 Questions and Answers

Information Technology Class 10 Notes

• Unit 1- Digital Documentation Class 10 Notes
• Unit 2- Electronic Spreadsheet Class 10 Notes
• Unit 3- RDBMS Class 10 Notes
• Unit 4- Web Applications And Security Class 10 Notes

Information Technology Class 10 MCQ

• Unit 1- Digital Documentation Class 10 MCQ
• Unit 2- Electronic Spreadsheet Class 10 MCQ
• Unit 3- RDBMS Class 10 MCQ
• Unit 4- Web Applications And Security Class 10 MCQ

Information Technology Class 10 Questions and Answers

• Unit 1- Digital Documentation Class 10 Questions and Answers
• Unit 2- Electronic Spreadsheet Class 10 Questions and Answers
• Unit 3- RDBMS Class 10 Questions and Answers
• Unit 4- Web Applications And Security Class 10 Questions and Answers

Details of NCERT books –
NATIONAL COUNCIL OF EDUCATIONAL RESEARCH AND TRANING
Domestic Data Entry Operator
First Edition
DTP Cell Delhi: NCERT, New Delhi
November 2022

NATIONAL COUNCIL OF EDUCATIONAL RESEARCH AND TRANING [Dinesh Prasad Saklani] (Director). (2022). Domestic Data Entry Operator (First Edition) [English]. Anup Kumar Rajput. https://cbseacademic.nic.in/web_material/Curriculum25/publication/secondary/402_IT_X.pdf

Disclaimer : The Notes, MCQs, and Questions and Answers are made by expert teachers from different schools, but if you feel that there are any mistakes in the Digital Documentation Class 10 NCERT Solutions, please feel free to leave a comment below or please send mail to anuraganand2017@gmail.com.

The book and the study material are available on the CBSE official website and on the NCERT website also, the teachers have tried to make a summary and try to make it easy to understand which will help the students to improve their CBSE results.