Electronic Spreadsheet Class 10 MCQ – The CBSE has changed the previous textbook and the syllabus of Std. X. The new notes are made based on the new syllabus and based on the New NCERT textbook. These notes are made in collaboration with many expert teachers. All the important Information are taken from the Information Technology Class X Textbook Based on CBSE Board Pattern.
The revised syllabus includes LibreOffice in Class 10 instead of OpenOffice.
Electronic Spreadsheet Class 10 MCQ with Answers
Chapter 4 – Analyze Data using Scenarios and Goal Seek
1. What is the extension of a spreadsheet file in Calc?
a. .odb
b. .odt
c. .odg
d. .ods
2. The LibreOffice Calc can perform _.
a. Analysis automate repeated tasks
b. Calc can create link
c. Calc can share and review data
d. All of the above
3. Which of the following software is best for data analysis.
a. LibreOffice Writer
b. LibreOffice Calc
c. LibreOffice Impress
d. None of the above
4. __ is a function which combines data from multiple sheets and summarizes the information in one place.
a. SubTotal
b. Consolidating Data
c. Goal Seek
d. Solver
5. __ compare a variety of data in a single spreadsheet to identify relationships and trends.
a. SubTotal
b. Consolidating Data
c. Goal Seek
d. Solver
6. What we need to check before consolidating data in LiberOffice Calc.
a. Data types must match which you want to consolidate
b. Match the levels from all the sheets
c. First column should be primary column
d. All of the above
7. Which option you will select to open Data Consolidation.
a. Data > Consolidate
b. Insert > Consolidate
c. View > Consolidate
d. None of the above
8. Which function cannot be performed through Subtotal in a Spreadsheet?
a. Sum
b. Product
c. Average
d. Percentage
9. Scenarios are a tool to test questions.
a. Auto
b. Goal Seek
c. What-if
d. Drop Down
10. _ means combining data in a spreadsheet from different worksheets into master worksheet
a. Hyperlinks
b. Consolidating
c. Linking
d. Filter
11. What is the shortcut key used for opening the consolidated dialog window.
a. Ctrl + D
b. Alt + D
c. Shift + D
d. None of the above
12. If you want to consolidate the sheet by matching the label, which option will be helpful in consolidating data.
a. Copy result to
c. Using source data area
c. Row label and Column label
d. None of the above
13. What does “Copy result to” mean when it comes to data consolidation?
a. Specify where you want to display the result
b. Adding all address of consolidation data
c. Insert the formula for finding data consolidation
d. None of the above
14. Which of the following options is used to update the data of the consolidated sheet automatically.
a. Row labels
b. Column labels
c. Link to source data
d. All of the above
15. If you want to consolidate the data by matching the label which option you will select.
a. Row label and Column labels
b. Link to source data
c. Consolidation ranges
d. None of the above
16. The consolidated sheet will have all the consolidated data along with the original data, if you want to view original data of both the sheets then you can click on _.
a. – Sign
b. + Sign
c. * Sign
d. / Sign
17. _________is a spreadsheet function that is designed to minimize or maximize a result based on a set of rules that you describe.
a. Goal Seek
b. Scenario
c. Solver
d. Subtotal
18. In LibreOffice Calc, if you want to collapse to hide data you can click on the _ sign.
a. – Sign
b. + Sign
c. * Sign
d. / Sign
19. In LibreOffice Calc, if you want to expand data you can click on the _ sign.
a. – Sign
b. + Sign
c. * Sign
d. / Sign
20. In LibreOffice Calc, if you want to group the data you can select.
a. Data > Group and Outline
b. View > Group and Outline
c. Insert > Group and Outline
d. None of the above
21. In LibreOffice Calc, the Subtotal tool creates the group of data __.
a. Automatically
b. Manually
c. Using Total function
d. None of the above
22. Which option you will use to open Subtotal in LibreOffice Calc.
a. Insert > Subtotal
b. Data > Subtotal
c. View > Subtotal
d. Edit > Subtotal
23. In LibreOffice Calc Subtotal is used to __.
a. Allows easily to short data automatically
b. Group Subtotal by category
c. Both a) and b)
d. None of the above
24. Subtotal tool can create subtotal for up to _ arrays arranged in Labeled columns.
a. Three
b. Four
c. Five
d. Six
25. Which of the following tools is used to display hierarchical structure of the data.
a. Senario
b. Goal Seek
c. Solver
d. Subtotal
26. In the Subtotal tool data can be sorted in the following order.
a. Ascending Order
b. Descending Order
c. Both a) and b)
d. None of the above
27. If you want to remove the outline feature from the sheet then you can use.
a. Insert > Group and Outline > Remove Outline
b. View > Group and Outline > Remove Outline
c. Data > Group and Outline > Remove Outline
d. None of the above
28. __ is a set of values that can be used within the calculations.
a. Goal Seek
b. Scenario
c. Sub Total
d. None of the above
29. We can shift from one scenario to another by _
a. Navigator
b. Find and Replace
c. Data Source
d. None of the above
30. Default name of first scenario created in Sheet1 of Calc is __
a. Sheet1_Scenario1
b. Sheet1_Scenario_1
c. Sheet_1_Scenario1
d. Sheet_1_Scenario_1
31. Why what-if analysis tool is used in LibreOffice calc.
a. To check the error
b. Depend on different input values and their impact on result
c. To create a style
d. None of the above
32. Which of the following will not be considered as a What-if analysis tool in LibreOffice Calc.
a. Scenario
b. Solver
c. Goal Seek
d. None of the above
33. Which tools used to explore and compare various alternatives depending on changing conditions.
a. Scenario
b. Solver
c. Goal Seek
d. None of the above
34. __ is a more elaborate form of Goal Seek.
a. Scenario
b. Subtotal
c. Solver
d. All of the above
35. In LibreOffice Calc several scenarios can be created on the same sheet. (True/ False)
Show Answer ⟶36. Which of the following tool is used to predict the output while changing the input.
a. Subtotal
b. Consolidation of Data
c. Scenarios
d. None of the above
37. How you will open scenarios dialog box from the menu bar.
a. Data > Scenarios
b. Tools > Scenarios
c. Edit > Scenarios
d. None of the above
38. __ tools creates a formula array to display the list of results.
a. Subtotal
b. Solver
c. Goal Seek
d. Multiple Operation
39. Which of the following tools is also known as a planning tool for what-if questions.
a. Subtotal
b. Solver
c. Goal Seek
d. Multiple Operation
40. How you will open Multiple Operations from the menu bar.
a. Tools > Multiple Operations
b. Edit > Multiple Operations
c. Data > Multiple Operations
d. None of the above
41. The Multiple Operations tool is used to create __ arrays of cells.
a. 2
b. 3
c. 4
d. 5
42. How to open the Goal Seek dialog box from the LibreOffice Calc menu bar.
a. Insert > Goal Seek
b. View > Goal Seek
c. Tools > Goal Seek
d. None of the above
43. __ helps in finding out the input for the specific output.
a. Scenario
b. Solver
c. Goal Seek
d. None of the above
Chapter 5 – Using Macros in Spreadsheet
44. A _ is a single instruction that executes a set of instructions.
a. Solver
b. Macro
c. Goal Seek
d. All of the above
45. _ tools help to create a sequence of commands or keystrokes that can be used for any number of times later.
a. Solver
b. Macro
c. Goal Seek
d. All of the above
46. Macro recording can be enabled using the _ options in LibreOffice Calc.
a. Tools > Macros
b. View > Macros
c. Edit > Macros
d. Data > Macros
47. Which of the following actions is not recorded by the Macro.
a. Opening of windows
b. Window switching
c. Actions carried out using mouse
d. All of the above
48. What is the default name of Macro in LibreOffice Calc.
a. Main
b. New
c. Macro
d. None of the above
49. The name of macro by default is saved in the _.
a. Standard Library in Module 1
b. Use new extension
c. In LibreOffice writer
d. None of the above
50. In LibreOffice Calc, A library is a collection of _.
a. Modules
b. Words
c. Row & Column
d. None of the above
51. While naming a Macro, Module or a Library the name should be __.
a. Begin with a letter
b. Not contain space
c. Not contain special characters except underscore
d. All of the above
52. Which of the following is an invalid Macro Name?
a. 1formatword
b. format word
c. format*word
d. Format_word
53. To run a macro we need to click on __.
a. Tools > Macros > Run Macro
b. View > Macros > Run Macro
c. Edit > Macros > Run Macro
d. Data > Macros > Run Macro
54. If some formula you want to apply in spreadsheet and there is no predefined formula for it, what you will do.
a. Create a Macro
b. Use a manual calculation
c. Create formula
d. None of the above
55. Macro works like a __.
a. Function
b. Operator
c. Parameters
d. None of the above
56. The macro’s recorded activity is stored as instructions in the __ programming language.
a. BASIC
b. C
c. Java
d. DBMS
57. The code of a macro begins with Sub followed by the name of the macro and ends with _.
a. Close Sub
b. End Sub
c. Exit Sub
d. None of the above
Chapter 6 – Linking Spreadsheet Data
58. How you will add comments in the macro programming code.
a. Using single quote
b. Using double slash
c. Using double quote
d. Using Hash
59. To add a new sheet in the spreadsheet, click on the __.
a. (+) sign located in the left button
b. (-) sign located in the left button
c. (+) sign located in the right button
d. (-) sign located in the right button
60. You can insert a new sheet in LibreOffice calc using which of the following menu options.
a. Sheet > Insert Sheet
b. Edit > Insert Sheet
c. View > Insert Sheet
d. All of the above
61. To refer to a cell in another sheet precede the cell reference with __ sign.
a. % Sign
b. $ Sign
c. @ Sign
d. None of the above
62. When the cell refers to the other sheet __ are used as there is a space between the sheet name.
a. ‘ ‘
b. .
c. =
d. *
63. In LibreOffice Calc hyperlink can be either _ or .
a. External Hyperlink or Anchor Hyperlink
b. Alternet Link or Mailto
c. Relative Hyperlink or Absolute Hyperlink
d. None of the above
64. In LibreOffice calc it is possible to jump from one sheet to another spreadsheet or a website by creating __.
a. Linking
b. Using Jump
c. Hyperlinks
d. All of the above
65. _ hyperlink stores the complete location of the file.
a. Relative Hyperlinks
b. Absolute Hyperlinks
c. Both a) and b)
d. None of the above
66. In absolute hyperlink if the file is removed from location to another then absolute hyperlink will _.
a. Work properly
b. Not work
c. Both a) and b)
d. None of the above
67. A __ hyperlink stores the location with respect to current location.
a. Relative Hyperlinks
b. Absolute Hyperlinks
c. Both a) and b)
d. None of the above
68. You can create hyperlinks using which of the following menu bars.
a. Insert > Hyperlink
b. View > Hyperlink
c. Insert > Hyperlink
d. None of the above
69. How can hyperlinks in Calc be used?
a. to jump from one sheet to a website
b. to jump from one section to another section of the same sheet
c. to jump from one sheet to another sheet
d. All of the above
70. To insert the HTML tables data in the LibreOffice Calc, you can use which of the following options.
a. External Data
b. Internal Data
c. Modified Data
d. None of the above
71. Which type of the following Registered Data Sources can be used in LibreOffice Calc.
a. LibreOffice Base
b. MySQL
c. Microsoft Access
d. All of the above
72. The file path of a file has _ forward slash in LibreOffice Calc.
a. Two
b. Three
c. Four
d. One
73. In LibreOffice Calc, one spreadsheet can be used by more than one user with the help of __.
a. Moving
b. Sharing
c. Transfering
d. None of the above
74. Which of the following checkboxes you have to mark checked while sharing the spreadsheet in LibreOffice Calc.
a. Share this spreadsheet with other users
b. Transfer this spreadsheet with other users
c. Moving this spreadsheet with other users
d. None of the above
75. Which feature in LibreOffice Calc provides different ways to record the changes made by one or other users in the spreadsheet.
a. Data protection
b. Merging document
c. Record changes
d. None of the above
76. Which type of style you can apply to format the comment box.
a. Background color
b. Border Style
c. Transparency
d. All of the above
77. In LibreOffice Calc, how you will combine two different versions of the same spreadsheet file.
a. Using Combine
b. Using Merging
c. Using Comparing
d. None of the above
78. In LibreOffice Calc, you can compare the two spreadsheets by using which of the following options.
a. Comparing
b. Merging
c. Combining
d. None of the above
Employability skills Class 10 Notes
- Unit 1- Communication Skills Class 10 Notes
- Unit 2- Self-Management Skills Class 10 Notes
- Unit 3- Basic ICT Skills Class 10 Notes
- Unit 4- Entrepreneurial Skills Class 10 Notes
- Unit 5- Green Skills Class 10 Notes
Employability skills Class 10 MCQ
- Unit 1- Communication Skills Class 10 MCQ
- Unit 2- Self-Management Skills Class 10 MCQ
- Unit 3- Basic ICT Skills Class 10 MCQ
- Unit 4- Entrepreneurial Skills Class 10 MCQ
- Unit 5- Green Skills Class 10 MCQ
Employability skills Class 10 Questions and Answers
- Unit 1- Communication Skills Class 10 Questions and Answers
- Unit 2- Self-Management Skills Class 10 Questions and Answers
- Unit 3- Basic ICT Skills Class 10 Questions and Answers
- Unit 4- Entrepreneurial Skills Class 10 Questions and Answers
- Unit 5- Green Skills Class 10 Questions and Answers
Information Technology Class 10 Notes
- Unit 1- Digital Documentation Class 10 Notes
- Unit 2- Electronic Spreadsheet Class 10 Notes
- Unit 3- RDBMS Class 10 Notes
- Unit 4 – Maintain Healthy Safe and Secure Working Environment Class 10 Notes
Information Technology Class 10 MCQ
- Unit 1- Digital Documentation Class 10 MCQ
- Unit 2- Electronic Spreadsheet Class 10 MCQ
- Unit 3- RDBMS Class 10 MCQ
- Unit 4 – Maintain Health Safety and Security at Workplace Class 10 MCQ
Information Technology Class 10 Questions and Answers
- Unit 1- Digital Documentation Class 10 Questions and Answers
- Unit 2- Electronic Spreadsheet Class 10 Questions and Answers
- Unit 3- RDBMS Class 10 Questions and Answers
Disclaimer: We have taken an effort to provide you with the accurate handout of “Electronic Spreadsheet Class 10 MCQ IT 402“. If you feel that there is any error or mistake, please contact me at anuraganand2017@gmail.com. The above CBSE study material present on our websites is for education purpose, not our copyrights. All the above content and Screenshot are taken from Information Technology Class 10 CBSE Textbook and Support Material which is present in CBSEACADEMIC website, This Textbook and Support Material are legally copyright by 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