Class 9 IT Chapter- Electronic Spreadsheet Important MCQs - 2

Class 9 IT (402) Complete Solution

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

1. _____ is created by user to perform a calculation in a Worksheet.

A) Function
B) Formula
C) Calculation
D) Maths Operator

... Answer is B) Formula

2. _____ symbol is used before creating a formula or function.

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

... Answer is A) =

3. ____ is the inbuilt formula in MS Excel.

A) Formula
B) Function
C) Calculator
D) Equation

... Answer is B) Function

4. _____ are the symbols that performs certain mathematical or logical operations in a worksheet.

A) Sign
B) Symbols
C) Operators
D) Expression

... Answer is C) Operators

5. ____ produces the sum of the number for a range of cells in a worksheet.

A) SUM()
B) ADD()
C) JOIN()
D) AUTOADD()

... Answer is A) SUM()

6. _____ function produces the current date and contains no argument.

A) TIME()
B) DAY()
C) DATE()
D) TODAY()

... Answer is D) TODAY()

7. ____ is the example of Logical Function in MS Excel.

A) AND
B) OR
C) IF
D) All of these

... Answer is D) All of these

8. ______ error occurs when a cell reference is not valid.

A) #VALUE
B) #NUM
C) #REF!
D) ####

... Answer is C) #REF!

9. ______ error occurs when MS Excel doesn't recognize text in a formula.

A) #NAME
B) #VALUE
C) #DIV/0!
D) #NUM

... Answer is A) #NAME

10. _____ error occurs when cell contains data that is wider than a cell.

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

... Answer is C) ####

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

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

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