Electronic Spreadsheet 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.