Class 10 IT | Chapter - Sreadsheet | Important MCQs - 1

Class 10 IT (402) Complete Solution

CBSE Class 10 Information Technology (402)
Important MCQs
Chapter - Spreadsheet

1. What is refered to the collection and the integration of data from multiple worksheets or workbooks into a single worksheet?

A) Consolidating Data
B) Sorting Data
C) Subtotal
D) Combine Data

... Answer is A) Consolidating Data

2. This is used to automatically create groups and apply inbuilt functions like SUM, COUNT, AVERAGE to summarize data.

A) Analysis
B) Subtotal
C) Total Data
D) Scenaio

... Answer is B) Subtotal

3. Which tab gives consolidating data option in open office Calc?

A) File Tab
B) View Tab
C) Data Tab
D) Edit Tab

... Answer is C) Data Tab

4. Which function isn't available in consolidating data?

A) Sum and Count
B) Max and Min
C) Average and Product
D) Percentage

... Answer is D) Percentage

5. Which option isn't present in more button in consolidating data?

A) Header and Footer
B) Link to source Data
C) Column Lable
D) Row Label

... Answer is A) Header and Footer

6. In which tab subtotal option is available in open office Calc?

A) File Tab
B) Edit Tab
C) View Tab
D) Data Tab

... Answer is D) Data Tab

7. Which function isn't available in subtotal in open office Calc?

A) Max and Min
B) Sum and Count
C) Average and Product
D) Percentage

... Answer is D) Percentage

8. Which option is used to make a group of items in subtotal?

A) Group By
B) Join By
C) Add By
D) Collect By

... Answer is A) Group By

9. In which tab scenario option is available in open office Calc?

A) File Tab
B) Data Tab
C) Tools Tab
D) Window Tab

... Answer is C) Tools Tab

10. Which tool is used to test 'what if' question?

A) Solver Tool
B) Goal Seek
C) Subtotal Tool
D) Scenario Tool

... Answer is D) Scenario Tool

--------------------------------------------------

Chapter  - Spreadshet

•  MCQs - 1
•  MCQs - 2

 

    

------------------------------------------------

MCQs of All Chapters Class 10 IT (402) 

Class 10 IT (402) MCQs Questions

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

 

Part - B 

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 –  Database Management System
Chapter 4 –Web Application

 Chapters of Class 10  IT (402) Solution

Class 10 IT (402) Question Answer

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

 

Part - B 

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 –  Database Management System
Chapter 4 –Web Application