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
Q. Which keyboard shortcut is used to open the Templates dialog box in LibreOffice Writer to manage or set default templates?
a) Ctrl + Shift + T
b) Ctrl + Alt + N
c) Ctrl + Shift + N
d) Ctrl + N
Q. Rohit is analyzing sales data spread across four different sheets in LibreOffice Calc. He wants to combine the data into a single sheet to identify overall trends and relationships. He also wants any change in the source sheets to automatically update in the consolidated sheet. Which feature and option should he use?
a) Use Pivot Table with the “AutoFilter” option
b) Use Consolidate with the “Link to source data” option enabled
c) Use Data Validation with “Cell Range” enabled
d) Use Scenario Manager with “Copy Results To” option
Q. Ritika has created a spreadsheet to calculate the EMI for a car loan. The EMI depends on the loan amount, interest rate, and loan duration (years). She fixes the loan amount and interest rate, but wants the EMI to be exactly ₹12,000 per month. Which feature of Calc should she use, and why?
a) Goal Seek – because it adjusts the input (loan duration) to reach the exact target output (EMI = ₹12,000).
b) Scenario Manager – because it allows creating multiple possible outcomes with different sets of inputs.
c) Consolidate – because it combines data from different sheets into one summary.
d) Data Validation – because it restricts the type of values that can be entered into a cell.
Q. Sneha is preparing 10 different project reports for her company. Each report requires the same header with the company logo, a footer with the legal notice, and predefined formatting for headings and text. Instead of manually inserting and formatting these elements in each report, which feature of LibreOffice Writer should she use?
a) Styles
b) Macros
c) Templates
d) Table of Contents
Q. A company’s finance team is preparing the quarterly budget report. Two managers, Mr. Raj and Ms. Meera, work on the same spreadsheet file separately (Budget_Raj.ods and Budget_Meera.ods). Now, before submitting the final report to the CEO, the team needs to:
- Check the differences in both versions.
- Merge the approved changes into one final file.
As the data entry operator, which steps will you follow in LibreOffice Calc?
a) Directly open Budget_Raj.ods and overwrite it with Budget_Meera.ods.
b) Open Budget_Raj.ods, use Compare Document to review differences, then use Merge Document to finalize.
c) Open Budget_Meera.ods and delete conflicting data manually.
d) Use only Merge Document, since it automatically compares files too.
Q. Which of the following image tools is used to change the image to black and white, grayscale or a watermark ?
(A) Image Crop
(B) Image Mode
(C) Image Align
(D) Image Size
Q. A __________ is a preset layout that helps to create professional and/or formal documents easily.
(A) Template
(C) ToC
(B) Style
(D) SoC
Q. Ravi is analysing monthly sales data in Calc. He wants to test how changing the discount rate affects total revenue. Which feature should he use to simulate different outcomes ?
(A) Sort
(B) Indexing
(C) What-if Scenarios
(D) Filter
Q. While reviewing a shared spreadsheet, Priya notices that some cells have been modified, but she’s unsure who made the changes. Which feature should she use to identify the editor ?
(A) Data Validation
(B) Track Changes
(C) Observe Changes
(D) AutoFilter
Q. Which of the following is the correct way to record a macro in LibreOffice Calc ?
(A) Tools → Macros → Record Macro
(B) File → Options → Record Macro
(C) Insert → Macro → Record
(D) View → Macros → Record
Q. Which one of the following is the default function when a Consolidate dialog box opens in LibreOffice Calc ?
(A) Average
(B) Sum
(C) Max
(D) Var
Q. Which Calc feature allows multiple users to suggest edits while preserving the original data ?
(A) Protect Sheet
(B) Share Document
(C) Track Changes
(D) Insert Comments
Q. In Calc, which of the following types of hyperlink uses the complete location where the file to be linked is stored ?
(A) Absolute hyperlink
(B) Mixed hyperlink
(C) Relative hyperlink
(D) Static hyperlink
Q. In LibreOffice Writer, _________ Image Filter tool is used in photographs to reverse the tone.
(A) Solarisation
(B) Sharpen
(C) Invert
(D) Aging
Q. What is the main purpose of the Table of Contents feature in LibreOffice Writer ?
(A) To create a list of all images in the document
(B) To check spelling and grammar in headings
(C) To insert hyperlinks only
(D) To automatically generate a list of headings along with their page numbers
Q. GIF, JPEG and PNG are examples of :
(A) Audio file formats
(B) Video file formats
(C) Graphics file formats
(D) Text file formats
Q. In LibreOffice Writer, where does the comment box appear after inserting a comment ?
(A) At the top of the document
(B) At the bottom of the page
(C) On the left side of the window
(D) On the right side of the window
Q. In LibreOffice Calc, to refer to a cell in another sheet of the same file, precede the cell reference with a __________ sign.
(A) $
(B) #
(C) . (dot)
(D) !
Q. Consolidating data is useful for identifying :
(A) Errors and spelling mistakes
(B) Trends and relationships
(C) File size
(D) Cell colours
Q. In LibreOffice Calc, the _________ tool is used to predict the output while changing the inputs and thus, one can choose the best plan of action based on it.
(A) Scenario
(B) Subtotal
(C) Consolidate
(D) Relative
Q. Goal Seek feature is available under _________ menu in LibreOffice Calc.
(A) Data
(B) Tools
(C) Insert
(D) Functions
Q. The extension of the file created in LibreOffice Calc is :
(A) .odg
(B) .odt
(C) .odc
(D) .ods
Q. A school principal wants all teachers to record their monthly attendance in a single spreadsheet so that the total attendance can be calculated automatically. Which option in LibreOffice Calc is most suitable to allow multiple users to update the spreadsheet at the same time ?
(A) Ask each teacher to email their attendance and update manually.
(B) Use separate copies of the spreadsheet for each teacher.
(C) Use the shared spreadsheet feature for collaborative editing.
(D) Use formulas to automatically fill the attendance.
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 “Electronic Spreadsheet 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”