IT-ASSIGNMENT - Electronic Spreadsheet
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.
5. 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.
9. What is the advantage of sharing worksheet data?
Answer –
Enhance the speed of data entering
To facilitate collaboration, make things easy.
10. 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.
11. What is the purpose of adding comments?
Answer – Comments from reviewers and authors can be added to
explain their changes.
12. How can we add comments to the changes made?
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.
13. 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.
14. 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.
