Class 12 IT(402): Electronic Spreadsheet MCQs

🔥 Learn. Practice. Score! 📚🏆

Strengthen your CBSE exam preparation with these Electronic Spreadsheet MCQs with Answers. These MCQs are carefully prepared according to the latest CBSE syllabus and board exam pattern.

Electronic Spreadsheet is one of the most important and highest-scoring units in Class 10 IT, carrying around 10 marks in the CBSE board examination. Ignoring practice from this unit can mean missing a valuable opportunity to score easy marks.

This practice set covers all major Electronic Spreadsheet topics, including Data, Groups and Subtotals, What-if Scenarios, What-if Analysis Tools, Goal Seek, Macros, Setting up Multiple Sheets, References to Other Sheets and Documents, Hyperlinks, Relative and Absolute Hyperlinks, Creating Hyperlinks, and Sharing Spreadsheets.

📊 Practice regularly, master spreadsheet concepts, and turn this 10-mark unit into your scoring advantage! 🎯

Q1. Identify the option that is NOT primarily used for analysing spreadsheet data.
a) Goal Seek
b) Consolidate
c) Page Layout
d) Subtotal

Q2. A company receives monthly sales reports from different branches in separate worksheets. Which LibreOffice Calc feature should be used to prepare a combined summary?
a) Scenario
b) Consolidate
c) Goal Seek
d) Sort

Q3. __________ is the Calc feature used to combine information from multiple cell ranges into a single summary.
a) Subtotal
b) Scenario
c) Consolidate
d) Goal Seek

Q4. For accurate consolidation, all source ranges should preferably have:
a) Matching data structure and data types
b) Identical page orientation
c) Same worksheet colour
d) Equal number of worksheets

Q5. The Consolidate command is available under which menu in LibreOffice Calc?
a) Insert
b) Data
c) Sheet
d) Tools

Q6. Which summary function is selected by default in the Consolidate dialog box?
a) Average
b) Count
c) Sum
d) Maximum

Q7. The Source Data Ranges section in the Consolidate dialog is used to:
a) Specify the cell ranges that will be combined
b) Select chart types
c) Create formulas
d) Rename worksheets

Q8. A worksheet contains identical row names in different data ranges. To consolidate records based on these names, which option should be enabled?
a) Link to Source Data
b) Row Labels
c) Column Labels
d) Function

Q9. A manager wants the consolidated report to reflect any future changes made in the source worksheets automatically. Which option should be selected?
a) Function
b) Column Labels
c) Link to Source Data
d) Row Labels

Q10. After grouping rows in a worksheet, users can quickly expand or collapse them using:
a) Arrow keys
b) Plus (+) and Minus (–) symbols
c) Scroll bars
d) Fill Handle

Q11. To group selected rows in LibreOffice Calc, choose:
a) Data → Filter
b) Data → Group and Outline → Group
c) Data → Group and Outline → Rows
d) Sheet → Group Rows

Q12. A sales report contains hundreds of records. The manager wants department-wise totals along with collapsible groups. Which feature should be used?
a) Scenario
b) Goal Seek
c) Subtotal
d) Consolidate

Q13. Which of the following functions can be applied while creating subtotals?
a) Sum
b) Average
c) Count
d) All of these

Q14. In the Subtotal dialog box, the Group By option is used to:
a) Select the worksheet
b) Specify the column used for grouping records
c) Choose the chart style
d) Define the print range

Q15. Which function is selected by default in the Subtotal dialog box?
a) Count
b) Average
c) Sum
d) Minimum

Q16. Consider the following statements about the Subtotal feature.

Statement I: Multiple levels of grouping can be created.
Statement II: The 2nd Group and 3rd Group tabs are used for additional grouping levels.

Choose the correct option.
a) Both Statement I and Statement II are true.
b) Both Statement I and Statement II are false.
c) Statement I is true but Statement II is false.
d) Statement I is false but Statement II is true.

Q17. __________ is a What-if Analysis tool that allows users to compare different sets of input values without changing the original worksheet.
a) Consolidate
b) Scenario
c) Subtotal
d) Sort

Q18. A company wants to compare its annual profit under different selling prices before making a business decision. Which LibreOffice Calc feature would be the most appropriate?
a) Goal Seek
b) Scenario
c) Consolidate
d) Subtotal

Q19. The Scenario feature is primarily used to:
a) Merge worksheets into one
b) Compare the outcomes of different sets of input values
c) Protect spreadsheet data
d) Create charts automatically

Q20. The command used to create a Scenario is available under:
a) Insert
b) Format
c) Tools
d) Data

Q21. Before creating a Scenario, the first step is to:
a) Select the cells whose values will change
b) Protect the worksheet
c) Create a Pivot Table
d) Insert a chart

Q22. Every Scenario must be assigned a unique __________ so that it can be identified later.
a) Password
b) Formula
c) Name
d) Sheet Number

Q23. Multiple Operations performs calculations using __________ arrays.
a) One
b) Two
c) Three
d) Four

Q24. A shopkeeper wants to know the profit earned for different quantities sold without repeatedly changing the formula. Which Calc feature should be used?
a) Scenario
b) Multiple Operations
c) Consolidate
d) Subtotal

Q25. In the Multiple Operations dialog box, the Formula field is used to specify:
a) The worksheet name
b) The cell containing the formula to be evaluated
c) The chart title
d) The destination sheet

Q26. The Column Input Cell in the Multiple Operations dialog represents:
a) The output cell
b) The variable whose values will change
c) The worksheet title
d) The row heading

Q27. __________ is used to determine the required input value that will produce a desired result.
a) Scenario
b) Goal Seek
c) Consolidate
d) Subtotal

Q28. Unlike ordinary formulas that calculate results from known values, Goal Seek performs:
a) Forward calculation
b) Reverse (backward) calculation
c) Random calculation
d) Conditional calculation

Q29. Which menu should be used to open the Goal Seek dialog box?
a) Data
b) Sheet
c) Tools
d) Format

Q30. A student has scored marks in four subjects and wants to know the marks required in the fifth subject to achieve an average of 80%. Which LibreOffice Calc feature should be used?
a) Scenario
b) Goal Seek
c) Consolidate
d) Subtotal

Q31. Assertion (A): Goal Seek is considered a What-if Analysis tool.

Reason (R): It determines the input value required to achieve a specified target result.

a) Both A and R are true, and R is the correct explanation of A.
b) Both A and R are true, but R is not the correct explanation.
c) A is true, but R is false.
d) A is false, but R is true.

Q32. The primary purpose of using a macro in LibreOffice Calc is to:
a) Create charts automatically
b) Automate a sequence of repetitive tasks
c) Protect worksheets with passwords
d) Merge multiple spreadsheets

Q33. A teacher applies the same formatting to every worksheet every month. Which Calc feature would save the maximum time?
a) Scenario
b) Macro
c) Consolidate
d) Goal Seek

Q34. A recorded macro stores a sequence of:
a) Worksheets and charts
b) Commands and keystrokes
c) Cell references only
d) Spreadsheet formulas only

Q35. By default, the Macro Recording feature in LibreOffice is __________.
a) Enabled
b) Disabled
c) Hidden permanently
d) Password protected

Q36. Before recording a macro for the first time, a user must enable Macro Recording from:
a) Data → Options
b) Tools → Options → LibreOffice → Advanced
c) Format → Options
d) Insert → Options

Q37. Which of the following actions is NOT recorded by the Macro Recorder?
a) Typing data into cells
b) Entering formulas
c) Formatting cells
d) Opening another window

Q38. The Macro Recorder cannot record:
a) Formula entry
b) Cell formatting
c) Actions performed in another application window
d) Typing text

Q39. The built-in Macro Recorder is available only in LibreOffice __________.
a) Impress and Draw
b) Writer and Calc
c) Base and Math
d) Draw and Base

Q40. To begin recording a macro, choose:
a) Tools → Macros → Record Macro
b) Data → Record Macro
c) Insert → Record
d) Sheet → Record Macro

Q41. The default name assigned to a newly recorded macro is:
a) Default
b) Main
c) Macro1
d) Start

Q42. By default, a recorded macro is stored in the:
a) Gallery
b) Standard Library
c) My Documents
d) Clipboard

Q43. A user saves a new macro using the same name as an existing macro in the same location. What is most likely to happen?
a) A duplicate macro is created.
b) The existing macro is overwritten.
c) Both macros are merged.
d) The new macro is ignored.

Q44. In LibreOffice Basic, a Library is a collection of:
a) Worksheets
b) Modules
c) Charts
d) Macros only

Q45. A Module mainly contains a collection of:
a) Worksheets
b) Macros
c) Charts
d) Spreadsheet files

Q46. Which of the following is a valid name for a macro?
a) 1Heading
b) Format Heading
c) Format*Heading
d) Format_Heading

Q47. A macro name must always begin with a:
a) Number
b) Letter
c) Special character
d) Space

Q48. Which special character is permitted in a macro name?
a) #
b) %
c) _ (underscore)
d) @

Q49. To execute a previously saved macro, select:
a) Tools → Macros → Run Macro
b) Insert → Run Macro
c) Data → Macros
d) Window → Run Macro

Q50. Which programming language is used to create and modify macros in LibreOffice Calc?
a) Python
b) Java
c) BASIC
d) C++

Q51. To modify the code of an existing macro, the user should select:
a) Tools → Macros → Edit Macros
b) Data → Edit Macro
c) Insert → Macro
d) Format → Edit Macro

Q52. A user can successfully edit the code generated by the Macro Recorder only if they are familiar with:
a) Java
b) Python
c) LibreOffice BASIC
d) HTML

Q53. Every macro procedure in LibreOffice BASIC begins with the keyword __________.
a) Begin
b) Function
c) Sub
d) Start

Q54. Which statement correctly describes the structure of a simple macro in LibreOffice BASIC?
a) It begins with Function and ends with End Function.
b) It begins with Sub and ends with End Sub.
c) It begins with Start and ends with Stop.
d) It begins with Begin and ends with End.

Q55. A user wants to create, rename, delete, or organize libraries and modules containing macros. Which option should be used?
a) Data → Organize
b) Tools → Macros → Organize Macros → LibreOffice BASIC
c) Sheet → Organize
d) Insert → Modules

Q56. A programmer writes the following code:

Sub Main
MsgBox “Hello”
End Sub

The message “Hello” will be displayed when:
a) The workbook is opened.
b) The macro is executed.
c) The worksheet is printed.
d) The file is saved.

Q57. A macro can be executed directly from the IDE by pressing the __________ key.
a) F2
b) F3
c) F4
d) F5

Q58. Unlike an ordinary macro procedure, a Macro as a Function is declared using:
a) Start … Stop
b) Function … End Function
c) Sub … End Sub
d) Begin … End

Q59. Comments in LibreOffice BASIC are preceded by the symbol __________.
a) #
b) //
c) ‘
d) %

Q60. Which keyboard shortcut is used to save the code while working in the IDE?
a) Ctrl + N
b) Ctrl + P
c) Ctrl + A
d) Ctrl + S

Q61. Which of the following is NOT an advantage of using macros?
a) They reduce repetitive manual work.
b) They save time by automating tasks.
c) They intentionally increase the spreadsheet file size.
d) They improve efficiency while performing routine operations.

Q62. Assertion (A): A recorded macro can be executed multiple times.

Reason (R): A macro stores a sequence of commands that can be reused whenever required.

a) Both A and R are true, and R is the correct explanation of A.
b) Both A and R are true, but R is not the correct explanation.
c) A is true, but R is false.
d) A is false, but R is true.

Q63. While saving a newly recorded macro, a user wants to organize similar macros together. Which is the best approach?
a) Save every macro in a different spreadsheet.
b) Store related macros in the same library.
c) Rename the worksheet.
d) Save the macro in the clipboard.

Q64. An office assistant needs to apply the same formatting to hundreds of spreadsheets every week. Which LibreOffice feature would provide the greatest improvement in productivity?
a) Goal Seek
b) Macro
c) Consolidate
d) Scenario

Q65. A teacher wants every worksheet in a workbook to have identical heading formatting. Instead of repeating the same formatting steps manually, which feature should be used?
a) Consolidate
b) Goal Seek
c) Macro
d) Subtotal

Q66. A company’s monthly sales data is stored in different worksheets. The manager wants the combined report to update automatically whenever the source data changes. Which combination of feature and option is most appropriate?
a) Subtotal with Group By
b) Consolidate with Link to Source Data
c) Scenario with Navigator
d) Goal Seek with Target Value

Q67. The primary purpose of linking data between worksheets is to:
a) Increase workbook size
b) Eliminate repeated data entry and reduce errors
c) Protect worksheets with passwords
d) Improve page formatting

Q68. A teacher updates marks in the Term-1 worksheet. She wants the Result sheet to reflect the changes automatically. Which spreadsheet feature makes this possible?
a) Conditional Formatting
b) Linking Cell References
c) Subtotal
d) Scenario

Q69. Which of the following can be used to insert a new worksheet in LibreOffice Calc?
a) (+) Add Sheet button
b) Formula Bar
c) Status Bar
d) Sidebar

Q70. A user prefers using the shortcut menu to insert a worksheet. Which sequence should be followed?
a) Right-click the sheet tab → Insert Sheet
b) Right-click the worksheet → New Formula
c) Right-click the Formula Bar → Insert Sheet
d) Right-click the Status Bar → Add Sheet

Q71. The Insert Sheet dialog box can also be opened using:
a) Data → Insert
b) Sheet → Insert Sheet
c) View → Sheet
d) Tools → Sheet

Q72. A school stores Term-1 and Term-2 marks on separate worksheets. Why is this approach useful?
a) It reduces spreadsheet size.
b) It organizes information systematically for each examination.
c) It automatically calculates grades.
d) It prevents formulas from being edited.

Q73. Before entering any formula in LibreOffice Calc, it must begin with:
a) #
b) =
c) @
d) $

Q74. To calculate the total marks obtained from Term-1 and Term-2, which function is most appropriate?
a) COUNT()
b) SUM()
c) MAX()
d) ROUND()

Q75. If the marks of a student are corrected in the Term-1 worksheet, what happens to the linked formula in the Result worksheet?
a) It displays an error.
b) It updates automatically.
c) It remains unchanged.
d) It is deleted.

Q76. While creating a reference to another worksheet, the sheet name is preceded by the symbol:
a) #
b) $
c) @
d) %

Q77. If a worksheet name contains spaces, it should be enclosed within __________ while creating a reference.
a) Parentheses ()
b) Double quotation marks “”
c) Single quotation marks ”
d) Square brackets []

Q78. Consider the following reference:

$'Term 1'.C4

Here, C4 represents:
a) The workbook name
b) The worksheet name
c) The cell address
d) The formula name

Q79. Which of the following is the biggest advantage of linking data instead of manually copying it?
a) It increases workbook size.
b) It eliminates repeated data entry and keeps information synchronized.
c) It protects worksheets automatically.
d) It converts formulas into values.

Q80. LibreOffice Calc allows users to create references not only within the current workbook but also to:
a) Audio files
b) Other spreadsheet documents
c) Presentation slides
d) Image files

Q81. A company maintains quarterly sales data in separate spreadsheet files. The manager wants to prepare a single report that always reflects the latest data from all files. Which approach is most suitable?
a) Copy and Paste Special
b) Create links to the source spreadsheet documents
c) Merge all files into one manually
d) Convert every spreadsheet into a PDF

Q82. Assertion (A): Linking spreadsheet data improves the accuracy of reports.

Reason (R): Changes made in the source data are automatically reflected in the linked worksheet.

a) Both A and R are true, and R is the correct explanation of A.
b) Both A and R are true, but R is not the correct explanation.
c) A is true, but R is false.
d) A is false, but R is true.

Q83. Which of the following is the biggest advantage of linking spreadsheet data?
a) It reduces storage space.
b) It automatically reflects changes made in the source data.
c) It converts formulas into values.
d) It encrypts the spreadsheet.

Q84. Which feature minimizes typing mistakes while preparing consolidated results?
a) Linking Spreadsheet Data
b) Spell Check
c) Goal Seek
d) Scenario

Q85. The first step before creating references between sheets is to:
a) Create the required worksheets
b) Delete existing worksheets
c) Create a chart
d) Protect the workbook

Q86. Which LibreOffice Calc feature is most suitable for preparing a final result sheet using marks stored in multiple worksheets?
a) Macro
b) Linking Spreadsheet Data
c) Goal Seek
d) Subtotal

Q87. Which of the following is NOT a data analysis feature discussed in the chapter?
a) Consolidate
b) Goal Seek
c) Macro
d) Mail Merge

Q88. Which feature is most suitable for combining sales data from different branches into one worksheet?
a) Scenario
b) Consolidate
c) Goal Seek
d) Macro

Q89. A company wants to compare profits under different selling prices without changing the original data repeatedly. Which feature should it use?
a) Scenario
b) Subtotal
c) Linking Spreadsheet Data
d) Group and Outline

Q90. A teacher wants to calculate the marks required by a student in the final exam to score an overall average of 75%. Which feature should be used?
a) Consolidate
b) Goal Seek
c) Macro
d) Subtotal

Q91. A user frequently formats table headings in the same way in different worksheets. Which feature will save the maximum time?
a) Consolidate
b) Macro
c) Scenario
d) Subtotal

Q92. To prepare a final report using marks stored in different worksheets, the most appropriate feature is:
a) Linking Spreadsheet Data
b) Scenario
c) Goal Seek
d) Group and Outline

Q93. Which feature automatically updates the destination worksheet whenever the source data changes?
a) Link to Source Data
b) Goal Seek
c) Scenario
d) Macro Recorder

Q94. Which feature allows the user to hide detailed rows while displaying only summary information?
a) Group and Outline
b) Macro
c) Goal Seek
d) Scenario

Q95. Which feature is mainly used to summarize grouped records using functions like Sum or Average?
a) Linking Spreadsheet Data
b) Scenario
c) Subtotal
d) Macro

Q96. Which feature works by changing input values to observe different outputs?
a) What-if Analysis
b) Group and Outline
c) Consolidate
d) Macro

Q97. Goal Seek is considered a:
a) Forward analysis tool
b) Backward analysis tool
c) Formatting tool
d) Linking tool

Q98. Which feature reduces manual effort by executing a sequence of recorded commands?
a) Macro
b) Consolidate
c) Subtotal
d) Scenario

Q99. Which of the following tools is NOT used for What-if Analysis?
a) Scenario
b) Multiple Operations
c) Goal Seek
d) Consolidate

Q100. Which feature is most useful when preparing a summary from multiple worksheets having similar data?
a) Consolidate
b) Goal Seek
c) Macro
d) Scenario

Q101. Which feature is most appropriate for viewing different loan repayment plans by changing the repayment period?
a) Scenario
b) Linking Spreadsheet Data
c) Group and Outline
d) Macro

Q102. Which feature should be used if the desired output is already known but the required input value is unknown?
a) Consolidate
b) Scenario
c) Goal Seek
d) Macro

Q103. Which feature helps organize large worksheets into expandable and collapsible sections?
a) Group and Outline
b) Scenario
c) Linking Spreadsheet Data
d) Goal Seek

Q104. A school stores marks of each term in separate worksheets and prepares the final result in another worksheet. This is an example of:
a) Goal Seek
b) Linking Spreadsheet Data
c) Subtotal
d) Macro Recording

Q105. Which feature is best suited for automating repetitive formatting tasks?
a) Macro
b) Consolidate
c) Goal Seek
d) Scenario

Q106. Which data analysis feature combines values from multiple ranges into a single result?
a) Consolidate
b) Goal Seek
c) Linking Spreadsheet Data
d) Scenario

Q107. Which of the following features is mainly used for decision-making by comparing different possibilities?
a) Scenario
b) Macro
c) Group and Outline
d) Linking Spreadsheet Data

Q108. Which feature is useful when users need to repeatedly perform the same set of operations?
a) Goal Seek
b) Macro
c) Consolidate
d) Subtotal

Q109. Which feature allows formulas in one worksheet to use values stored in another worksheet?
a) Linking Spreadsheet Data
b) Group and Outline
c) Scenario
d) Goal Seek

Q110. Which feature is best suited for calculating totals of grouped categories such as department-wise sales?
a) Subtotal
b) Goal Seek
c) Macro
d) Scenario

Q111. Which combination of LibreOffice Calc features is mainly used for data analysis and decision-making in this chapter?
a) Consolidate, Scenario, Goal Seek, Macro, Linking Spreadsheet Data
b) Spell Check, Mail Merge, Track Changes, AutoCorrect
c) Header, Footer, Print Preview, Page Break
d) Draw, Impress, Base, Math