Electronic Spreadsheet Class 10 Sample Paper MCQ – We have made an effort to collect all the important MCQs given in the last 5 years in the sample paper. We have also removed the MCQs that are not necessary or outdated as per the current syllabus and are not going to come in the upcoming examination. The below-provided MCQs are taken from sample paper from the last five years. All the questions taken from CBSE sample papers are categorized topic-wise. These MCQs will be helpful to the students to score good marks in the examination.
Electronic Spreadsheet Class 10 Sample Paper MCQ
1. Which feature allows you to jump to a different document, spreadsheet, or website from within a document? (Sample Paper 2024-2025)
a. Bookmark
b. Page Break
c. Hyperlink
d. Format Painter
2. Radha is planning a school event and wants to decide how much money to allocate for different activities, like games, food, and decorations. She creates several different budget plans to see how changing the amount for each category affects the total expenses. How can Radha efficiently compare the different budget plans for her school event in the same spreadsheet? (Sample Paper 2024-2025)
a. By writing down each budget on paper
b. By using the What-if scenario feature in the spreadsheet to create and analyze different budget options
c. By asking her friends to guess the costs
d. By using the Filter function to look at one category at a time
3. What is the primary function of the Subtotal tool in Calc? (Sample Paper 2024-2025)
a. It creates a chart for the data.
b. It automatically groups data and applies common functions like sum and average.
c. It highlights cells with conditional formatting.
d. It removes duplicate data from the spreadsheet.
4. _ is specifically designed to minimize the results according to a set rules that we define in a spreadsheet. (Sample Paper 2023-2024)
a. Goal Seek
b. Scenario
c. solver
d. Subtotal
5. Sahil and his partners have created a list of their company employees in one of the spreadsheets in the office. Now the rest of the task they want to complete from home. Which option they should use to access the same Spreadsheet from home? (Sample Paper 2023-2024)
a. Consolidate Worksheet
b. Link Worksheet
c. Merge Worksheet
d. Lock Worksheet
6. Identify the part of a Spreadsheet using which a user can manage multiple sheets. (Sample Paper 2023-2024)
a. Status Bar
b. Sheet Tab
c. Formula Bar
d. Worksheet Area
7. Spreadsheet software can find the changes by _ sheets. (Sample Paper 2023-2024)
a. Changing
b. Comparing
c. Renaming
d. Editing
8. When you open a new spreadsheet, by default, it has a sheet named __ which is managed using tabs at the bottom of the spreadsheet. (Sample Paper 2022-2023)
a. Sheet1
c. Worksheet1
b. Untitled1
d. New Sheet
9. Reviewers and authors can add their __ to explain their changes in the cell of Spreadsheet. (Sample Paper 2022-2023)
a. Comments
b. Hyperlink
c. Worksheet
d. Macros
10. In a spreadsheet using to create a hyperlink to a web FTP or Telnet, click on the __ icon available in Hyperlink dialog box. (Sample Paper 2022-2023)
a. browser
b. hyperlink
c. Internet
d. mail & news
11. Which function cannot be performed through Subtotal in a Spreadsheet? (Sample Paper 2021-2022)
a. Sum
b. Product
c. Average
d. Percentage
12. _ means combining data in a spreadsheet from different worksheets into master worksheet (Sample Paper 2021-2022)
a. Hyperlinks
b. Consolidating
c. Linking
d. Filter
13. It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate. (Sample Paper 2021-2022)
a. Row
b. Column
c. Autosum
d. Cell Referenc
14. __, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows Which step one must should follow before using the Subtotal option? (Sample Paper 2021-2022)
a. Consolidate
b. Rename Data
c. Filter Data
d. Subtotal
15. A __ hyperlink contains the full address of the destination file or web page. (Sample Paper 2021-2022)
a. Relative
b. Absolute
c. Mixed
d. Address
16. Which of the following is more elaborate form of Goal Seek? (Sample Paper 2021-2022)
a. Subtotal
b. Scenario
c. Solver
d. Consolidate
17. By default, sheets tab are present at the __ of the spreadsheet. (Sample Paper 2021-2022)
a. Top
b. Bottom
c. Center
d. Right
18. The cell reference in a spreadsheet for cell range B2 to F15 is _. (Sample Paper 2021-2022)
a. B2.F15
b. B2;F15
c. B2:F15
d. B2-F15
19. Hema is a chartered accountant. She used to maintain the accounts in a spreadsheet on everyday basis. There are number of steps which she needs to follow every time. Can you suggest her a feature of spreadsheet through which she can perform these tasks quickly without repeating the steps every time? (Sample Paper 2021-2022)
a. Record Changes
b. Track Changes
c. Goal Seek
d. Using Macros
20. Raj has created a worksheet where he has added all the information of his employees. He wants every employee to go through the worksheet and update their address and phone number, if required. He also would like to know the changes done by his employees. Which feature of spreadsheet he should enable to see the changes made by his employees? (Sample Paper 2021-2022)
a. Macro
b. Link Workbook
c. Change Worksheet
d. Track Changes
21. Sunita is making a project in spreadsheets. Her friend has told her how to rename a spreadsheet as it will help her identify the worksheet data easily. She was very excited and told the same to her brother. Her brother told her that in spreadsheets(OpenOffice0, a worksheet can be renamed using __ ways. (Sample Paper 2021-2022)
a. 2
b. 3
c. 4
d. 1
22. ______is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet. (Sample Paper 2020-2021)
a. Goal Seek
b. Scenario
c. Solver
d. Subtotal
23. Formulas in a Spreadsheet must begin with a __ sign. (Sample Paper 2020-2021)
a. $
b. @
c. #
d. =
24. _______can be used in a spreadsheet software to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites. (Sample Paper 2020-2021)
a. Illustrations
b. Hyperlinks
c. Links
d. Filter
25. Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same Spreadsheet to speed up their work. (Sample Paper 2020-2021)
a. Consolidate Worksheet
b. Shared Worksheet
c. Link Worksheet
d. Lock Worksheet
26. Scenarios are a tool to test questions. (Sample Paper 2021-2022)
a. Auto
b. Goal Seek
c. What-if
d. Drop Down
27. Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so. (Sample Paper 2020-2021)
a.Macro
b. Solver
c. Goal Seek
d. Sub Total
28. _ is a tool to test “what-if” questions. (Sample Paper 2020-2021)
a. Scenario
b. Solver
c. Macro
d. Average
29. __ is a text editor that allows you to create and edit macros. (Sample Paper 2024-2025)
a. IDE
b. Notepad
c. Open Office Writer
d. MS Word
30. The code of macro begins with _ followed by the name of the macro and ends with _. (Sample Paper 2024-2025)
a. Function, End
b. Sub, End Sub
c. Sub, End Function
d. Sup, End Sup
31. __ can help to clarify the relation between cells while using “Multiple Operations”. (Sample Paper 2023-2024)
a. Detective
b. Solver
c. Navigation
d. Hyperlink
32. At the bottom of each worksheet, left tab indicates the __ of the worksheet in a workbook. (Sample Paper 2023-2024)
a. Size
b. 3 Type
c. Name
d. Color
33. In Calc, Arguments passed to a macro from Calc are always _. (Sample Paper 2022-2023)
a. Cell Reference
c. Both a and b
b. Value
d. Sheet Reference
34. A _ refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate. (Sample Paper 2022-2023)
a. Cell reference
c. Sheet Reference
b. Block
d. Autofill
35. __ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily. (Sample Paper 2022-2023)
a .Data Combination
b. Data Merging
c. Data Consolidation
d. Data Concatenation
36. An _ link will stop working only if the target is moved while a_______ link will stop working only if the start and target locations change relative to each other. (Sample Paper 2021-2022)
a. absolute, fixed
b. Relative, Absolute
c. absolute, relative
d. permanent, absolute
37. The intersection point between a row and column is called _. (Sample Paper 2020-2021)
a. Row
b. Column
c. Table
d. Cell
38. A __ hyperlink stores the location with respect to the current location in LibreOffice Calc. (Sample Paper 2024-2025)
a. Absolute
b. Relative
c. Mixed
d. Reference
Disclaimer: We have made an effort to provide you with the CBSE sample paper MCQs of “Electronic Spreadsheet Class 10 Sample Paper MCQ.”. If you feel that there is any error or mistake, please contact me at anuraganand2017@gmail.com. The above CBSE sample paper 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 sample paper, 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 Sample Paper MCQ”