cbse class 10 IT Unit – 2 Electronic Spreadsheet Advanced Class 10 study notes
Unit – 2 Electronic Spreadsheet Advanced Class 10
Q1. What is Data Consolidation?
Ans. Data Consolidation allows you to gather your data from separate worksheets into a master worksheet.
Q2. Consolidate option available in ___________ menu.
Ans. Data
Q3. Write two functions which are available in function list of Consolidate data dialog box.
Ans. Two functions are : (Write any two)
a. Sum
b. Max
c. Min
d. Average
Q4. What do you mean by range of cells?
Ans. Collection of two or more cells in Excel is called range of cells. for example A1 : A5
Q5. How can you give name to a range of cells?
name to a range of cells as follows :
Select the range of cells.
Click on Data menu —-> Define range
Type the name & click OK
Q6. What is Subtotal in Spreadsheet?
Ans. SUBTOTAL, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows.
Q7. Subtotal option available in ___________ menu.
Ans. Data
Q8. ___________ are a tool to test “what-if” questions.
Ans. Scenario
Q9. Write the steps to create Scenario.
Ans. To create scenario :
a. Select the cells that contain the values that will change between scenarios.
b. Choose Tools > Scenarios
c. On the Create Scenario dialog , enter a name for the new scenario.
d. Click OK to close the dialog.
Q10. Define the term Goal Seek in reference to Spreadsheet.
Ans. Goal Seek option available under Tools menu, we can find what values will produce the result that we want.
Q11. Match the following
Option | Menu |
Subtotal | Tool Menu |
Goal Seek | Data Menu |
Scenario | Data Menu |
Consolidate | Tool Menu |
Solver | Tool Menu |
Ans.
Option | Menu |
Subtotal | Data Menu |
Goal Seek | Tool Menu |
Scenario | Tool Menu |
Consolidate | Data Menu |
Solver | Tool Menu |
Q12. What is Solver in Spreadsheet?
Ans. Solver option under Tools menu is a more elaborate form of Goal Seek. The difference is that the Solver deals with equations with multiple unknown variables.
Q13. How can you insert a new sheet?
Ans. We can insert a new sheet by
a. select the sheet that will be next to the new sheet.
b. Select Insert > Sheet from the menu bar.
Q14. How can you rename a sheet?
Ans. There are three ways to 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 and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.
Q15. How can you reference the ‘F4’ cell of a sheet named “Class X”?
Ans. =’Class X’.F4
Q16. What is the difference between Relative and Absolute hyperlink?
Ans. 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.
Q17. In Spreadsheet Hyperlink icon is present on ___________________ toolbar.
Ans. Standard
Q18. In Spreadsheet Hyperlink option is present in ___________________ menu.
Ans. Insert
Q19. Write the steps to share spreadsheet with others.
Ans. Spreadsheet can be shared by :
a. Open the sheet to be shared
b. Tools > Share Document
c. A dialog box opens.
d. To enable sharing, select the box at the top of the dialog, and then click OK
Q20. Write the steps to add comment to a shared spreadsheet.
Ans. Steps to add comment to a shared spreadsheet.
a. Make the change to the spreadsheet.
b. Select the cell with the change.
c. Choose Edit > Changes > Comments
d. Type your own comment and click OK.
Q21. How can you edit the entered comment?
Ans. We can edit the entered comment by :
1 Select the cell with the comment that you want to edit.
2. Select Edit > Changes > Comments.
3. Edit the comment and click OK.
Q22. Intersection of row and column is called ____________
Ans. Cell
Q23. Formula in spreadsheet begin with _________ sign.
Ans. =
Q24. Parth scored 130 in Term1 and 140 in Term2 (out of 150 ). How much will he score in Term3 so that the aggregate becomes 80%. Which option will help him to find?
Ans. Goal Seek
Q25. __________________ option under Tools menu is a more elaborate form of Goal Seek.
Ans. Solver
Q26. _______________ are predefined formulas in Calc.
Ans. Functions
Q27. ___________ is the top most bar of Calc Window.
Ans. Title bar
Q28. Shortcut to open Function Wizard is __________
Ans. Ctrl + F2
Q29. Suman wants to share her worksheet with others but she wants to protect her worksheet so that no one can make unnecessary changes. Help her to find such option.
Ans. Edit –> Protect Document
Q30. A cell in the spreadsheet with dark boundary is called ______
Ans. Active Cell
Q31. Write the steps to open consolidate dialog box in OpenOffice Calc.
Ans. Steps to open consolidate dialog box are:
Click on Data Menu.
Click on Consolidate.
Q32. Write any four statistical functions available in Consolidate dialog box.
Ans. Four statistical functions available in Consolidate dialog box are :
Sum
Max
Min
Average
Q33. Which command can be used to switch the mode for a worksheet from unshared to shared and vice-versa?
Ans. Tools > Share Document
Q34. How can we use a shared worksheet in unshared mode?
Ans. We can use a shared worksheet in unshared mode by saving the shared worksheet using another name or path. This creates a copy of the spreadsheet that is not shared.
Q35. What is a Record Changes feature in Open Office Calc?
Ans. Record Changes feature is used to track what data was changed, when the change was made, who made the change and in which cell the change has occurred.
Q36. Write the steps to turn ON the “Record Changes” feature in Calc?
Ans. Steps are:
Open the Shared Spreadsheet.
Select Edit > Changes > Record from the menu bar.
Q37. 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.
Q38. What is the use of Hyperlink in Calc?
Ans. Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites.
Q39. How can we rename a worksheet?
Ans. 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.
Q40. What are the two ways of referencing cells in other worksheets?
Ans. Two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse.
Q41. Differentiate between Relative and absolute hyperlinks.
Ans. 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.
Q42. List the procedure involved in Linking HTML Tables to Calc Worksheet.
Ans. 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.
Q43. What is the purpose of adding comments?
Ans. 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.
Q44. How can we add comments to the changes made?
Ans. Comments can be added as follows:
1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. Choose Edit > Changes > Comments. 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.
After you have added a comment to a changed cell, you can see it by hovering the mouse pointer over the cell.
Q45. What are Macros?
Ans. 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.
Q46. How can we record a Macro?
Ans. 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.
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.
Multiple Choice Questions:
Q1. _________ allows you to gather data from different worksheets into a master worksheet.
a. Data Consolidation
b. Goal Seek
c. Solver
d. Total data
Ans. a. Data Consolidation
Q2. Consolidate option is available under _________ menu.
a. View
b. Tool
c. Insert
d. Data
Ans. d. Data
Q3. Data can be consolidated from two sheets only.(T/F)
a. True
b. False
Ans. b. False
Q4. We can consolidate data by ________
a. Row Label
b. Column Label
c. Both of the above
d. None of the above
Ans. c. Both of the above
Q5. Which of the following functions are available in consolidate window?
a. Max
b. Min
c. Count
d. All of the above
Ans. d. All of the above
Q6. In which option we have to specify the target range(Where we want the result to be displayed)
a. Source data range
b. Copy results to
c. Need result at
d. target range
Ans. b. Copy results to
Q7. If you select ________ then any values modified in the source range are automatically updated in the target range.
a. Link to source data
b. Link to sheet data
c. Link to original data
d. Link to source range
Ans. a. Link to source data
Q8. Which option is used to name a range of cells?
a. Range name
b. Cell Range
c. Define Range
d. Select Range
Ans. c. Define Range
Q9. Define range option is available under ________ menu.
a. Insert
b. View
c. Developer
d. Data
Ans. d. Data
Q10. The text in the row label or column label must be identical, otherwise, new row or column will be inserted.(T/F)
a. True
b. False
Ans. a. True
Q11. SUBTOTALS _________ data arranged in an array (that is, a group of cells )
a. Add
b. Average
c. Find
d. Clear
Ans. a. Add
Q12. Subtotals is available in __________ menu.
a. Tools
b. Format
c. Insert
d. Data
Ans. d. Data
Q13. In Subtotals we can select up to _______ groups of arrays.
a. 3
b. 2
c. 4
d. Infinite
Ans. a. 3
Q14. Identify the correct sequence
a. First open subtotals window and then select the data where we need to apply subtotals.
b. First Select data and then open subtotals window.
c. Both of the above are correct
d. None of the above
Ans. b. First Select data and then open subtotals window.
Q15. Scenarios are tool to test _________ questions.
a. if else
b. what else
c. what if
d. if
Ans. c. what if
Q16. Each scenario has a name.(T/F)
a. True
b. False
Ans. a. True
Q17. Scenario option is available in ___________________ menu.
a. Data
b. Tools
c. Insert
d. Windows
Ans. b. Tools
Q18. When we print a spreadsheet, only content of active scenario is printed.(T/F)
a. True
b. False
Ans. a. True
Q19. We can shift from one scenario to another by _____________
a. Navigator
b. Find and Replace
c. Data Source
d. None of the above
Ans. a. Navigator
Q20. We can create only 3 scenario for a given range of cells.(T/F)
a. True
b. False
Ans. b. False
Q21. Which option is suitable to calculate the effect of different interest rates on an investment.
a. Scenario
b. Subtotal
c. Consolidate
d. None of the above
Ans. a. Scenario
Q22. Default name of first scenario created in Sheet1 of Calc is ________
a. Sheet1_Scenario1
b. Sheet1_Scenario_1
c. Sheet_1_Scenario1
d. Sheet_1_Scenario_1
Ans. b. Sheet1_Scenario_1
Q23. To select random multiple cell hold down ________ key as you click on each cell.
a. Alt
b. Shift
c. Ctrl
d. All of the above
Ans. c. Ctrl
Q24. Goal Seek Option available in __ menu.
a. Tools
b. Format
c. Data
d. Insert
Ans. a. Tools
Q25. Comment in Create Scenario dialog box is Optional(T/F)
a. True
b. False
Ans. a. True
Q26. We can give different colors to different scenario?(T/F)
a. True
b. False
Ans. a. True
Q27. ____________ is more elaborate form of Goal Seek.
a. Scenario
b. Subtotal
c. Solver
d. All of the above
Ans. c. Solver
Q28. Solver option is available under _________ menu
a. Tools
b. Format
c. Edit
d. Insert
Ans. a. Tools
Q29. We can link one worksheet to another worksheet.(T/F)
a. True
b. False
Ans. a. True
Q30. We can not add/insert more sheets in a spreadsheet.(T/F)
a. True
b. False
Ans. b. False
Q31. When you open a new spreadsheet, by default it has sheet named ______________.
a. Sheet1
b. Sheet_1
c. Sheet 1
d. None of the above
Ans. a. Sheet1
Q32. By default sheets tab are present at the _____________ of the spreadsheet.
a. Top
b. Bottom
c. Both of the above
d. None of the above
Ans. b. Bottom
Q33. We can insert the new sheet in Calc by clicking on __ menu.
a. Format
b. Edit
c. Insert
d. Tool
Ans. c. Insert
Q34. Which of the following elements are present in “Insert Sheet” dialog box.
a. After Current Sheet
b. Before Current Sheet
c. No. of Sheets
d. All of the above
Ans. d. All of the above
Q35. By default ________________ sheets are present in Spreadsheet.
a. 1
b. 2
c. 3
d. 4
Ans. c. 3
Q36. We can rename a new sheet in Calc.
a. After inserting a new sheet
b. While inserting a new sheet
c. Both of the above
d. None of the above
Ans. c. Both of the above
Q 37. We can rename an existing sheet in Calc by
a. Double click on one of the existing sheet
b. Right click on existing sheet and then choose rename
c. Both of the above
d. None of the above
Ans. c. Both of the above
Q 38. Formula to refer a cell A3 in sheet named S1 is
a. =S1A3
b. =S1.A3
c. =”S1″.A3
d. None of the above
Ans. b. =S1.A3
Q 39. Hyperlink in Calc can be used
a. to jump from one sheet to another sheet.
b. to jump from one sheet to website
c. to jump from one section to another section of same sheet
d. All of the above
Ans. d. All of the above
Q 40. Hyperlink in Calc can be either relative or absolute.(T/F)
a. True
b. False
Ans. a. True
Q 41. Absolute link will stop working only if the target is moved(T/F)
a. True
b. False
Ans. a. True
Q 42. A relative link will stop working only if the target is moved.(T/F)
a. True
b. False
Ans. b. False
Q 43. 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 _____________
a. not work
b. work
c. may work
d. None of the above
Ans. b. work
Q 44. Hyperlink option is available in ______ menu.
a. File
b. Edit
c. Format
d. Insert
Ans. d. Insert
Q 45. Hyperlink icon is present on _________________
a. Format Toolbar
b. Standard Toolbar
c. Menu Bar
d. None of the Above
Ans. b. Standard Toolbar
Q 46. Hyperlink dialog box shows ___________ types of hyperlinks on left hand side.
a. 1
b. 2
c. 3
d. 4
Ans. d. 4
Q 47. We can link a text in spreadsheet to any Web URL.(T/F)
a. True
b. False
Ans. a. True
Q 48. Hyperlink dialog box in Calc shows ________ options on left hand side.
a. Internet
b. Document
c. New Document
d. All of the above
Ans. d. All of the above
Q 49. In Calc link to external data is present in _____________ menu.
a. File
b. Edit
c. Insert
d. View
Ans. c. Insert
Q 50. 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
Ans. a. Choose Tools -> Options -> OpenOffice.org Base -> Databases
Q 51. Spreadsheet software allows the user to share the workbook.(T/F)
a. True
b. False
Ans. a. True
Q 52. Several users can access shared workbook simultaneously.(T/F)
a. True
b. False
Ans. a. True
Q 53. 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
Ans. a. Sharing Workbook
Q 54. In Calc “Share Document” dialog box can open by clicking on ______________ menu.
a. File
b. Edit
c. View
d. Tool
Ans. d. Tool
Q 55. We can notunshare a spreadsheet, once it is shared.(T/F)
a. True
b. False
Ans. b. False
Q 56. 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
Ans. b. Shared
Q 57. Share document option available in _____ menu
a. Tools
b. View
c. Edit
d. File
Ans. a. Tools
Q 58. 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
Ans. d. All of the above
Q 59. 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
Ans. d. All of the above
Q 60. Any cells modified by the other user in shared worksheet are shown with a ________ border.
a. Blue
b. Green
c. Red
d. Yellow
Ans. c. Red
Q 61. 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
Ans. a. Record Changes
Q 62. 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.
Ans. b. Select Edit > Changes > Record from the menu bar.
Q 63. A __ colored border, appears around a cell where changes were made in shared worksheet.
a. Blue
b. Yellow
c. Green
d. Red
Ans. d. Red
Q 64. A deleted column or row in shared worksheet is marked by a ______________ colored bar.
a. Light
b. Line
c. Solid
d. Heavy
Ans. d. Heavy
Q 65. 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
Ans. a. Authors and other reviewers to know which cells were edited.
Q 66. 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
Ans. c. Cell Formatting
Q 67. 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
Ans. a. Edit > Changes > Comments
Q 68. 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
Ans. a. True
Q 69. 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
Ans. a. True
Q 70. “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
Ans. b. Edit > Changes > Accept or Reject.
Q 71. Worksheets can be merged from ____________________ menu.
a. Edit
b. File
c. View
d. Tools
Ans. a. Edit
Q 72. 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
Ans. b. comparing
Q 73. 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
Ans. b. Edit –> Compare Document
Q 74. A _____________ is a saved sequence of commands or keystrokes that are stored for later use
a. Solver
b. Autosum
c. Consolidate
d. Macro
Ans. d. Macro
Q 75. Macros are especially useful to ___________ a task.
a. do
b. repeat
c. simplify
d. complicate
Ans. b. repeat
Q 76. Use ___________ Macro to start the macro recorder.
a. Tools > Macros > Record
b. Tools > Record > Record Macro
c. Data > Macros > Record
d. None of the above
Ans. a. Tools > Macros > Record
Q 77. Click _____________ to stop the macro recorder
a. Close Recording
b. End Recording
c. Stop Recording
d. None of the above
Ans. c. Stop Recording
Q 78. 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
Ans. a. Tools –> Macros — > Edit Macros
Q 79. Function names in Calc are not case sensitive.(T/F)
a. True
b. False
Ans. True
Q 80. 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
Ans. c. Standard
Comments
Post a Comment