ELECTRONIC SPREADSHEET CLASS 10

1. __________is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.

• a) Goal Seek

• b) Scenario

• c) Solver

• d) Subtotal

2. The intersection point between a row and column is called _______.

• a) Row

• b) Column

• c) Table

• d) Cell

3. Formulas in a Spreadsheet must begin with a __________ sign.

• a) $

• b) @  

• c) #

• d) =

4. ___________ is a tool to test “what-if” questions.

• a) Scenario

• b) Solver

• c) Macro

• d) Average

5. Vinay sales percentage in North India is 67%, in South India it is 78%. He wants to calculate the Sales percent required in East India to achieve 80 percent in aggregate. Suggest him the suitable option out of the following to do so.

• a)Macro

• b) Solver

• c) Goal Seek

• d) Sub Total

6. _________can be used in a spreadsheet software 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.

• a) Illustrations

• b) Hyperlinks

• c) Links

• d) Filter

7. Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same Spreadsheet to speed up their work.

• a) Consolidate Worksheet

• b) Shared Worksheet

• c) Link Worksheet

• d) Lock Worksheet

8. A _________ 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.

• a) Range

• b) Cell Reference

• c) Cell Address

• d) table

9. 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. To activate this feature which option should be selected?

• a) Edit à Changes àRecord

• b) Edit à Changes àComments

• c) Tools àMacro

• d) Tools àMacro àRecord

10. _______ link will stop working only if the target is moved in a calc.

• a) Relative

• b) Absolute

• c) Hyperlink

• d) All of the above