# 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

Answer

A

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

Answer

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

Answer

A

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

Answer

B

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

Answer

C

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

Answer

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

Answer

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

Answer

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

Answer

B

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

Answer

A

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

Answer

C

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

Answer

A

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

Answer

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

Answer

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

Answer

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

Answer

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

Answer

D

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

Answer

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

Answer

B

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

Answer

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

Answer

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

Answer

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

Answer

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

Answer

A

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

Answer

B

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

Answer

C

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

Answer

A

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

Answer

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

Answer

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

Answer

D

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

Answer

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

Answer

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

Answer

B

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

Answer

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

Answer

A

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

Answer

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

Answer

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

Answer

A

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

Answer

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

Answer

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.

### Frequently Asked Question (FAQs)

How many MCQ questions are there in Class 10 Chapter 2 Information Technology?

In Class 10 Chapter 2 Information Technology, we have provided 40 Important MCQ Questions, But in the future, we will add more MCQs so that you can get good marks in the Class 10 exam.

Can we score good marks in Class 10 Information Technology with the help of Electronic Spreadsheets MCQ Questions?

Yes, MCQ Question is one of the best strategies to make your preparation better for the CBSE Board Exam. It also helps to know the student’s basic understanding of each Chapter. So, You can score good marks in the Class 10 Information Technology exam.