In this post, we have shared Electronic Spreadsheet MCQ-type questions for class 10 Information Technology Code 402. IT code 402 Unit 2 – Electronic Spreadsheet MCQ Questions PDF.

Here we have arranged some important 1 marker questions for Class 10 IT 402 unit 2 – Electronic Spreadsheet. These MCQ-type questions for CBSE Class 10 IT 402 – Electronic Spreadsheet are important for term 1 exam 2021.
This unit of the spreadsheet is explained in the video below so you can study this first and then jump into the Electronic Spreadsheet MCQ-type questions. Answers are at the end of this post.
ELECTRONIC SPREADSHEET MCQs
- _________ allows you to gather together your data from separate worksheets into a master worksheet.
Options:
Styles | Data Tool |
Data Consolidation | None of these |
- _________ is a function listed under the Mathematical category when you use the Function Wizard
Options:
Data Consolidation | Subtotal |
Mathematical Function | None of these |
- How to use subtotal?
Options:
Data > Consolidation | Insert > Function |
Insert > Mathematics > Function | None of these |
- Consolidate option is available under the _________ menu.
Options:
View | Tool |
Insert | Data |
- We can consolidate data by ________.
Options:
Row label | Column label |
Both of the above | None of the above |
- Which of the following functions are available in consolidate window?
Options:
Max | Min |
Count | All of the above |
- In which option we have to specify the target range(Where we want the result to be displayed)
Options:
Source data range | Copy results to |
Need result at | target range |
- Scenarios are a tool to test ______ questions.
Options:
What-if | Who |
How-to | None of the above |
- If you select ________ then any values modified in the source range are automatically updated in the target range.
Options:
Link to source data | Link to sheet data |
Link to original data | Link to the source range |
- From where can we find Goal Seek option
Options:
Insert Menu | Target Menu |
View | Tool menu |
- Which of the following options are not visible in tools menu
Options:
Goal Seek | Solver |
Consolidate | Scenarios |
- Range option is available under the ________ menu.
Options:
Data | Tools |
Insert | None of the above |
- We can not insert a new sheet in Spreadsheet by
Options:
Select Insert > Sheet from the menu bar |
Shortcut key Ctrl + Shift + N |
Click in an empty space at the end of the line of sheet tabs |
Right-click on the tab and select Insert Sheet |
- 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 a formula to calculate.
Options:
Data Consolidation | Solver |
Cell Reference | Cell Consolidation |
- The text in the row label or column label must be identical, otherwise, _________ .
Options:
No actions would take place |
Labels will not be shown |
a new row or column will be inserted during data consolidation. |
None of the above |
- In a spreadsheet Numerical value of cell is denoted to
Options:
Column | Block |
Rows | Cell |
- Absolute reference looks like –
Options:
B3 | $B$3 |
B$3 | $B3 |
- What is the format of Open Office Spreadsheet?
Options:
*.odt | *.odf |
*.ods | *.xlsx |
- To create a range, which of the following options is used?
Options:
Insert → Names → Rang |
Insert → Names → Define |
Insert → Range |
None of the above |
Add | OK |
More | Delete |
- Which of the following button is used to define a range after typing name?
Options:
Electronic Spreadsheet True/False
Spreadsheet True/False Questions
- You cannot combine more than one worksheet cell data into different sheets and use the formula. (T/F)
- SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard.
- The function option in consolidate dialog box allows to select the function in the destination cells.
- Scenarios are a tool to test “how-if” questions.
- Once ranges are added to consolidated dialog cannot be deleted.
- Reference option allows you to select the reference from another sheet having data.
- Consolidate means to combine a number of things into a single unit.
- The Source Data range option is used to update the value in consolidated worksheet formula cell automatically when the user changes data in source cell.
- The format of Open Office Calc is *.oss .
- Data can be consolidated from two sheets only.
Electronic Spreadsheet MCQ Solution
- C
- B
- B
- D
- C
- D
- B
- A
- A
- D
- C
- A
- B
- C
- C
- C
- B
- C
- B
- A
Electronic Spreadsheet True/False Solution
- F
- T
- T
- F
- F
- T
- T
- F
- F
- F
Read More –
Class 10 IT 402 TERM 1 SYLLABUS 2021-22
CLASS 10 IT 402 ELECTRONIC SPREADSHEET NOTES
CLASS 10 IT 402 SAMPLE PAPERS PDF 2021-22
So these were the Class 10 IT 402 Unit 2 Electronic Spreadsheet MCQ questions. These Electronic Spreadsheet Mcq questions are very important for board exam 2021-22 basically these Class 10 IT Electronic Spreadsheet MCQ will help you score well in your class 10 IT term 1 board exam 2021.
Share these CBSE Class 10 IT Electronic Spreadsheet MCQ with your friends and also help them score well in their term 1 board exam 2021. Let me know if you also want the class 10 IT Electronic Spreadsheet MCQ PDF.