Electronic Spreadsheet MCQ with Answers | Class 10 IT Electronic Spreadsheet MCQ

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

  1. _________ allows you to gather together your data from separate worksheets into a master worksheet.
    Options:
StylesData Tool
Data ConsolidationNone of these
The answer sheet is at the end of this post
  1. _________ is a function listed under the Mathematical category when you use the Function Wizard
    Options:
Data ConsolidationSubtotal
Mathematical FunctionNone of these
  1. How to use subtotal?
    Options:
Data > ConsolidationInsert > Function
Insert > Mathematics > FunctionNone of these
  1. Consolidate option is available under the _________ menu.
    Options:
ViewTool
InsertData
  1. We can consolidate data by ________.
    Options:
Row labelColumn label
Both of the aboveNone of the above
  1. Which of the following functions are available in consolidate window?
    Options:
MaxMin
CountAll of the above
  1. In which option we have to specify the target range(Where we want the result to be displayed)
    Options:
Source data rangeCopy results to
Need result attarget range
  1. Scenarios are a tool to test ______ questions.
    Options:
What-ifWho
How-toNone of the above
  1. If you select ________ then any values modified in the source range are automatically updated in the target range.
    Options:
Link to source dataLink to sheet data
Link to original dataLink to the source range
The answer sheet is at the end of this post
  1. From where can we find Goal Seek option
    Options:
Insert MenuTarget Menu
ViewTool menu
  1. Which of the following options are not visible in tools menu
    Options:
Goal SeekSolver
ConsolidateScenarios
  1. Range option is available under the ________ menu.
    Options:
DataTools
InsertNone of the above
  1. 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
  1. 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 ConsolidationSolver
Cell ReferenceCell Consolidation
  1. 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
  1. In a spreadsheet Numerical value of cell is denoted to
    Options:
ColumnBlock
RowsCell 
  1. Absolute reference looks like –
    Options:
B3$B$3
B$3$B3
  1. What is the format of Open Office Spreadsheet?
    Options:
*.odt*.odf
*.ods*.xlsx
  1. To create a range, which of the following options is used?
    Options:
Insert → Names → Rang
Insert → Names → Define
Insert → Range
None of the above
AddOK
MoreDelete
The answer sheet is at the end of this post
  1. Which of the following button is used to define a range after typing name?
    Options:

Electronic Spreadsheet True/False

Spreadsheet True/False Questions

  1. You cannot combine more than one worksheet cell data into different sheets and use the formula. (T/F)
  2. SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard.
  3. The function option in consolidate dialog box allows to select the function in the destination cells.
  4. Scenarios are a tool to test “how-if” questions.
  5. Once ranges are added to consolidated dialog cannot be deleted.
  6. Reference option allows you to select the reference from another sheet having data.
  7. Consolidate means to combine a number of things into a single unit.
  8. 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.
  9. The format of Open Office Calc is *.oss .
  10. Data can be consolidated from two sheets only.

Electronic Spreadsheet MCQ Solution

  1. C
  2. B
  3. B
  4. D
  5. C
  6. D
  7. B
  8. A
  9. A
  10. D
  11. C
  12. A
  13. B
  14. C
  15. C
  16. C
  17. B
  18. C
  19. B
  20. A

Electronic Spreadsheet True/False Solution

  1. F
  2. T
  3. T
  4. F
  5. F
  6. T
  7. T
  8. F
  9. F
  10. 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.