Electronic Spreadsheet Class 10 Board MCQ Questions – We have made an effort to collect all the important MCQs asked in the last 5 years in board examinations. We have also removed the MCQs that are not necessary in the upcoming examination. The below-provided MCQs are taken from board question papers from the last five years. All the questions taken from CBSE board question papers are categorized topic-wise. These MCQs will be helpful to the students to score good marks in the examination.
Electronic Spreadsheet Class 10 Board MCQ Questions
1. While consolidating data, a cell range can be named using _ option. (CBSE 2023-24)
a. Name range
b. Define range
c. Consolidate name
d. Define name
2. Kawal and his friends are working on a Spreadsheet for entering data and updating records. They wish to keep a track of changes. Which of the following options will help in knowing who made the changes and what changes were done in the spreadsheet ? (CBSE 2023-24)
a. View changes
b. Record changes
c. Store changes
d. Track changes
3. _ is a more elaborate form of Goal Seek. (CBSE 2023-24)
a. Database
b. Hyperlink
c. Report
d. Solver
4. Macro functions can be written to behave as regular functions by writing a/an _. (CBSE 2023-24)
a. Void
b. Return
c. Add-In
d. Dim
5. _ option of Calc helps in viewing the changes made to a worksheet using original and edited worksheet. (CBSE 2023-24)
a. Edit -> Revise document
b. Edit -> Consolidate
c. Edit -> Compare document
d. Edit -> Collaborate document
6. In Calc, shared workbooks allow : (CBSE 2023-24)
a. Merging cells
b. Conditional formatting
c. Inserting pictures/graphs
d. Adding text
7. While consolidating data, a cell range can be named using _ option. (CBSE COMP 2023-24)
a. Name range
b. Define range
c. Consolidate name
d. Define name
8. Kawal and his friends are working on a Spreadsheet for entering data and updating records. They wish to keep a track of changes. Which of the following options will help in knowing who made the changes and what changes were done in the spreadsheet ? (CBSE COMP 2023-24)
a. View changes
b. Record changes
c. Store changes
d. Track changes
9. _ is a more elaborate form of Goal Seek. (CBSE COMP 2023-24)
a. Database
b. Hyperlink
c. Report
d. Solver
10. Macro functions can be written to behave as regular functions by writing a/an _. (CBSE COMP 2023-24)
a. Void
b. Return
c. Add-In
d. Dim
11. _ option of Calc helps in viewing the changes made to a worksheet using original and edited worksheet. (CBSE COMP 2023-24)
a. Edit -> Revise document
b. Edit -> Consolidate
c. Edit -> Compare document
d. Edit -> Collaborate document
12. In Calc, shared workbooks allow : (CBSE COMP 2023-24)
a. Merging cells
b. Conditional formatting
c. Inserting pictures/graphs
d. Adding text
13. A colored border, with , appears around a cell where changes are made in a shared worksheet. (CBSE 2022-23)
a. a dot in the upper left-hand corner
b. a dot in the lower left-hand corner
c. across in the upper left-hand corner
d. across in the upper right-hand corner
14. _ feature adds data arranged in a group of cells in Calc, with labels for columns and/or rows. (CBSE 2022-23)
a. Average
b. Subtotal
c. Goal seek
d. Solver
15. A refers to a cell or a range of cells on a worksheet whose data values can be used in a formula. (CBSE 2022-23)
a. sheet
b. cell
c. cell reference
d. cell data
16. __ feature of Calc is used to test ‘what-if questions. (CBSE 2022-23)
a. Solver
b. Goal seek
c. Scenario
d. Styles
17. Macros are especially useful to the same way over and over again. (CBSE 2022-23)
a. repeat a task
b. reject a task
c. report a task
d. comment a task
18. __ feature of Calc helps to track what data was changed, when the change was made, who made the change and in which cell the change has occurred. (CBSE 2022-23)
a. Record Changes
b. Edit record
c. Change record
d. Macro
19. A statistical formula can be applied to a selected array of cells using _. (CBSE COMP 2022-23)
a. Consolidate
b. Goal seek
c. Subtotal
d. Autosum
20. Which of the following term refers to a cell or range of cells that can be used in a formula ? (CBSE COMP 2022-23)
a. Cell Reference
b. Cell Formula
c. Formula Reference
d. Linked Cells
21. How many sheets are provided by default in spreadsheets in a workbook ? (CBSE COMP 2022-23)
Show Answer ⟶22. Give an example of statistical function in Calc. (CBSE COMP 2022-23)
Show Answer ⟶23. Record changes feature of Calc marks a deleted column or row in a worksheet by a _. (CBSE COMP 2022-23)
a. red border over the cell
b. green border over the cell
c. red shade in the cell
d. heavy colored bar
24. _ is a saved sequence of commands or keystrokes that are stored for later use. (CBSE COMP 2022-23)
a. Record Changes
b. Compare Changes
c. Merge
d. Macro
Disclaimer: We have made an effort to provide you with the CBSE Board MCQs of “DBMS Class 10 Board MCQ Questions”. If you feel that there is any error or mistake, please contact me at anuraganand2017@gmail.com. The above CBSE Board MCQs presented on our website are for educational purposes, not our copyrights. All the above MCQs and questions are taken from the Information Technology Class 10 Board Examination Question Paper conducted by CBSE, which is present on the CBSEACADEMIC website. These MCQs and questions are legally copyrighted by the Central Board of Secondary Education. We are only providing a medium and helping the students to improve the performances in the examination.
For more information, refer to the official CBSE textbooks available at cbseacademic.nic.in
1 thought on “Electronic Spreadsheet Class 10 Board MCQ Questions”