cbse IT, UNIT 2: Electronic Spreadsheet ( Advance) / Class 10 / Solved Q-Ans IT (402),NFORMATION TECHNOLOGY-402,CLASS-X
UNIT 2: Electronic Spreadsheet ( Advance) / Class 10 / Solved Q-Ans IT (402),NFORMATION TECHNOLOGY-402,CLASS-X
UNIT 2: Electronic Spreadsheet ( Advance)
Book Exercise
SESSION 1: Analyse data using scenarios and goal seek
Q1 What do you mean by consolidate?
Ans: 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.
Q2 Define Scenarios.
Ans: Scenarios are a tool to test “what-if” questions. Use Tools > Scenarios to enter variable contents—scenarios—in the same cell. Each scenario is named, and can be edited and formatted separately, and chosen from a drop-down list in the Navigator and the title bar of the scenario. When you print the spreadsheet, only the contents of the currently active scenario are printed.
Q3 Explain Multiple Operations.
Ans: Multiple Operations is a planning tool for “what if” questions. Unlike a scenario, the Multiple Operations tool does not present the alternate versions in the same cells or with a drop-down list. Instead, the Multiple Operations tool creates a formula array: a separate set of cells that give all the alternative results for the formulas used. Although the tool is not listed among the functions, it is really a function that acts on other functions, allowing you to calculate different results without having to enter and run them separately.
Q4 Write the use of Goal Seek.
Ans: Goal Seek reverses the usual order for a formula. Usually, you run a formula to get the result when certain arguments are entered. By contrast, with Goal Seek, you work with a completed formula to see what values you need in an argument to get the results that you want.
SESSION 2: Link Data and Spreadsheets
Q1 Write steps to insert sheet.
Ans: Select the plus icon at the bottom of the screen.
Or, select Home > Insert > Insert Sheet
Q2 Write the steps to rename a worksheet.
Ans: There are three way to rename a woksheet:
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.
Q3 What is cell reference?
Ans: 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.
Q4 Define hyperlink.
Ans: In computing, a hyperlink, or simply a link, is a reference to data that the user can follow by clicking or tapping. A hyperlink points to a whole document or to a specific element within a document. Hypertext is text with hyperlinks. The text that is linked from is called anchor text.
Q 5 What are the two ways of referencing cells in other worksheets?
Ans:There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
Q6 Differentiate between relative and absolute reference.
Ans:
Relative reference
Absolute Reference
Relative references change when a formula is copied to another cell.
A relative link will stop working only if the start and target locations change relative to each other.
Absolute references, on the other hand, remain constant no matter where they are copied.
An absolute link will stop working only if the target is moved.
Q7 List the procedure involved in Linking HTML Tables to Calc Worksheet .
Ans: Using the External Data dialog
Choose Insert > Link to External Data. On the External Data dialog, type the URL of the source document or click the [...] button to open a file selection dialog. Press Enter to get Calc to load the list of available tables.
Or
Using the External Data dialog
Open the Calc worksheet where the external data is to be inserted. This is the target worksheet.
Select the cell where the upper left-hand cell of the external data is to be inserted.
Choose Insert -> Link to External Data.
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.
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.
Click OK to close this dialog and insert the linked data
Q8 Fill up the blanks
a. At the bottom of each worksheet window is a small tab that indicates the _name_ of the worksheets in the workbook.
b. 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.
SESSION 3: Share and review a spreadsheet
Fill in the blanks:
Share Workbook option is available in changes group under the Review tab.
Shared workbooks don’t allow merging cells, conditional formatting, or inserting pictures/graphs/etc.
Spreadsheet software allows the user to share the workbook and place it in the network location where several users can access it simultaneously
Spreadsheet software allows the user to share the workbook and place it in the __network _ location where several users can access.
Spreadsheet software can find the changes by __comparing _ Sheets.
QUESTIONS:
What is the purpose of adding comments?
Ans: Calc automatically adds to any recorded change a comment describing what was changed (for example, Cell B4 changed from ‘9’ to ‘4’). Reviewers and authors can add their comments to explain their changes.
How can we add comments to the changes made?
Ans: To add a comment to a change:
1.Make the change to the spreadsheet.
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.
3. State True/ False
a. Original author of the Worksheet can accept or reject changes made by other users. True
SESSION 4: Create and use Macros in spreadsheet
Questions:
Q1 What is Macro ?
Ans: A macro is like an algorithm or a set of actions that we can use or run multiple times. A macro helps in automating or repeating tasks by recording or storing our input sequences like mouse strokes or keyboard presses. Once this input is stored, it makes up a macro which is open to any possible changes.
Q2 Write the steps to enter macro in speadsheet.
Ans: Running the macro
Use Tools > Macros > Run Macro to open the Macro Selector dialog. Select the newly created macro and click Run. Select your macro and click Run. There are other methods to run a macro
Q3 Write steps for Writing formula/ equations in MS Word.
Ans: Writing equations in the MS –word while typing the equations or mathematical expression can be easily done using Equation option on Symbols Group under Insert Tab.
Q4 How can we record a Macro?
Ans: Use Tools > Macros > Record Macro to start the macro recorder. The Record Macro dialog is displayed with a stop recording button.
Fill up the blank
a. Macros are useful to __repeat ___ a task the same way over and over again.
UNIT 2: Electronic Spreadsheet ( Advance)
Book Exercise
SESSION 1: Analyse data using scenarios and goal seek
Q1 What do you mean by consolidate?
Ans: 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.
Q2 Define Scenarios.
Ans: Scenarios are a tool to test “what-if” questions. Use Tools > Scenarios to enter variable contents—scenarios—in the same cell. Each scenario is named, and can be edited and formatted separately, and chosen from a drop-down list in the Navigator and the title bar of the scenario. When you print the spreadsheet, only the contents of the currently active scenario are printed.
Q3 Explain Multiple Operations.
Ans: Multiple Operations is a planning tool for “what if” questions. Unlike a scenario, the Multiple Operations tool does not present the alternate versions in the same cells or with a drop-down list. Instead, the Multiple Operations tool creates a formula array: a separate set of cells that give all the alternative results for the formulas used. Although the tool is not listed among the functions, it is really a function that acts on other functions, allowing you to calculate different results without having to enter and run them separately.
Q4 Write the use of Goal Seek.
Ans: Goal Seek reverses the usual order for a formula. Usually, you run a formula to get the result when certain arguments are entered. By contrast, with Goal Seek, you work with a completed formula to see what values you need in an argument to get the results that you want.
SESSION 2: Link Data and Spreadsheets
Q1 Write steps to insert sheet.
Ans: Select the plus icon at the bottom of the screen.
Or, select Home > Insert > Insert Sheet
Q2 Write the steps to rename a worksheet.
Ans: There are three way to rename a woksheet:
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.
Q3 What is cell reference?
Ans: 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.
Q4 Define hyperlink.
Ans: In computing, a hyperlink, or simply a link, is a reference to data that the user can follow by clicking or tapping. A hyperlink points to a whole document or to a specific element within a document. Hypertext is text with hyperlinks. The text that is linked from is called anchor text.
Q 5 What are the two ways of referencing cells in other worksheets?
Ans:There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
Q6 Differentiate between relative and absolute reference.
Ans:
Relative reference | Absolute Reference |
Relative references change when a formula is copied to another cell. A relative link will stop working only if the start and target locations change relative to each other. | Absolute references, on the other hand, remain constant no matter where they are copied. An absolute link will stop working only if the target is moved. |
Q7 List the procedure involved in Linking HTML Tables to Calc Worksheet .
Ans: Using the External Data dialog
Choose Insert > Link to External Data. On the External Data dialog, type the URL of the source document or click the [...] button to open a file selection dialog. Press Enter to get Calc to load the list of available tables.
Or
Using the External Data dialog
Open the Calc worksheet where the external data is to be inserted. This is the target worksheet.
Select the cell where the upper left-hand cell of the external data is to be inserted.
Choose Insert -> Link to External Data.
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.
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.
Click OK to close this dialog and insert the linked data
Q8 Fill up the blanks
a. At the bottom of each worksheet window is a small tab that indicates the _name_ of the worksheets in the workbook.
b. 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.
SESSION 3: Share and review a spreadsheet
Fill in the blanks:
Share Workbook option is available in changes group under the Review tab.
Shared workbooks don’t allow merging cells, conditional formatting, or inserting pictures/graphs/etc.
Spreadsheet software allows the user to share the workbook and place it in the network location where several users can access it simultaneously
Spreadsheet software allows the user to share the workbook and place it in the __network _ location where several users can access.
Spreadsheet software can find the changes by __comparing _ Sheets.
QUESTIONS:
What is the purpose of adding comments?
Ans: Calc automatically adds to any recorded change a comment describing what was changed (for example, Cell B4 changed from ‘9’ to ‘4’). Reviewers and authors can add their comments to explain their changes.
How can we add comments to the changes made?
Ans: To add a comment to a change:
1.Make the change to the spreadsheet.
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.
3. State True/ False
a. Original author of the Worksheet can accept or reject changes made by other users. True
SESSION 4: Create and use Macros in spreadsheet
Questions:
Q1 What is Macro ?
Ans: A macro is like an algorithm or a set of actions that we can use or run multiple times. A macro helps in automating or repeating tasks by recording or storing our input sequences like mouse strokes or keyboard presses. Once this input is stored, it makes up a macro which is open to any possible changes.
Q2 Write the steps to enter macro in speadsheet.
Ans: Running the macro
Use Tools > Macros > Run Macro to open the Macro Selector dialog. Select the newly created macro and click Run. Select your macro and click Run. There are other methods to run a macro
Q3 Write steps for Writing formula/ equations in MS Word.
Ans: Writing equations in the MS –word while typing the equations or mathematical expression can be easily done using Equation option on Symbols Group under Insert Tab.
Q4 How can we record a Macro?
Ans: Use Tools > Macros > Record Macro to start the macro recorder. The Record Macro dialog is displayed with a stop recording button.
Fill up the blank
a. Macros are useful to __repeat ___ a task the same way over and over again.
Comments
Post a Comment