Here is a high-weightage collection of 30 Previous Year Questions (PYQs) and exam-aligned Multiple Choice Questions for CBSE Class 10 Information Technology (Subject Code 402), covering the complete Unit 2: Electronic Spreadsheets (Advanced) module.
🔗 Topic 1: Analyses Data using Scenarios and Goal Seek
Q1. Which feature in a spreadsheet application allows you to gather, combine, and sum up data from separate worksheets into a single master worksheet? [CBSE Board Exam 2023]
a) Data Consolidation
b) Subtotals
c) Goal Seek
d) Solver
Answer: a) Data Consolidation
Q2. Which tool automatically creates groups and applies functions like Sum, Average, or Count to rows of related data in a sheet? [CBSE Board Exam 2024]
a) Scenario Manager
b) Subtotals
c) Pivot Table
d) Solver
Answer: b) Subtotals
Q3. A saved set of cell values for your calculations that you can quickly swap between to see different outcomes is called a __________. [CBSE Board Exam 2022]
a) Goal Seek
b) Scenario
c) Solver
d) Subtotal
Answer: b) Scenario
Q4. When using the Scenario tool in OpenOffice/LibreOffice Calc, how are the active scenario cell bounds highlighted? [CBSE Question Bank]
a) By a thick dashed red underline
b) By a colored border with a drop-down title menu
c) By flashing background animations
d) By converting all values into formulas
Answer: b) By a colored border with a drop-down title menu
Q5. If you know the final outcome you want from a formula but aren’t sure what input value is needed to reach it, which tool should you use? [CBSE Board Exam 2023]
a) Solver
b) Consolidation
c) Goal Seek
d) Scenario
Answer: c) Goal Seek
Q6. Goal Seek is widely known as a form of _________ analysis because it works backward from a target result. [CBSE Board Exam 2020]
a) Macro Automation
b) Historical Database
c) What-If
d) Linear Regression
Answer: c) What-If
Q7. Which tool is an advanced version of Goal Seek that can optimize a formula’s result by changing multiple input cells while following strict rules or limits? [CBSE Board Exam 2024]
a) Scenario Manager
b) Data Consolidate
c) Subtotal Wizard
d) Solver
Answer: d) Solver
📄 Topic 2: Link Data and Sheets
Q8. By default, how many blank sheets are provided when you open a brand new spreadsheet file in OpenOffice Calc? [CBSE Compartment Exam 2022]
a) One
b) Two
c) Three
d) Five
Answer: c) Three
Q9. Which of the following is a valid way to insert a new sheet into an open workbook? [CBSE Sample Question Paper 2024]
a) Choose Insert > Sheet from the top menu bar
b) Right-click on any existing sheet tab and select Insert Sheet
c) Click on the empty space or ‘+’ icon next to the sheet tabs
d) All of the above
Answer: d) All of the above
Q10. What special symbol must all sheet formulas begin with to calculate correctly? [CBSE Board Exam 2022]
a) $
b) #
c) =
d) @
Answer: c) =
Q11. Which character separates a sheet’s name from its cell address when creating a reference to another sheet in Calc (e.g., Sheet1.A1)? [CBSE Board Exam 2023]
a) Exclamation mark (!)
b) Period or Dot (.)
c) Dollar sign ($)
d) Ampersand (&)
Answer: b) Period or Dot (.)(Note: Excel uses !, while Calc uses .)
Q12. What type of cell reference uses a fixed address (like $A$1) so it stays exactly the same when you copy the formula to another cell? [CBSE Board Exam 2025]
a) Relative Reference
b) Absolute Reference
c) Mixed Reference
d) Dynamic Reference
Answer: b) Absolute Reference
Q13. In a spreadsheet reference string like 'file:///C:/Data/Sales.ods'#$Sheet1.$B$5, the text before the # sign tells the software the _________. [CBSE Additional Practice 2024]
a) Sheet name identifier
b) Target range address
c) Path and name of the external file
d) Calculation formula name
Answer: c) Path and name of the external file
Q14. What technology allows you to link live text or data tables from an external website directly into your spreadsheet cells? [CBSE Board Exam 2023]
a) Hyperlink Navigator
b) Web Querying via External Data Link
c) Macro Data Sync
d) Solver Constraints
Answer: b) Web Querying via External Data Link
👥 Topic 3: Share Spreadsheet Data
Q15. What menu option do you select to allow multiple users on a network to open, view, and edit the same spreadsheet file at the same time? [CBSE Board Exam 2022]
a) Edit > Track Changes
b) Tools > Share Document
c) File > Export As
d) Data > Consolidate
Answer: b) Tools > Share Document
Q16. Which of the following features is disabled or unavailable when a spreadsheet is set to Shared mode? [CBSE Sample Question Paper 2025]
a) Merging cells
b) Inserting images or audio
c) Creating charts
d) All of the above
Answer: d) All of the above
Q17. Which feature logs every single edit made to a worksheet, showing who made the change, when it happened, and what the old value was? [CBSE Board Exam 2024]
a) Macro Recorder
b) Solver Settings
c) Track Changes
d) Scenario Manager
Answer: c) Track Changes
Q18. How does Calc visually point out a cell that has an unaccepted edit when Track Changes is turned on? [CBSE Question Bank]
a) It turns the text completely invisible
b) It highlights the cell with a colored border and adds a small dot in the corner
c) It locks the cell from being clicked
d) It changes the text font size automatically
Answer: b) It highlights the cell with a colored border and adds a small dot in the corner
Q19. When multiple authors edit a shared document, what dialog screen must the owner use to look over and decide on each edit? [CBSE Board Exam 2023]
a) Open / Close Window
b) Accept / Reject Changes Dialog
c) Shared Cell Properties
d) Solver Options
Answer: b) Accept / Reject Changes Dialog
Q20. When comparing two versions of a spreadsheet, what does a worksheet use to match up and analyze the changes? [CBSE Board Exam 2025]
a) Web links
b) Cell addresses and values
c) Encrypted passwords
d) Saved macro scripts
Answer: b) Cell addresses and values
🤖 Topic 4: Create and Use Macros in Spreadsheets
Q21. A __________ is a saved sequence of keystrokes and commands that you can record and play back later to automate repetitive tasks. [CBSE Board Exam 2022]
a) Scenario
b) Macro
c) Subtotal
d) Hyperlink
Answer: b) Macro
Q22. What language is primarily used to write or edit recorded macro scripts inside OpenOffice Calc? [CBSE Sample Question Paper 2023]
a) C++
b) OpenOffice Basic
c) Java
d) HTML
Answer: b) OpenOffice Basic
Q23. Which menu path do you follow to start recording a new macro script in your spreadsheet? [CBSE Board Exam 2023]
a) File > Macros > Start Macro
b) Tools > Macros > Record Macro
c) Insert > Object > Macro Script
d) Data > Consolidate > Macro
Answer: b) Tools > Macros > Record Macro
Q24. Every custom macro function script you write begins with the keyword Sub and must end with which command? [CBSE Board Exam 2024]
a) Stop Sub
b) End Function
c) End Sub
d) Exit
Answer: c) End Sub
Q25. What is the name of the main default container or library folder where your recorded macros are saved in Calc? [CBSE Question Bank]
a) Module1
b) MacroFolder
c) ScriptLib
d) FunctionBox
Answer: a) Module1
Q26. Which feature helps you quickly find a specific cell or named range, and jump straight to it within a huge workbook? [CBSE Board Exam 2022]
a) Macro Player
b) Navigator
c) Scenario Selector
d) Subtotal Wizard
Answer: b) Navigator
Q27. What function key shortcut opens the Navigator tool pane in a spreadsheet window? [CBSE Board Exam 2020]
a) F2
b) F5
c) F7
d) F11
Answer: b) F5(Note: F11 opens Styles, F5 opens Navigator)
Q28. Why might a macro throw a warning or fail to run when you open a spreadsheet received from an external email? [CBSE Additional Practice 2023]
a) The file is too large
b) The application’s Macro Security level blocks it
c) Macros can only run on computers without internet access
d) You are missing a database engine
Answer: b) The application’s Macro Security level blocks it
Q29. What tool can you build using a macro button on a toolbar to speed up your everyday workflows? [CBSE Board Exam 2025]
a) A Web Query Link
b) A Custom Icon or Menu Shortcut
c) An Absolute Cell Reference
d) A Solver Constraint Matrix
Answer: b) A Custom Icon or Menu Shortcut
Q30. State whether the following is True or False: “Macros can be used to pass arguments or values into custom math formulas.” [CBSE Sample Question Paper 2024]
a) True
b) False
Answer: a) True