Electronic Spreadsheet -Notes 10 Questions and Answ-1

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.
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.
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.
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.
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. What is the advantage of sharing worksheet data?

Answer –
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.
10. What is the purpose of adding comments?

Answer – Comments from reviewers and authors can be added to explain
their changes.
11. How can we add comments to the changes made?

Answer – To add a remark to a modification, use the following syntax:
1. 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.
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.
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.

Electronic Spreadsheet -Notes 10 Questions and Answ-1

Uploaded by

Copyright:

Available Formats

Electronic Spreadsheet -Notes 10 Questions and Answ-1

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Electronic Spreadsheet -Notes 10 Questions and Answ-1

Uploaded by

Copyright:

Available Formats

Electronic Spreadsheet Class 10 Questions and Answers

1. What is Consolidating data?

Answer – The Data Consolidation tool summarises data from multiple

Answer – SUBTOTAL: totals/adds data in an array—that is, a collection

Electronic Spreadsheet Class 10 Questions and Answers

3. What is Goal Seek?

Answer – The word “goal seeking” refers to the act of determining

Answer – The Solver option in the Tools menu is essentially a more

6. Differentiate between relative and absolute hyperlinks.

Answer – An absolute hyperlink will stop working only if the target

Suppose, if you have two spreadsheets in the same folder linked to

7. How can we rename a worksheet in Spreadsheet?

8. What is the advantage of sharing worksheet data?

9. Explain features and use of Record changes.

Electronic Spreadsheet Class 10 Questions and Answers

10. What is the purpose of adding comments?

11. How can we add comments to the changes made?

12. Explain features of accepting or rejecting changes.

Electronic Spreadsheet Class 10 Questions and Answers

13. What are Macros? How can we record a Macro?

You might also like