# Class 10 Information Technology Chapter 2 Electronic Spreadsheets MCQ Questions with Answer

Electronic Spreadsheets Class 10 MCQ is one of the best strategies to prepare for the CBSE Class 10 Board exam. If you want to complete a grasp concept or work on one’s score, there is no method except constant practice. Students can improve their speed and accuracy by doing more Electronic Spreadsheets class 10 MCQ which will help them all through their board test.

Class 10 Information Technology MCQ with answers are given here to Chapter 2 Electronic Spreadsheets. These MCQs are based on the latest CBSE board syllabus and relate to the latest Class 10 Information Technology syllabus. By Solving these Class 10 MCQs, you will be able to analyze all of the concepts quickly in the Chapter and get ready for the Class 10 Annual exam.

Learn Electronic Spreadsheets Class 10 MCQ with answers pdf free download according to the latest CBSE and NCERT syllabus. Students should prepare for the examination by solving CBSE Class 10 Electronic Spreadsheets MCQ with answers given below.

Question 1. Absolute link will stop working only if the target is move(d)
(a) True
(b) False

A

Question 2. Scenarios are tools to test _________ questions.
(a) if else
(b) what else
(c) what if
(d) if

C

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

A

Question 4. In Subtotals we can select up to _______ groups of arrays.
(a) 2
(b) 3
(c) 4
(d) Infinite

B

Question 5. Click _____________ to stop the macro recorder
(a) Close Recording
(b) End Recording
(c) Stop Recording
(d) None of the above

C

Question 6. We can give different colours to different scenarios?
(a) True
(b) False

A

Question 7. Which option is suitable to calculate the effect of different interest rates on an investment.
(a) Scenario
(b) Subtotal
(c) Consolidate
(d) None of these

A

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

B

Question 9. After sharing a worksheet, ___________ is seen in the title bar after the worksheet’s title.
(a) Sharing
(b) Shared
(c) Sharing Sheet
(d) None of these

B

Question 10. Share document option available in _________ menu.
(a) Tools
(b) View
(c) Edit
(d) File

A

Question 11. ____________ is more elaborate form of Goal Seek.
(a) Scenario
(b) Subtotal
(c) Solver
(d) All of these

C

Question 12. Raman and his friends wants to work together in a spreadsheet. They can do so by
(a) Sharing Workbook
(c) Both a and b
(d) None of these

A

Question 13. Define range option is available under ________ menu.
(a) Insert
(b) View
(c) Developer
(d) Data

D

Question 14. A deleted column or row in shared worksheet is marked by a ______________ coloured bar.
(a) Light
(b) Line (c) Solid
(d) Heavy

D

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

D

Question 16. A __________ coloured border, appears around a cell where changes were made in shared worksheet.
(a) Blue
(b) Yellow
(c) Green
(d) Red

D

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

D

Question 18. We can give different colors to different scenario?
(a) True
(b) False

A

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

B

Question 20. Macros are especially useful to ___________ a task.
(a) do
(b) repeat
(c) simplify
(d) complicate

B

Whoever needs to take the CBSE Class 10 Board Exam should look at this MCQ. To the Students who will show up in CBSE Class 10 Information Technology Board Exams, It is suggested to practice more and more questions. Aside from the sample paper you more likely had solved. These Electronic Spreadsheets Class 10 MCQ are ready by the subject specialists themselves.

Question 21. Function names in Calc are not case sensitive.
(a) True
(b) False

B

Question 22. Use ___________ Macro to start the macro recorder.
(a) Tools > Macros > Record
(b) Tools > Record > Record Macro
(c) Data > Macros > Record
(d) None of these

A

Question 23. When a document is created and saved, it automatically contains a library named ___
(a) Module Library
(b) Macro Library
(c) Standard
(d) None of these

C

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

A

Question 25. Data can be consolidated from two sheets only.
(a) True
(b) False

B

Question 26. We can consolidate data by ________
(a) Row Label
(b) Column Label
(c) Both of the above
(d) None of the above

C

Question 27. Share document option available in _____ menu.
(a) Tools
(b) View
(c) Edit
(d) File

A

Question 28. Goal Seek Option available in _____________menu.
(a) Data
(b) Format
(c) Tools
(d) Insert

C

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

A

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

D

Question 31. Which of the following functions are available in consolidate window?
(a) Max
(b) Min
(c) Count
(d) All of the above

D

Question 32. In which option we have to specify the target range(Where we want the result to be displaye(d)
(a) Source data range
(b) Copy results to
(c) Need result at
(d) target range

B

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

B

Question 34. We can link a text in spreadsheet to any Web URL.
(a) True
(b) False

A

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

A

Question 36. Worksheets can be merged from ____________________ menu.
(a) Edit
(b) File
(c) View
(d) Tools

A

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

D

Question 38. Anil is the author of shared worksheet so he has the right to accept or reject changes made by the reviewers.
(a) True
(b) False

A

Question 39. Consolidate option is available under _________ menu.
(a) View
(b) Tool
(c) Insert
(d) Data

D

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

D

You can easily get good marks If you study with the help of Class 10 Electronic Spreadsheets MCQ. We trust that information provided is useful for you. NCERT MCQ Questions for Class 10 Electronic Spreadsheets PDF Free Download would without a doubt create positive results.

We hope the information shared above in regards to MCQ on Electronic Spreadsheets Class 10 with Answers has been helpful to you. If you have any questions regarding CBSE Class 10 Information Technology Solutions MCQs Pdf, write a comment below and we will get back to you as soon as possible.