NCERT Solutions Class 10 Computers Electronic Spreadsheet Advanced

Question. A __ colored border, appears around a cell where changes were made in shared worksheet.
a. Blue
b. Yellow
c. Green
d. Red
Answer : D

Question. In Calc link to external data is present in _____________ menu.
a. File
b. Edit
c. Insert
d. View
Answer : C

Question. Several users can access shared workbook simultaneously.(T/F)
a. True
b. False
Answer : A

Question. Record Changes feature of Calc help
a. Authors and other reviewers to know which cells were edited.
b. to record the screen
c. to make changes permanent
d. None of the above
Answer : A

Question. Macros are especially useful to ___________ a task.
a. do
b. repeat
c. simplify
d. complicate
Answer : B

Question. Anil is the author of shared worksheet so he has the right to accept or reject changes made by the reviewers.(T/F)
a. True
b. False
Answer : A

Question. Spreadsheet software allows the user to share the workbook.(T/F)
a. True
b. False
Answer : A

Question. Which of the following buttons are present on “Resolve Conflict” dialog box which appear during saving shared worksheet.
a. Keep Mine
b. Keep Other
c. Keep All Mine
d. All of the above
Answer : D

Question. A _____________ is a saved sequence of commands or keystrokes that are stored for later use
a. Solver
b. Autosum
c. Consolidate
d. Macro
Answer : D

Question. In Calc “Share Document” dialog box can open by clicking on ______________ menu.
a. File
b. Edit
c. View
d. Tool
Answer : D

Question. A deleted column or row in shared worksheet is marked by a ______________ colored bar.
a. Light
b. Line
c. Solid
d. Heavy
Answer : D

Question. Share document option available in _____ menu
a. Tools
b. View
c. Edit
d. File
Answer : A

Question. Any cells modified by the other user in shared worksheet are shown with a ________ border.
a. Blue
b. Green
c. Red
d. Yellow
Answer : C

Question. Edited worksheet can be compared with the original worksheet by selecting.
a. File –> Compare Document
b. Edit –> Compare Document
c. View –> Compare Document
d. Tools –> Compare Document
Answer : B

Question. Use ___________ Macro to start the macro recorder.
a. Tools > Macros > Record Macro
b. Tools > Record > Record Macro
c. Data > Macros > Record
d. None of the above
Answer : A

Question. Which feature of Calc help to see the changes made in the shared worksheet?
a. Record Changes
b. Solver
c. Subtotal
d. None of the above
Answer : A

Question. We can link a text in spreadsheet to any Web URL.(T/F)
a. True
b. False
Answer : A

Question. After sharing the worksheet, the word ___________ is then shown on the title bar after the worksheet’s title
a. Sharing
b. Shared
c. Sharing Sheet
d. None of the above
Answer : B

Question. Which of the following changes are not recorded in shared worksheet?
a. Changes any number
b. Changes any text
c. Cell Formatting
d. None of the above
Answer : C

Question. We can not unshare a spreadsheet, once it is shared.(T/F)
a. True
b. False
Answer : B

Question. Hyperlink dialog box in Calc shows ________ options on left hand side.
a. Internet
b. Document
c. New Document
d. All of the above
Answer : D

Question. “Accept or Reject Changes” dialog box (for shared worksheet) can be opened by clicking on
a. File > Changes > Accept or Reject.
b. Edit > Changes > Accept or Reject.
c. View > Changes > Accept or Reject.
d. None of the above
Answer : B

Question. Suman and her friends wants to work together in a spreadsheet. They can do so by
a. Sharing Workbook
b. Linking Workbook
c. Both of the above
d. None of the above
Answer : A

Question. After adding comment to a changed cell of shared worksheet, we can see it by hovering the mouse pointer over the cell(T/F)
a. True
b. False
Answer : A

Question. Function names in Calc are not case sensitive.(T/F)
a. True
b. False
Answer : A

Question. To activate the record changes feature in shared worksheet ___________
a. Select File > Changes > Record from the menu bar.
b. Select Edit > Changes > Record from the menu bar.
c. Select View > Changes > Record from the menu bar.
d. Select Insert > Changes > Record from the menu bar.
Answer : B

Question. Worksheets can be merged from ____________________ menu.
a. Edit
b. File
c. View
d. Tools
Answer : A

Question. Click _____________ to stop the macro recorder
a. Close Recording
b. End Recording
c. Stop Recording
d. None of the above
Answer : C

Question. To edit macro, go to
a. Tools –> Macros — > Edit Macros
b. Edit –> Macros — > Edit Macros
c. View –> Macros — > Edit Macros
d. None of the above
Answer : A

Question. When sharing worksheets authors may forget to record the changes they make. Calc can find the changes by __________ worksheets
a. duplicating
b. comparing
c. checking
d. None of the above
Answer : B

Question. The following features are known to be disabled in a shared spreadsheet
a. Edit > Changes, except for Merge Document
b. Insert > Names
c. Insert > Comment
d. All of the above
Answer : D

Question. To register a data source in OpenOffice.org
a. Choose Tools -> Options -> OpenOffice.org Base -> Databases
b. Choose Tools -> Options -> Databases-> OpenOffice.org Base
c. Choose Tools -> Databases-> Options -> OpenOffice.org Base
d. None of the above
Answer : A

Question. When a document is created and saved, it automatically contains a library named ___
a. Module Library
b. Macro Library
c. Standard
d. None of the above
Answer : C

Question. We can add a comment regarding any changes made in shared worksheet by
a. Edit > Changes > Comments
b. File > Changes > Comments
c. View > Changes > Comments
d. None of the above
Answer : A

Fill in the blanks 

1. At the bottom of each worksheet window is a small tab that indicates the name of the worksheets in the workbook.

2. A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.

3. Spreadsheet software allows the user to share the workbook and place it in the Network location where several users can access.

4. Spreadsheet software can find the changes by Comparing Sheets.

5. Macros are useful to repeat a task the same way over and over again.

Questions And Answers

Question. What is the purpose of adding comments?
Answer : Comments are mostly used in shared Calc sheet which is used to explain the changes made in
the sheet to the author of the sheet.

Question. 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.

Question. What are the two ways of referencing cells in other worksheets?
Answer : Two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse.

Question. Differentiate between Relative and absolute hyperlinks.
Answer : Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, 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.

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

Question. 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.

Question. How can we record a Macro?
Answer : Steps to record macro are as follows
a. Use Tools > Macros > Record Macro to start the macro recorder. The Record Macro dialog is displayed with a stop recording button.
b. Perform the actions you want to be recorded in the document.
c. Click Stop Recording.
d. The Macro dialog appears, in which you can save and run the macro.

Question. 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.

Question. 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.

Question. 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.

Question. List the procedure involved in Linking HTML Tables to Calc Worksheet.
Answer : You can insert tables from HTML documents, and data located within named ranges from an OpenOffice.org Calc or Microsoft Excel spreadsheet, into a Calc spreadsheet.
We can do this in two ways: using the External Data dialog or using the Navigator.
Using the External Data dialog
a. Open the Calc worksheet where the external data is to be inserted. This is the target worksheet.
b. Select the cell where the external data is to be inserted.
c. Choose Insert -> Link to External Data.
d. On the External Data dialog, type the URL of the source worksheet or click the […] button to open a file selection dialog. Press Enter to get Calc to load the list of available tables.
e. In the Available tables/range list, select the named ranges or tables you want to insert. You can also specify that the ranges or tables are updated every (number of) seconds.
f. Click OK to close this dialog and insert the linked data.

Question. 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.

Question. 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.

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

Question. 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.

Question. 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.

Question. 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.

Question. How can we rename a worksheet?
Answer : There are three ways you can rename a worksheet
a. Double-click on one of the existing worksheet names.
b. Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.
c. 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.

Question. 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.

Question. How can we add comments to the changes made?
Answer : Comments can be added as follows:
1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. in the title bar of this dialog and cannot be edited.
4. Type your own comment and click OK.
After you have added a comment to a changed cell, you can see it by hovering the mouse pointer over the cell.

Question. What are Macros?
Answer : A macro is a saved sequence of commands or keystrokes that are stored for later use. Macros are especially useful to repeat a task the same way over and over again.

Question. 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.

Question. 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.

Question. Explain how to create a reference to (a) Other worksheets within the same workbook (b) worksheet of another workbook with keyboard and mouse.
                                             OR
What are the two ways of referencing cells in other worksheets?
Answer : a) Other worksheets within the same workbook
1. Click on the = icon next to the formula bar.
2. Now, click on the sheet tab for the sheet containing the cell to be referenced. (eg. Sheet2)
3. Click on cell F3 (where the balance is) in sheet2. The phrase ‘Sheet2’.F3 should appear in the formula bar. With the help of a keyboard, you have to type down the above formula in the formula bar.
b) Worksheet of another workbook
Mouse:
1. Click the = icon next to the formula bar.
2. Switch to the other spreadsheet (the process to do this will vary depending on which operating system you are using).
3. Select the sheet (Savings account or any) and then the reference cell (F3).
Keyboard:
Creating The Reference With The Keyboard

Typing the reference is simple once you know the format the reference takes. Thereference has three parts to it:
• Path and file name
• Sheet name
• Cell
Looking at the figure above, you can see the general format for the reference is =’file:///Path &File Name’#$SheetName.cell name 

Question. 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.

Question. What are Macros? How can we record a Macro?
Answer : Macros help in saving time in cases when the same set of tasks are to be done repeatedly like formatting or applying a similar formula in a similar range of data. It can be used to name and record a set of actions.
Procedure to record a macro:
1. input data
2. before you do any action click on tools->macro->record macro
3. now perform the action you want to repeat
4. click on stop recording. now save macro by giving name to macro

Question. Explain features and use of Record changes.
Answer : Calc has the feature to track what data was changed when the change was made, who made the change, and in which cell the change has occurred.
A colored border, with a dot in the upper left-hand corner, appears around a cell where changes were made. Other reviewers then quickly know which cells were edited. A deleted column or row is marked by a heavy-colored bar.
Example: If you are the sponsor of a youth baseball team. The coach has submitted a budget to you for the season and you need to edit the costs and return them to her. You are concerned that if you just make the changes, then the coach won’t see the changes you made. You decide to use Calc with the record changes feature turned on so that the coach can easily see the changes you have made.

Question. What is the purpose of adding comments?
Answer : Reviewers and authors can add their comments to explain their changes.

Question. What is the advantage of sharing worksheet data?
Answer : • Speed up data entry
• Make things easier for collaboration purposes.

Question. How can we add comments to the changes made?
Answer : To add a comment to a change:
1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. Choose Edit > Changes > Comments. The dialog shown below appears. The automatically-added comment provided by Calc appears in the title bar of this dialog and cannot be edited. 4. Type your own comment and click OK.

Question. Explain the feature of accepting or reject changes.
Answer : When you receive a worksheet back with changes, the beauty of the recording changes system becomes evident. Now, as the original author, you can step through each change and decide how to proceed. To begin this process:
1. Open the edited worksheet.
2. Select Edit > Changes > Accept or Reject. The dialog shown below opens.
3. Calc steps through the changes one at a time. You can choose to accept or reject each change as you go through it. or you can also select Accept all and reject all if you want to do so.

Question. Define and Explain the usage of the following terms with Reference to OpenOffice Calc.
(a) Consolidating data (b) Subtotals (c) Goal seek (d) Scenario (e) Solver 
Answer : (a) Consolidating data
Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet.
                                               OR
The Data Consolidation function takes data from a series of worksheets or workbooks and summarizes it into a single worksheet that you can update easily. Consolidate provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data. During consolidation, the contents of cells from several sheets can be combined in one place.
(b) Subtotals
SUBTOTAL: totals/add data arranged in an array—that is, a group of cells with labels for columns and/or rows. Using the Subtotals dialog, you can select arrays, and then choose a statistical function (sum, average, max, min) to apply to them. . For efficiency, one must choose up to three groups of arrays to which to apply a function.
( c) Goal seek
Using the Goal Seek option under the Tools menu, you can discover what values will produce the result that you want.
                                                OR
Goal seeking is a general term used to describe the process involved in figuring out your input value based on an already known output value. The process involves using a specific operator in a formula, which can be calculated using computer software.
Example: Set Cell: It specifies the cell whose value will be changed to the desired value after the result of the Goal Seek operation.
Example: Jack scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. So here goal is set and according to it Jack will find one unknown variable IT marks.
(d) Scenario
Scenarios are a tool to test “what-if” questions. Each scenario is named, and can be edited and formatted separately. When you print the spreadsheet, only the content of the currently active scenario is printed. A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the Navigator or a drop-down list which can be shown beside the changing cells.
For example, if you wanted to calculate the effect of different interest rates on an investment, you could add a scenario for each interest rate, and quickly view the results. Formulas that rely on the values changed by your scenario are updated when the scenario is opened. If all your sources of income used scenarios, you could efficiently build a complex model of your possible income.
(e) Solver
The solver option under the Tools menu amounts to a more elaborate form of Goal Seek. The difference is that the Solver deals with equations with multiple unknown variables. It is specifically designed to minimize or maximize the result according to a set of rules that you define.
Each of these rules sets up whether an argument in the formula should be greater than, lesser than, or equal to the value you enter.
For example, you can set the constraint that one of the variables or cells must not be bigger than another variable, or no bigger than a given value. You can also define the constraint that one or more variables must be integers (values without decimals), or binary values (where only 0 and 1 are allowed). Once you have finished setting up the rules, you can adjust the argument and the results by clicking the Solve button.