Best 100+ Electronic Spreadsheet Class 9 MCQ with Answers IT 402

Electronic Spreadsheet Class 9 MCQ with Answers

Electronic Spreadsheet Class 9 MCQ with Answers

Q1. Q1. Which of the following help us to perform various calculations?

a. Writer

b. Spreadsheet

c. Impress

d. None of the above

Q2. Spreadsheet is used for :

a. Managing financial and accounting documents.

b. Creating data reports.

c. Data analysis

d. All of the above.

Q3. Spreadsheet packages also provide built-in _______ formulae

a. Mathematical

b. Statistical

c. Both of the above

d. None of the above

Q4. Which of the following is not a Spreadsheet Software?

a. Microsoft Excel

b. LibreOffice Calc

c. OpenOffice Calc

d. None of the above

Q5. In _____________ Operating System, the LibreOffice gets installed by default.

a. Windows

b. Linux (Ubuntu)

c. Both of the above

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

Electronic Spreadsheet Class 9 MCQ with Answers

Q6. Method to open LibreOffice Calc in Windows is :

a. Double click the shortcut of LibreOffice Calc on desktop

b. Click the window menu, select LibreOffice application, then click LibreOffice Calc

c. Both of the above

d. None of the above

Q7. Quick Access Tool bar icon is present on ________

a. Menu Bar

b. Standard Tool bar

c. Title bar

d. Status bar

Q8. Default name of spreadsheet open in LibreOffice Calc is _______

a. Untitled X, where X is a number

b. Calc X, where X is a number

c. Spreadsheet X, where X is a number

d. None of the above

Q9. In LibreOffice Calc Scroll bar is present on ______ and __________ side of window

a. left, right

b. right, top

c. bottom, right

d. top , bottom

Q10. By default _____________ sheets is/are present in LibreOffice Calc Spreadsheet.

a. 1

b. 2

c. 3

d. 4

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Q11. In LibreOffice Calc, Row headings are in ________________

a. Numbers

b. Alphabets

c. Alphanumeric

d. None of the above

Q12. _____________ contains the menus with commands for various tasks.

a. Status bar

b. Standard Tool bar

c. Formatting Tool bar

d. Menu bar

Q13. ___________________ is located just below the Title bar.

a. Standard Tool bar

b. Menu bar

c. Formatting Tool bar

d. None of the above

Q14. ____________ is the shortcut to exit LibreOffice.

a. Ctrl + Q

b. Ctrl + E

c. Ctrl + X

d. None of the above

Q15. Cut, Copy, Paste options are available in ________ menu.

a. File

b. Edit

c. Format

d. View

Electronic Spreadsheet Class 9 MCQ with Answers

Q16. Insert Cells, Insert Rows, Insert Columns options are available in __________ menu.

a. File

b. Insert

c. Sheet

d. Data

Q17. Placing the mouse cursor over any icon displays a small box called _________________ which gives a brief explanation of the icon.

a. Toolbar

b. Toolbox

c. Tooltip

d. All of the above

Q18. _______ shows the address of Active Cell.

a. Name Box

b. Current Cell

c. Formula bar

d. None of the above

Q19. The Worksheet in Calc is also referred to as __.

a. Workbook

b. Spreadsheet

c. Sheet

d. None of the above

Q20. Columns are ________ in the table.

a. Horizontal

b. Vertical

c. Diagonal

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Q21. Column Heading of 27th Column in Calc sheet is ______________

a. AA

b. AB

c. Z

d. ZA

Q22. The intersection of a row and column is called _________.

a. Cell Address

b. Cell

c. Point of intersection

d. None of the above

Q23. Which of the following is invalid Cell Address?

a. A1

b. Z247

c. 91A

d. None of the above

Q24. Which of the following is not true about Currently Selected Cell?

a. Currently Selected cell is called Active cell

b. Currently Selected Cell’s Address is visible in Name box.

c. Currently Selected Cell have thick border.

d. None of the above

Q25. Address of cell formed by intersection of tenth column and nineteenth row is _______________

a. K19

b. 19K

c. J19

d. 19J

Electronic Spreadsheet Class 9 MCQ with Answers

Q26. Cell address of first row and first column _________

a. A1

b. 1A

c. A-1

d. None of the above

Q27. Which key combination moves the active cell (Selected Cell) to the end of the data range in a particular direction?

a. Ctrl + Home

b. Ctrl + End

c. Ctrl + Arrow keys

d. None of the above

Q28. Which key combination moves the active cell (Selected Cell) to A1 cell?

a. Ctrl + Home

b. Ctrl + End

c. Ctrl + Arrow keys

d. None of the above

Q29. Which key / key combination moves the worksheet one screen up?

a. Ctrl + Up Arrow Key

b. Ctrl + Page Up

c. Page Up

d. None of the above

Q30. A block of adjacent cells in a worksheet which is highlighted or selected is called _____________

a. Block of cells

b. Range of Cells

c. Both of the above

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Q31. Range of cell C2 : C7 includes _______ cells

a. 4

b. 5

c. 6

d. 7

Q32. C3 : F3 is an example of ___________

a. Column range

b. Row range

c. Row and Column range

d. None of the above

Q33. Cell Range A1:D3 consist of ___________ cells.

a. 3

b. 4

c. 12

d. 10

Q34. ________ key is used to select more than one ‘range of cells’ in a worksheet.

a. Ctrl

b. Shift

c. Alt

d. None of the above

Q35. What is the address of the first cell represented by Range D34 : F40?

a. F40

b. D34

c. D40

d. F34

Electronic Spreadsheet Class 9 MCQ with Answers

Q36.In LibreOffice Calc, _________ is any text entered by using a keyboard.

a. Values

b. Poster

c. Label

d. None of the above

Q37. By default labels are _________ aligned.

a. left

b. right

c. top

d. None of the above

Q38. The data consisting of only numbers are called _______

a. Labels

b. Values

c. Functions

d. None of the above

Q39. By default Values are _______ aligned.

a. Top

b. Right

c. Left

d. None of the above

Q40. Any expressions that begins with an equals ‘=’ is treated as _________.

a. Function

b. Formula

c. Both of the above

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Q41. LibreOffice Calc uses _____________ operator for division.

a. //

b. \

c. /

d. None of the above

Q42. Which of the following symbol is used for exponentiation(power) in LibreOffice Calc?

a. **

b. /*

c. ^

d. None of the above

Q43. Evaluate the following formula:

= (5*4)^2

a. 40

b. 80

c. 400

d. None of the above

Q44. Evaluate the following formula :

= 16/(4^2)

a. 0

b. 1

c. 16

d. 8

Q45. Evaluate the following formula :

=1+2^2-2

a. 1

b. 2

c. 3

d. 4

Electronic Spreadsheet Class 9 MCQ with Answers

Q46. Which operator in the given expression has the highest priority?

=5+6*2^2

a. +

b. ^

c. *

d. None of the above

Q47. Which of the following operator has the highest priority?

a. ( )

b. *

c. ^

d. +

Q48. If we forgot to put the ‘=’ before the formula, it will be treated as a ____________

a. Value

b. Function

c. Label

d. None of the above

Q49. When we enter an equal sign (‘=’) in any cell, then ____________ bar gets activated automatically.

a. Formula

b. Formatting

c. Menu

d. None of the above

Q50. Which of the following is a valid way of writing formula ?

a. F2 = B1 + C1

b. =B1 + C1

c. Both of the above

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Q51. Rename sheet option is available in ________ menu.

a. File

b. Edit

c. Format

d. Sheet

Q52. Extension of LibreOffice Calc file is ______

a. .ods

b. .xls

c. .odx

d. None of the above

Q53. To insert the column before any column select ___

a. Sheet → Insert Columns → Columns left

b. Sheet → Insert Columns → Columns right

c. Sheet → Insert Columns → Columns

d. None of the above

Q54. When we drag a formula, address of the cell used in formula will automatically change.(T/F)

a. True

b. False

Q55. Evaluate the following expression, if cell A1, B1 and C1 has values 10, 20 and 30 respectively.

=A1 * B1 – C1

a. 170

b. 100

c. -170

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

Q56. Evaluate the following expression, if cell A1, B2, C2 and D3 has values 10, 2, 3, 36.

=(D3/(A1+B2))^C2

a. 64

b. 216

c. 27

d. 125

Q57. _________________ is the function in LibreOffice Calc to get the sum of range of cells.

a. ADD( )

b. SUM( )

c. Both of the above

d. None of the above

Q58. Which of the following will return the sum of Cell A1 to E1.

a. =SUM(A1 : E1)

b. =(A1 + B1 + C1 + D1 + E1)

c. =SUM(A1,B1,C1,D1,E1)

d. All of the above

Q59. Which of the following is a formula ?

= D2+D3+D4+D5+D6+D7 –—- A

= A1 + B1 + SUM (D2:D7) —— B

a. Only A

b. Only B

c. Both A and B

d. None of the above

Q60. Which of the following function calculate the average in LibreOffice Calc?

a. AVG( )

b. AVERAGE( )

c. Both of the above

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Do all questions from(61 to 70) by considering the following sheet.

Q61. Write the formula in E2 to find the total marks scored by HARMAN

a. =B2 + C2 + D2

b. =SUM(B3 : D3)

c. = B2 : D2

d. All of the above

Q62. When you drag the formula =B2 + C2 + D2 from E2 to E4, then the formula becomes :

a. =B3 + C4 + D5

b. =B3 + C3 + D3

c. =B4 + C4 + D4

d. Remain Same

Q63. When you drag the formula =B2 + C2 + D2 from E2 to G2, then the formula becomes :

a. =D2 + E2 + F2

b. =C2 + D2 + E2

c. =E2 + F2 + G2

d. Remain Same

Q64. Write the formula/function in cell B7 to find the highest score in Hindi.

a. =maximum(B2:B6)

b. =max(B2:B6)

c. =max(B1:B6)

d. None of the above

Q65. Write the formula/function in cell B8 to find the total number of students who appeared in Hindi?

a. =counter(B2 : B6)

b. =count(B2 : B6)

c. =counter(B2 : B7)

d. =count(B2 : B7)

Electronic Spreadsheet Class 9 MCQ with Answers

Q66. Write the formula/function in cell B9 to find the lowest score in Hindi.

a. =min(B2 : B6)

b. =min(B2, B3, B4, B5, B6)

c. Both of the above

d. =minimum(B2 : B6)

Q67. Write formula in cell E2 to calculate the percentage of Herman.(All marks are out of 100)

a. = sum(B2 : D2)/300 * 100

b. = sum(B2 : D2)/3

c. Both of the above

d. None of the above

Q68. Write formula in cell F4 to calculate average marks of Riya.

a. =B4 + C4 + D4 /3

b. =(B4 + C4 + D4 )/3

c. Both of the above

d. None of the above

Q69. Write formula in G5 to calculate the highest marks of Aviral.

a. =max(B6 + C6 + D6)

b. =max(B2 : B6)

c. =max(B5 + C5 + D5)

d. None of the above

Q70. Write formula in cell A7 to count the number of students.

a. =Count(A2 : A6)

b. =Count(A2 : A7)

c. =Count(A2 : A5)

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Do all questions from(71 to 80) by considering the following sheet.

Q71. Write the output of =SUM (A1,B1,C1)

a. 15

b. 16

c. 17

d. 18

Q72. Write the output of =SUM(A1:C1,B2)

a. 24

b. 25

c. 26

d. 27

Q73. Write the output of =AVERAGE (A1:C1)

a. 5.55

b. 5.66

c. 6.5

d. 6.66

Q74. Write the output of =AVERAGE (A1:A3,C1:C3)

a. 6

b. 6.5

c. 6.16

d. 6.2

Q75. Write the output of : =MAX(A1,B1:C2)

a. 7

b. 8

c. 5

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

Q76. Write the output of : =MIN(A2:C2,B3)

a. 5

b. 4

c. 7

d. 8

Q77. Write the output of : =COUNT(A1:C1,B2)

a. 3

b. 4

c. 5

d. 2

Q78. Write the output of : =COUNT(A1:A3,C1:C3)

a. 2

b. 4

c. 6

d. 8

Q79. Write the output of : =SUM(B1:C2)

a. 22

b. 23

c. 24

d. 25

Q80 Write the output of : =MIN(A1,B2,C1)

a. 3

b. 4

c. 5

d. 6

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Q81. Which of the following formula will calculate area of square (side = 9)

a. =9 * 9

b. = 9 ^ 2

c. Both of the above

d. None of the above

Q82. When the values of the cells mentioned in the formula changes then results obtained from a formula also get updated automatically.(T/F)

a. True

b. False

Q83. Format cell dialog box can be opened by _____

a. Selecting Cell option from Format menu

b. Selecting Format cell option from the context menu opened through right clicking the cell

c. Both of the above

d. None of the above

Q84. Shortcut to open Format Cell dialog box is __

a. Ctrl + F2

b. Ctrl + F3

c. Ctrl + F7

d. Ctrl + 1

Q85. In _________________ tab of Format cell dialog box, we can specify the number of decimal places.

a. Borders

b. Background

c. Numbers

d. Font

Electronic Spreadsheet Class 9 MCQ with Answers

Q86. Which of the following alignment is not available in LibreOffice Calc?

a. Left

b. Right

c. Justified

d. Centre

Q87. Shortcut of Centre Alignment in LibreOffice Calc is _____

a. Ctrl + L

b. Ctrl + E

c. Ctrl + J

d. Ctrl + C

Q88. Shortcut of Left Alignment in LibreOffice Calc is _____

a. Ctrl + R

b. Ctrl + T

c. Ctrl + L

d. Ctrl + C

Q89. _____________ tool is used to fill the next cells till you drag it with the next predefined value.

a. Fill Handle

b. Fill

c. Fill Series

d. None of the above

Q90. Fill handle of a cell is the small black square appears in the ________ corner of the selected cell.

a. Bottom-right

b. Bottom-left

c. Top-right

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Q91. There are ____________ types of referencing in LibreOffice Calc.

a. 1

b. 2

c. 3

d. 4

Q92. =A1 + B1 is an example of ______ referencing.

a. Absolute

b. Relative

c. Mixed

d. None of the above

Q93. When you drag any formula in any row or column in any direction, the formula changes accordingly. This is a type of ____________referencing.

a. Relative

b. Absolute

c. Mixed

d. None of the above

Q94. When the formula =C2 * D2 is dragged from cell E2 to E6 then the formula in cell E6 will be ______

a. =G2 * H2

b. =C6 * D6

c. =C2 * D6

d. =G2 * H6

Q95. When the formula =C2 * D2 is dragged from cell E2 to G2 then the formula in cell G2 will be ______

a. =C4 * D4

b. =E2 * F2

c. =F2 * G2

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

Q96. To view the formula used in a cell select _________________

a. Insert > Show Formula

b. Edit > Show Formula

c. Sheet > Show Formula

d. View > Show Formula

Q97. C$14. This is an example of __________________ referencing.

a. Absolute

b. Relative

c. Mixed

d. None of the above

Q98. When the formula = H2 + C$14 is dragged from cell J2 to J11 then the formula in cell J11 will be ________

a. =H11 + C$14

b. =H11 + C$25

c. =H2 + C$14

d. None of the above

Q99. Which of the following symbol is used in referencing, to freeze a column or a row.

a. #

b. :

c. $

d. @

Q100. A _________referencing is a referencing in which one cell address name is variable and one cell address is constant.

a. Absolute

b. Relative

c. Mixed

d. None of then above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

Electronic Spreadsheet Class 9 MCQ with Answers

Q101. When you drag formula = A$7 downward then __

a. Only row number will changes

b. Only column heading will changes

c. Both row number and column heading will change

d. None of the above

Q102. When you drag formula = A$7 towards right then _______

a. Only row number will changes

b. Only column heading will changes

c. Both row number and column heading will change

d. None of the above

Q103. Which of the following is an example of absolute referencing?

a. $A$1

b. $A1$

c. Both of the above

d. None of the above

Q104. In which of the following referencing, the cell address remains unchanged even after dragging in any direction?

a. Mixed

b. Relative

c. Absolute

d. None of the above

Q105. Which of the following chart is/are available in LibreOffice Calc?

a. XY Scatter Chart

b. Column Chart

c. Line Chart

d. All of the above

Electronic Spreadsheet Class 9 MCQ with Answers

Q106. Which of the following chart shows values as circular sectors of the total circle?

a. Bar Chart

b. Circular Chart

c. Oval Chart

d. Pie Chart

Q107. Chart option is available in _________ menu.

a. Insert

b. Format

c. Edit

d. Sheet

Q108. Which of the following chart shows vertical bars?

a. Bar Chart

b. Column Chart

c. Both of the above

d. None of the above

Q109. Shortcut of Print preview in LibreOffice Calc is ____Q69.

a. Ctrl + P

b. Ctrl + Shift + P

c. Ctrl + Shift + O

d. Ctrl +O

Q110. Which of the following feature in LibreOffice Calc speed up the data entry?

a. Label

b. Value

c. Fill Handle

d. None of the above

Electronic Spreadsheet Class 9 MCQ with Answers

---

Click here to check your performance

---

---

Electronic Spreadsheet Class 9 MCQ with Answers

Disclaimer : I tried to give you the correct ” Electronic Spreadsheet Class 9 MCQ with Answers ” , but if you feel that there is/are mistakes in ” Electronic Spreadsheet Class 9 MCQ with Answers ” given above, you can directly contact me at csiplearninghub@gmail.com. Book and Study material available on CBSE official website are used as a reference to create above “Electronic Spreadsheet Class 9 MCQ with Answers“. All the answers of above article “Electronic Spreadsheet Class 9 MCQ with Answers“ are in reference with LibreOffice.

Electronic Spreadsheet Class 9 MCQ with Answers

---

Electronic Spreadsheet Class 9 MCQ with Answers

Important Links of Class IX

Unit 1 : Introduction to IT–ITeS Industry BOOK SOLUTIONS

Unit 1 : Introduction to IT–ITeS Industry NOTES

Unit 3 : Digital Documentation NOTES

Unit 3 : Digital Documentation BOOK SOLUTIONS

Unit 3 : Digital Documentation MCQ

---

Important Links of Class X

Electronic Spreadsheet Class 9 MCQ with Answers