Class 9 IT Chapter- Electronic Spreadsheet Important MCQs - 3

Class 9 IT (402) Complete Solution

CBSE Class 9 Information Technology (402)
Important MCQs - 3
Chapter - Electronic Spreadsheet

1. _____ produces the largest value from the given range of cells.

A) MAX()
B) LARGEST()
C) BIG()
D) HIGHEST()

... Answer is A) MAX()

2. _____ is the text alignment in worksheet.

A) Left Alignment
B) Right Alignment
C) Middle Alignment
D) All of these

... Answer is D) All of these

3. ____ option wraps the words in multiple lines to accommodate the words within the cell.

A) Shrink Text
B) Text Orientation
C) Wrap Text
D) Fit Text

... Answer is C) Wrap Text

4. _____ option helps to rotate the direction of text in a cell.

A) Angle Text
B) Change Direction
C) Text Angle
D) Text Orienation

... Answer is D) Text Orienation

5. In ____ formula is copied to other cell. It changes cell reference according to its value.

A) Mixed Cell Reference
B) Absolute Cell Reference
C) Relative Cell Reference
D) Fixed Cell Reference

... Answer is C) Relative Cell Reference

6. In ____ formula is copied to other cell. It doesn't change cell reference according to its value.

A) Absolute Cell Reference
B) Fixed Cell Reference
C) Constant Cell Reference
D) Permanent Cell Reference

... Answer is A) Absolute Cell Reference

7. ____ is the combination of relative and absolute cell reference in worksheet.

A) Normal Cell Reference
B) Common Cell Reference
C) Both Cell Reference
D) Mixed Cell Reference

... Answer is D) Mixed Cell Reference

8. ______ automatically adds range of given cells in a worksheet.

A) Auto Add
B) Auto Sum
C) Auto Fill
D) Auto Plus

... Answer is B) Auto Sum

9.In ____ a certain kind of predefined series of data such as name of month, year, or serial number automatically generated.

A) Auto Give
B) Auto Generate
C) Auto Fill
D) Auto Create

... Answer is C) Auto Fill

10. _____ is the graphical presentation of data series in a worksheet.

A) Object
B) Chart
C) Picture
D) Diagram

... Answer is B) Chart

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

Class 9
Chapter  - Electronic Spreadsheet MCQs

•  MCQs - 1
•  MCQs - 2
•  MCQs - 3 
•  MCQs - 4
  

    

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

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

 Class 9 IT (402) MCQs

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 – Introduction to IT - ITeS Industries
Chapter 2–  Data Entry & Keyboard Skills
Chapter 3 – Digital Documentation
Chapter 4 – Electronic Spreadsheet
Chapter 5 – Electronic Presentation

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

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

 Class 9 IT (402) Notes

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 – Introduction to IT - ITeS Industries
Chapter 2–  Data Entry & Keyboard Skills
Chapter 3 – Digital Documentation
Chapter 4 – Electronic Spreadsheet
Chapter 5 – Electronic Presentation

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