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

 Class 10 IT (402) Complete Solution

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

1. Which of the following application is not appropriate to store data about ABC Bank customers?

A) Open Office Base
B) MS Access
C) Open Office Writer
D) MS Excel

... Answer is C) Open Office Writer

2. When you open a new spreadsheet, by default, it has a sheet named ________ which is managed using tabs at the bottom of the spreadsheet.

A) Sheet1
B) Untitled1
C) Worksheet1
D) New Sheet

... Answer is A) Sheet1

3. Reviewers and authors can add their ______ to explain their changes in the cell of Spreadsheet.

A) Comments
B) Hyperlink
C) Worksheet
D) Macros

... Answer is A) Comments

4. In Calc, Arguments passed to a macro from Calc are always ___________.

A) Cell Reference
B) Value
C) Both a and b
D) Sheet Reference

... Answer is B) Value

5. In a spreadsheet using to create a hyperlink to a web FTP or Telnet, click on the __________ icon available in Hyperlink dialog box.

A) Browser
B) Hyperlink
C) Internet
D) Mail & News

... Answer is C) Internet

6. 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 formula to calculate.

A) Cell reference
B) Sheet Reference
C) Block
D) Autofill

... Answer is A) Cell reference

7. ________ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.

A) Data Combination
B) Data Consolidation
C) Data Merging
D) Data Concatenation

... Answer is B) Data Consolidation

8. __________ store data in a single table which is suitable to store less amount of Data.

A) Flat File
B) Relational
C) Mini File
D) Single File

... Answer is A) Flat File

9. Which function cannot be performed through Subtotal in a Spreadsheet?

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

... Answer is D) Percentage

10. Scenarios are a tool to test ____ questions.

A) Auto
B) Goal Seek
C) What-if
D) Drop Down

... Answer is C) What-if

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

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

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