# Electronic Spreadsheet Class 10 Questions and Answers

Teachers and Examiners collaborated to create the Electronic Spreadsheet Class 10 Questions and Answers. All the important Questions and Answers and taken from the NCERT Textbook Information Technology ( 402 ).

Contents

## Electronic Spreadsheet Class 10 Questions and Answers

1. What is Consolidating data?

Answer – The Data Consolidation tool summarises data from multiple worksheets or workbooks into a single worksheet that you can simply update. Consolidate has a graphical interface for copying data from one set of cells to another and then performing one of a dozen operations on it. Consolidation allows the contents of cells from many sheets to be consolidated in one location.

2. What is Subtotal?

Answer – SUBTOTAL: totals/adds data in an array—that is, a collection of cells with column and/or row labels. You can choose arrays and then apply a statistical function (sum, average, max, min) to them using the Subtotals dialogue. To maximise efficiency, a function can be applied to up to three sets of arrays.

#### Electronic Spreadsheet Class 10 Questions and Answers

3. What is Goal Seek?

Answer – The word “goal seeking” refers to the act of determining your input value based on a previously determined output value. The method entails the use of a certain operator in a formula that may be calculated with computer software.
Example: Set Cell: This specifies the cell whose value will be changed to the desired value after the Goal Seek operation is completed.
For instance, Jack received a 25 out of 30 in English and a 22 out of 30 in Math. In order to calculate the score in IT, he needs to acquire an overall score of 85 percent. As a result, a goal has been established, and according to it, Jack will discover one unknown variable, IT marks.

#### Electronic Spreadsheet Class 10 Questions and Answers

4. What is Scenario?

Answer – Scenarios are a tool to test “what-if” questions. Each scenario is given a unique name and can be changed and presented independently. Only the content of the currently active scenario is printed when you print the spreadsheet. A scenario is essentially a set of saved cell values that you may use in your calculations. Using the Navigator or a dropdown list displayed beside the changing cells, you may simply switch between these sets.

#### Electronic Spreadsheet Class 10 Questions and Answers

5. What is Solver?

Answer – The Solver option in the Tools menu is essentially a more advanced version of Goal Seek. The Solver, on the other hand, deals with equations involving several unknown variables. It is meant to minimise or maximise the result based on a set of rules that you specify.

6. Differentiate between relative and absolute hyperlinks.

Answer – An absolute hyperlink will stop working only if the target is moved. A relative hyperlink will stop working only if the source and target locations change relative to each other.

Suppose, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break a link.

#### Electronic Spreadsheet Class 10 Questions and Answers

7. How can we rename a worksheet in Spreadsheet?

Answer – There are three ways you can rename a worksheet, and the only difference between them is the way in which you start the renaming process. You can do any of the following: Double-click on one of the existing worksheet names. Right-click on an existing worksheet name, then choose Rename from the resulting Context menu. Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.

8. How can we rename a worksheet in Spreadsheet?

Answer – You can rename a worksheet in three different ways, with the only difference being how you begin the renaming process. You can choose from the following options:
Select one of the existing worksheet names with a double-click.
Right-click an existing worksheet name, then select Rename from the Context menu that appears.
Select the worksheet you want to rename (by clicking on the worksheet tab), then choose Sheet from the Format menu. This brings up a submenu, from which you should choose Rename.

#### Electronic Spreadsheet Class 10 Questions and Answers

8. What is the advantage of sharing worksheet data?
Enhance the speed of data entering
To facilitate collaboration, make things easy.

9. Explain features and use of Record changes.
Answer – Calc offers a feature that allows you to keep track of what data was modified, when it was updated, who performed the modification, and which cell it happened in.
A coloured border appears around a cell where changes were made, with a dot in the upper left-hand corner. Other reviewers will easily notice which cells have been changed. A strong coloured bar indicates a deleted column or row.

#### Electronic Spreadsheet Class 10 Questions and Answers

10. What is the purpose of adding comments?
Answer – Comments from reviewers and authors can be added to explain their changes.

Answer – To add a remark to a modification, use the following syntax:
Make the necessary changes to the spreadsheet.
2. Select the cell that has been changed.
3. Select Edit > Changes > Comments from the drop-down menu. The following dialogue box appears. Calc’s automatically added comment displays in the title bar of this dialogue and is not editable.
4. Click OK after typing your own comment.

#### Electronic Spreadsheet Class 10 Questions and Answers

12. Explain features of accepting or rejecting changes.
Answer – The beauty of the recording changes mechanism becomes apparent when you receive a worksheet with changes. You can now go through each change like the original author and decide how to proceed. To get started, do the following:
1. Open the worksheet that has been changed.
2. Select Edit > Changes > Accept or Reject from the drop-down menu. The dialogue box displayed below will appear.
3. Calc goes through each modification one by one. As you go through the process, you can accept or reject each adjustment. If you wish to, you can also pick Accept all and reject all.

#### Electronic Spreadsheet Class 10 Questions and Answers

13. What are Macros? How can we record a Macro?
Answer – When the same set of operations must be completed repeatedly, such as formatting or applying a similar formula to a similar piece of data, macros can save time. It can be used to name and track a sequence of events.
To record a macro, follow these steps:
1. Input data
2. Before performing any operation, go to tools->macro->record macro.
3. Now repeat the motion you just did.
4. Select “Stop Recording” from the drop-down menu. Now save the macro by giving it a name.

Information Technology Class 10 Link

Employability Skills

h. Entrepreneurial Skills Class 10 Questions and Answers

j. Green Skills Class 10 Questions and Answers

Subject Specific Skills

d. Electronic Spreadsheet Class 10 Questions and Answers

### Reference Textbook

The above Electronic Spreadsheet Class 10 Questions and Answers was created using the NCERT Book and Study Material accessible on the CBSE ACADEMIC as a reference.

### Your valuable Feedback

Hi Students, Thank you for taking the time to reading Electronic Spreadsheet Class 10 Questions and Answers. Please take a few moments and leave your thoughts in the comment box below.

Disclaimer – 100% of the questions are taken from the CBSE textbook Electronic Spreadsheet Class 10 Questions and Answers, and our team has tried to collect all the correct Question and Answer from the textbook . If you found any suggestion or any error please contact us anuraganand2017@gmail.com.

### 1 thought on “Electronic Spreadsheet Class 10 Questions and Answers”

1. Write short note on copy back