Class 10 IT | Chapter- Spreadsheet | Important MCQs - 3

 Class 10 IT (402) Complete Solution

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

1. _______ provides a way to combine data from same or multiple worksheet.

A) Subtotal
B) Consolidate
C) Solver
D) All of these

... Answer is B) Consolidate

2. In ____ tag the consolidate option is available in Open Office Calc.

A) Data Tab
B) Tool Tab
C) Insert Tab
D) Formula Tab

... Answer is A) Data Tab

3. ____ is the by default function in consolidating data in Open Office Calc.

A) Min
B) Product
C) Average
D) Sum

... Answer is D) Sum

4. ______ function is not available in consolidating data in Open Office Calc.

A) Count
B) Average
C) Product
D) Percentage

... Answer is D) Percentage

5. ____ option is not present in more options in consolidating data in Open Office Calc.

A) Row Lables
B) Headings
C) Column Lables
D) Link to data source

... Answer is B) Headings

6. ____ symbol is used before writting a formuls in Open Office Calc.

A) &
B) %
C) =
D) @

... Answer is C) =

7. ____ is used to automatically create groups and apply inbuilt function in Open Office Calc.

A) Consolidate
B) Subtotal
C) Autosum
D) None of these

... Answer is B) Subtotal

8. In ____ tag subtotal option is available in Open Office Calc.

A) Data Tab
B) Tool Tab
C) Function Tab
D) Insert Tab

... Answer is A) Data Tab

9. ____ is the by default function in Subtotal in Open Office Calc.

A) Sum
B) Product
C) Average
D) Percentage

... Answer is A) Sum

10. ____ function is not present in subtotal in Open Office Calc.

A) Subtract
B) Count
C) Max
D) Average

... Answer is A) Subtract

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

Chapter  - Spreadshet

•  MCQs - 1
•  MCQs - 2
•  MCQS - 3
  

 

    

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

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

MCQs of All Chapters Class 10 IT (402) 

Class 10 IT (402) Important 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

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

Sample Paper of Class 10 IT 402

CBSE Class 10 IT (402) Sample Paper

• IT (402) Sample Paper 2020 - 21
  
• IT (402) Sample Paper 2021 - 22
• IT (402) Sample Paper 2021 - 22
• IT (402) Sample Paper 2022 - 23
• IT (402) Sample Paper 2022 - 23  
• IT (402)Sample Paper 2022 - 23

 

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

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

Sample Paper of Class 10

• English Sample Paper 2022 - 23
  
• Hindi A Sample Paper 2022 - 23
• Maths (Standard) Sample Paper 2022 - 23
• Maths (Basic) Sample Paper 2022 - 23
• Science Sample Paper 2022 - 23  
• Social Science Sample Paper 2022-23

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