Class 10 It Unit 2 MCQ ELECTRONIC SPREADSHEET (ADVANCED) | IT code 402 Most Important MCQ
This article is for class 10 students who have opted for IT as their skill subject. Here you will get Class 10 It Unit 2 MCQ ELECTRONIC SPREADSHEET (ADVANCED). IT code 402 Most Important MCQ can help you get good grades in your Information Technology exam. I scored 97 in my class 10 IT board paper back in 2023. I have given these MCQs based on my own experience. Use them and improve your basics in the subject. You can also check it on our YouTube channel.
Top 50 Class 10 It Unit 2 MCQ ELECTRONIC SPREADSHEET (ADVANCED)
- Consolidating data in LibreOffice Calc refers to:
A) Deleting duplicate data
B) Combining data from multiple sources into a single summary
C) Sorting data alphabetically
D) Creating charts from data - Which tool is used to create different scenarios in LibreOffice Calc?
A) Data Consolidation
B) Goal Seek
C) Scenario Manager
D) Subtotal - Goal Seek in LibreOffice Calc is used to:
A) Find duplicate values
B) Find specific input values needed to achieve a desired result
C) Sort data automatically
D) Create pivot tables - What-if analysis in spreadsheets helps to:
A) Delete unwanted data
B) Forecast outcomes based on varying inputs
C) Format cells automatically
D) Print reports - Subtotals in LibreOffice Calc are applied to:
A) Individual cells only
B) Data groups to summarize information
C) Entire worksheets
D) Chart data only - The Groups feature in LibreOffice Calc allows you to:
A) Group cells for formatting
B) Organize data into expandable/collapsible sections
C) Create multiple worksheets
D) Link external data - Which of the following is NOT a function of data consolidation?
A) Combining data from multiple sheets
B) Aggregating data using functions like SUM
C) Creating data validation rules
D) Summarizing data from different sources - Scenario Manager in LibreOffice Calc can handle:
A) Only one scenario at a time
B) Multiple scenarios with different input values
C) Chart creation only
D) Data sorting only - The primary purpose of What-if Tools is:
A) Data entry automation
B) Decision-making through analysis of different possibilities
C) Chart formatting
D) Print preview - Which menu contains the Goal Seek option in LibreOffice Calc?
A) Edit menu
B) Tools menu
C) Format menu
D) Insert menu - A macro in LibreOffice Calc is:
A) A large spreadsheet
B) A recorded sequence of commands and actions
C) A type of chart
D) A printing option - To record a macro in LibreOffice Calc, you use:
A) Insert menu
B) Macro Recorder
C) Format menu
D) View menu - The primary benefit of using macros is:
A) Increased file size
B) Automation of repetitive tasks
C) Better print quality
D) Enhanced security - Macros in LibreOffice Calc are written in:
A) JavaScript
B) Python
C) LibreOffice Basic
D) C++ - Which of the following can be automated using macros?
A) Data entry
B) Formatting operations
C) Calculations
D) All of the above - To run an existing macro, you typically use:
A) Ctrl+R
B) Tools menu → Macros
C) F5 key
D) Alt+M - Arguments in macros are used to:
A) Delete the macro
B) Provide input values for dynamic operation
C) Change macro language
D) Increase execution speed - A macro can function as a:
A) Built-in function
B) Chart type
C) Print option
D) File format - Organizing macros involves:
A) Deleting all macros
B) Grouping related macros in modules or libraries
C) Converting macros to charts
D) Printing macro code - Macros can directly access:
A) Only selected cells
B) Any cell in the spreadsheet
C) Only formatted cells
D) Only empty cells - To create a reference to another sheet in LibreOffice Calc, you use:
A) Sheet1.A1
B) Sheet1!A1
C) Sheet1:A1
D) Sheet1#A1 - Multiple sheets in a workbook are useful for:
A) Increasing file size
B) Organizing related data separately
C) Slowing down calculations
D) Reducing functionality - A hyperlink in LibreOffice Calc can link to:
A) Another cell in the same sheet
B) A different sheet
C) An external document
D) All of the above - The difference between relative and absolute hyperlinks is:
A) File size
B) Link destination (internal vs external)
C) Color formatting
D) Font style - To create a reference to another document, you can use:
A) Only keyboard shortcuts
B) Only mouse operations
C) Both keyboard and mouse
D) Neither keyboard nor mouse - External data linking allows you to:
A) Delete external files
B) Import and connect data from external sources
C) Create new file formats
D) Change system settings - Registered data sources refer to:
A) Deleted databases
B) Pre-configured data connections
C) Temporary files
D) Print settings - When editing a hyperlink, you can modify:
A) Only the display text
B) Only the target location
C) Both display text and target location
D) Neither display text nor target location - Sheet references are updated automatically when:
A) The sheet is renamed
B) Data in referenced cells changes
C) The file is saved
D) All of the above - Linking to external data is beneficial for:
A) Reducing file dependencies
B) Real-time data updates from external sources
C) Decreasing functionality
D) Slowing down operations - Sharing a spreadsheet in LibreOffice Calc allows:
A) Multiple users to edit simultaneously
B) Only viewing by others
C) Automatic backup creation
D) File compression - When opening a shared spreadsheet, you can:
A) Only view the content
B) Make changes that are tracked
C) Delete the file
D) Change file permissions - Recording changes in a shared spreadsheet means:
A) Audio recording of user actions
B) Tracking all modifications made to the document
C) Creating backup copies
D) Printing change logs - Comments in LibreOffice Calc can be:
A) Added to cells
B) Formatted with different styles
C) Edited or deleted
D) All of the above - When reviewing changes, you can:
A) Only accept all changes
B) Only reject all changes
C) Accept or reject changes individually
D) Neither accept nor reject - Merging spreadsheets involves:
A) Deleting one spreadsheet
B) Combining changes from multiple versions
C) Creating new spreadsheets
D) Formatting data only - The Track Changes feature helps in:
A) Monitoring who made what changes
B) Reviewing modification history
C) Collaborative editing
D) All of the above - To save a shared spreadsheet, you need to:
A) Use a different file name
B) Follow the same save process with tracking enabled
C) Convert to PDF first
D) Delete sharing settings - Comparing spreadsheets helps to:
A) Identify differences between versions
B) Find errors in calculations
C) Review collaborative changes
D) All of the above - When setting up a spreadsheet for sharing, you should:
A) Enable change tracking
B) Set appropriate permissions
C) Inform collaborators
D) All of the above - LibreOffice Calc is primarily used for:
A) Word processing
B) Electronic spreadsheet operations
C) Database management
D) Presentation creation - The file extension for LibreOffice Calc documents is:
A) .odt
B) .ods
C) .odp
D) .odb - Advanced spreadsheet features are important for Data Entry Operators because:
A) They increase typing speed
B) They enable efficient data analysis and automation
C) They are required by law
D) They reduce computer usage - Which of the following is NOT an advanced feature of LibreOffice Calc?
A) Scenario analysis
B) Macro recording
C) Data linking
D) Image editing - Solver in LibreOffice Calc is used for:
A) Simple calculations
B) Complex optimization problems
C) Data entry
D) Chart creation - Data validation in spreadsheets helps to:
A) Ensure data accuracy and consistency
B) Increase file size
C) Slow down calculations
D) Create charts automatically - The main advantage of using advanced spreadsheet functions is:
A) Reduced functionality
B) Enhanced data analysis capabilities
C) Slower processing
D) Limited collaboration - Collaborative features in LibreOffice Calc include:
A) Sharing and tracking changes
B) Adding and reviewing comments
C) Merging different versions
D) All of the above - Automation in spreadsheets through macros helps:
A) Reduce repetitive manual tasks
B) Ensure consistency in operations
C) Save time and reduce errors
D) All of the above - Advanced data analysis features in LibreOffice Calc are essential for:
A) Basic data entry only
B) Making informed business decisions
C) Decorating spreadsheets
D) Increasing file complexity
ANSWER KEY – Class 10 It Unit 2 MCQ ELECTRONIC SPREADSHEET (ADVANCED)
1. B 2. C 3. B 4. B 5. B 6. B 7. C 8. B 9. B 10. B
11. B 12. B 13. B 14. C 15. D 16. B 17. B 18. A 19. B 20. B
21. A 22. B 23. D 24. B 25. C 26. B 27. B 28. C 29. D 30. B
31. A 32. B 33. B 34. D 35. C 36. B 37. D 38. B 39. D 40. D
41. B 42. B 43. B 44. D 45. B 46. A 47. B 48. D 49. D 50. B
