CLASS-X | Chapter- Electronic Spreadsheet (Advanced) [Objective Type]

 Class - X

Subject - Information Technology

Chapter- Electronic Spreadsheet (Advanced)

 [Objective Type]

Session - 2020-21



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

 a) $

 b) @ 

 c) #

 d) = 

ANS d) = 


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

 a) Scenario 

 b) Solver 

 c) Macro 

 d) Average 

ANS a) Scenario 


Q3. Rohit 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. Suggest him the suitable option out of the following to do so. 

a)Macro 

b) Solver 

c) Goal Seek 

d) Sub Total 

ANS c) Goal Seek 


Q4. _________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 

ANS b) Hyperlinks


Q5. ______________ uses the keyboard as a pointing device instead of a mouse. 

a) MouseKeys 

b) Toggle key 

c) Filter key 

d) Sticky key 

ANS a) MouseKeys


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

ANS b) Shared Worksheet


Q7. ___________ database is a type of database that stores data in several tables. a) Flat 

b) Relational 

c) both (a) and (b)
c) None of them 

ANS b) Relational 


Q8. _________is an accessibility function that tells the keyboard to ignore brief or repeated keystrokes, making typing easier for people with hand tremors. 

Ans. FilterKeys


Q9. _______ feature is used to extract the data using some conditions on columns. Ans. Filter


Q10. A ________ is a graphical representation of data, in which the data is represented by symbols, such as bars. 

Ans. Chart


Q11. A ___________ represents a single, data item in a table. a. Row b. Column c. Datatype d. Primary Key. 

Ans. Row


Q12. AutoSum option is available in _________________ group under the Home tab. Ans : Editing


Q13. Which of the following is not a ‘what-if analysis’ tool?

  1. Scenario

  2. Track Change

  3. Solver

  4. Goal seek

Ans: Track Change


Q14. Which statement best describes What-If Analysis Goal Seeking?

  1. Allows you to define output results and then shows what input values are needed to generate that result.

  2. Allows you to investigate how changes to one or two input variables in a formula changes output results.

  3. Allows you to define input variables in various situations. The output result for each situation is shown in a summary table.

Ans: Allows you to define output results and then shows what input values are needed to generate that result.


Q15. Which of the following is NOT an example of a what-if analysis?

  1. Find how raises will affect employee salaries

  2. Find the five top sales people in a company

  3. Find the business profits for different levels of sales

  4. Find the loan payment based for different interest rates

Ans: Find the five top sales people in a company


Q16. Which What-if Analysis tool would you use to solve the following problem? You want to figure out how to keep a car loan under Rs. 12,000 a month.

  1. Goal Seeking

  2. Scenario

  3. Solver

Ans:Goal Seeking


Q17. Which What-If Analysis tool would you use to solve the following problem? You want to find out what interest rate you have to get in order to keep your monthly budget Rs 10,000/- a month.

  1. Goal Seeking

  2. Scenario

  3. Solver

Ans:Scenario


Q18. __________ is when you change one or more values in a spreadsheet and then assess how those changes affect the calculated values.

  1. What-if analysis

  2. Track Changes

  3. Save Changes

  4. All of these

Ans: What-if analysis


Q19 To refer to cell K5 of sheet MyData in another worksheet namely Final’s cell B3, what would you write.

  1. K5.MyData

  2. B3.Final

  3. MyData.K5

  4. Final.B3.MyData.K5

Ans: MyData.K5


Q20. What is a document hyperlink?

  1. A shortcut icon placed on the desktop of computer

  2. Copied document in a flash drive

  3. A link, clicking on which opens the linked document

  4. An address of a web page

Ans: A link, clicking on which opens the linked document


Q21. A(n) __________Hyperlink points to the path to reach a document from location.

Ans: Relative


Q22. A(n)________hyperlink points to the path to reach a document topmost folder.

Ans: Absolute 


Q23. Calc always displays a hyperlink in __________ form.

Ans: Absolute 


Q24. In Calc, the registered data sources are the databases that are compatible with:

  1. *.txt

  2. *.odt

  3. *.sql

  4. *.odb

Ans: *.odb

Q25. Can you add a link inside a worksheet to a table on an HTML document, in Calc?

  1. YES

  2. NO

ANS: YES


Q26. Consider the hyperlink : ..\mydata.odv Identify the type of this of this document hyperlink.

  1. Relative

  2. Absolute

Ans: Relative

Q27. Consider the hyperlink : D:\Data\mydata.odb Identify the type of this document hyperlink.

  1. Relative

  2. Absolute

Ans: Absolute


Q28. Multiple users are working on same spreadsheet and are able to vies the change made in it. This working mode is known as ___________in Calc.

  1. View mode

  2. Change mode

  3. Shared Mode

  4. Record changes Mode

Ans: Shared Mode


Q29. Making changes temporarily in a document so as to confirm them later by reviewing them. This working mode is known as __________in Calc.

 View mode

  1. Change mode

  2. Shared Mode

  3. Record changes Mode

Ans: Record changes Mode


Q30. The description about the changes made in cells are available through________.

  1. Descriptive list

  2. Comments

  3. Position

  4. None of these

Ans: Comments


Q31. You can create / run macros in Calc using ___________menu.

  1. Insert

  2. Data

  3. Format

  4. Tools

Ans: Tools


Q32. As you record a macro, Calc converts your keystrokes into:

  1. Formulas

  2. Hyperlinks

  3. Internal code

  4. Shortcuts

ANS: Internal Code


Q33. When you record a macro, its tasks/keystrokes are stored in code, inside ____ and ____ clauses.

  1. Macro, End Macro

  2. Sub, End Sub

  3. Function, End Function

  4. Task, End Task


Q34. In order to use a macro as a function, it must be stored in code, inside _____ and _______ clauses.

  1. Macro, End Macro

  2. Sub, End Sub

  3. Function, End Function

  4. Task, End Task

ANS: Function, End Sub


Q35. The values can also be passed to macros as functions.

  1. True

  2. False

Ans: True


Q36. The values passed to macro are called _____________.

  1. Values

  2. Work values

  3. Arguments 

  4. Data values

Ans: Arguments
Labels: