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.

Electronic Spreadsheets Class 10 MCQ Questions with Answer

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.