Electronic spreadsheet class 9 mcqs

class 9 mcqs

1. ELECTRONIC SPREADSHEET MCQS
Q1. Q1. Which of the following help us to perform various calculations?
a. Writer

b. Spreadsheet

c. Impress

d. None of the above


Hide Answer
Ans. b. Spreadsheet
Q2. Spreadsheet is used for :
a. Managing financial and accounting documents.

2. ELECTRONIC SPREADSHEET MCQS

b. Creating data reports.

c. Data analysis

d. All of the above.


Hide Answer
Ans. d. All of the above.
Q3. Spreadsheet packages also provide built-in _______ formulae
a. Mathematical

b. Statistical

3. ELECTRONIC SPREADSHEET MCQS
c. Both of the above

d. None of the above


Hide Answer
Ans. c. Both 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

4. ELECTRONIC SPREADSHEET MCQS


Hide Answer
Ans. 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

5. ELECTRONIC SPREADSHEET MCQS
Hide Answer
Ans.b. Linux (Ubuntu)
Electronic Spreadsheet Class 9 MCQ with Answers
Electronic Spreadsheet Class 9 MCQ with Answers
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

6. ELECTRONIC SPREADSHEET MCQS

d. None of the above


Hide Answer
Ans.c. Both 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

7. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. c. Title 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


Hide Answer
Ans. a. Untitled X, where X is a number

8. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. c. bottom, right
Q10. By default _____________ sheets is/are present in LibreOffice Calc
Spreadsheet.
a. 1

9. ELECTRONIC SPREADSHEET MCQS

b. 2

c. 3

d. 4


Hide Answer
Ans. a. 1
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

10. ELECTRONIC SPREADSHEET MCQS

b. Alphabets

c. Alphanumeric

d. None of the above


Hide Answer
Ans. a. Numbers
Q12. _____________ contains the menus with commands for various tasks.
a. Status bar

b. Standard Tool bar

11. ELECTRONIC SPREADSHEET MCQS
c. Formatting Tool bar

d. Menu bar


Hide Answer
Ans. 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

12. ELECTRONIC SPREADSHEET MCQS


Hide Answer
Ans. b. Menu bar
Q14. ____________ is the shortcut to exit LibreOffice.
a. Ctrl + Q

b. Ctrl + E

c. Ctrl + X

d. None of the above


Show Answer

13. ELECTRONIC SPREADSHEET MCQS
Q15. Cut, Copy, Paste options are available in ________ menu.
a. File

b. Edit

c. Format

d. View


Hide Answer
Ans. b. Edit
Electronic Spreadsheet Class 9 MCQ with Answers
Q16. Insert Cells, Insert Rows, Insert Columns options are available in
__________ menu.

14. ELECTRONIC SPREADSHEET MCQS
a. File

b. Insert

c. Sheet

d. Data


Hide Answer
Ans. c. Sheet
Q17. Placing the mouse cursor over any icon displays a small box called
_________________ which gives a brief explanation of the icon.
a. Toolbar

15. ELECTRONIC SPREADSHEET MCQS
b. Toolbox

c. Tooltip

d. All of the above


Hide Answer
Ans. c. Tooltip
Q18. _______ shows the address of Active Cell.
a. Name Box

b. Current Cell

c. Formula bar

16. ELECTRONIC SPREADSHEET MCQS

d. None of the above


Hide Answer
Ans.a. Name Box
Q19. The Worksheet in Calc is also referred to as __.
a. Workbook

b. Spreadsheet

c. Sheet

d. None of the above

17. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. c. Sheet
Q20. Columns are ________ in the table.
a. Horizontal

b. Vertical

c. Diagonal

d. None of the above


Hide Answer
Ans. b. Vertical

18. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. a. AA

19. ELECTRONIC SPREADSHEET MCQS
Q22. The intersection of a row and column is called _________.
a. Cell Address

b. Cell

c. Point of intersection

d. None of the above


Hide Answer
Ans. b. Cell
Q23. Which of the following is invalid Cell Address?
a. A1

20. ELECTRONIC SPREADSHEET MCQS
b. Z247

c. 91A

d. None of the above


Hide Answer
Ans. c. 91A
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.

21. ELECTRONIC SPREADSHEET MCQS

d. None of the above


Hide Answer
Ans. 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

22. ELECTRONIC SPREADSHEET MCQS


Hide Answer
Ans. c. J19
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

23. ELECTRONIC SPREADSHEET MCQS
Hide Answer
Ans. a. A1
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


Hide Answer
Ans. c. Ctrl + Arrow keys

24. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. a. Ctrl + Home
Q29. Which key / key combination moves the worksheet one screen up?
a. Ctrl + Up Arrow Key

25. ELECTRONIC SPREADSHEET MCQS

b. Ctrl + Page Up

c. Page Up

d. None of the above


Hide Answer
Ans. c. Page Up
Q30. A block of adjacent cells in a worksheet which is highlighted or
selected is called _____________
a. Block of cells

b. Range of Cells

26. ELECTRONIC SPREADSHEET MCQS

c. Both of the above

d. None of the above


Hide Answer
Ans. b. Range of Cells
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

27. ELECTRONIC SPREADSHEET MCQS

c. 6

d. 7


Hide Answer
Ans. c. 6
Q32. C3 : F3 is an example of ___________
a. Column range

b. Row range

c. Row and Column range

28. ELECTRONIC SPREADSHEET MCQS
d. None of the above


Hide Answer
Ans. b. Row range
Q33. Cell Range A1:D3 consist of ___________ cells.
a. 3

b. 4

c. 12

d. 10

29. ELECTRONIC SPREADSHEET MCQS
Hide Answer
Ans. c. 12
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


Hide Answer
Ans. a. Ctrl

30. ELECTRONIC SPREADSHEET MCQS
Q35. What is the address of the first cell represented by Range D34 :
F40?
a. F40

b. D34

c. D40

d. F34


Hide Answer
Ans. b. D34
Electronic Spreadsheet Class 9 MCQ with Answers
Q36.In LibreOffice Calc, _________ is any text entered by using a keyboard.

31. ELECTRONIC SPREADSHEET MCQS
a. Values

b. Poster

c. Label

d. None of the above


Hide Answer
Ans. c. Label
Q37. By default labels are _________ aligned.
a. left

b. right

32. ELECTRONIC SPREADSHEET MCQS

c. top

d. None of the above


Hide Answer
Ans. a. left
Q38. The data consisting of only numbers are called _______
a. Labels

b. Values

c. Functions

33. ELECTRONIC SPREADSHEET MCQS
d. None of the above


Hide Answer
Ans. b. Values
Q39. By default Values are _______ aligned.
a. Top

b. Right

c. Left

d. None of the above

34. ELECTRONIC SPREADSHEET MCQS
Hide Answer
Ans. b. Right
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


Hide Answer
Ans. b. Formula
Electronic Spreadsheet Class 9 MCQ with Answers

35. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. c. /

36. ELECTRONIC SPREADSHEET MCQS
Q42. Which of the following symbol is used for exponentiation(power) in
LibreOffice Calc?
a. **

b. /*

c. ^

d. None of the above


Hide Answer
Ans. c. ^
Q43. Evaluate the following formula:
= (5*4)^2

37. ELECTRONIC SPREADSHEET MCQS

a. 40

b. 80

c. 400

d. None of the above


Hide Answer
Ans. c. 400
Q44. Evaluate the following formula :
= 16/(4^2)

38. ELECTRONIC SPREADSHEET MCQS
a. 0

b. 1

c. 16

d. 8


Hide Answer
Ans. b. 1
Q45. Evaluate the following formula :
=1+2^2-2

a. 1

39. ELECTRONIC SPREADSHEET MCQS

b. 2

c. 3

d. 4


Hide Answer
Ans. c. 3
Electronic Spreadsheet Class 9 MCQ with Answers
Q46. Which operator in the given expression has the highest priority?
=5+6*2^2

a. +

40. ELECTRONIC SPREADSHEET MCQS

b. ^

c. *

d. None of the above


Hide Answer
Ans. b. ^
Q47. Which of the following operator has the highest priority?
a. ( )

b. *

41. ELECTRONIC SPREADSHEET MCQS
c. ^

d. +


Hide Answer
Ans. a. ( )
Q48. If we forgot to put the ‘=’ before the formula, it will be treated as a
____________
a. Value

b. Function

c. Label

42. ELECTRONIC SPREADSHEET MCQS
d. None of the above


Hide Answer
Ans. c. Label
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

43. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. a. Formula
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


Hide Answer
Ans. b. =B1 + C1

44. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. d. Sheet

45. ELECTRONIC SPREADSHEET MCQS
Q52. Extension of LibreOffice Calc file is ______
a. .ods

b. .xls

c. .odx

d. None of the above


Hide Answer
Ans. a. .ods
Q53. To insert the column before any column select ___
a. Sheet → Insert Columns → Columns left

46. ELECTRONIC SPREADSHEET MCQS
b. Sheet → Insert Columns → Columns right

c. Sheet → Insert Columns → Columns

d. None of the above


Hide Answer
Ans. a. Sheet → Insert Columns → Columns left
Q54. When we drag a formula, address of the cell used in formula will
automatically change.(T/F)
a. True

b. False

47. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. a. True
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

48. ELECTRONIC SPREADSHEET MCQS

Show Answer
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

49. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. c. 27
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


Hide Answer

50. ELECTRONIC SPREADSHEET MCQS
Ans. b. SUM( )
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


Hide Answer
Ans. d. All of the above
Q59. Which of the following is a formula ?
= D2+D3+D4+D5+D6+D7 –—- A

51. ELECTRONIC SPREADSHEET MCQS

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

a. Only A

b. Only B

c. Both A and B

d. None of the above


Hide Answer
Ans. c. Both A and B

52. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. b. AVERAGE( )
Electronic Spreadsheet Class 9 MCQ with Answers
Click here to check your performance

53. ELECTRONIC SPREADSHEET MCQS
Electronic Spreadsheet Class 9 MCQ with Answers
Do all questions from(61 to 70) by considering the following sheet.
Electronic Spreadsheet Class 9 MCQ with Answers
Electronic Spreadsheet Class 9 MCQ with Answers


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

54. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. a. =B2 + C2 + D2
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


Hide Answer

55. ELECTRONIC SPREADSHEET MCQS
Ans. c. =B4 + C4 + D4
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


Hide Answer
Ans. a. =D2 + E2 + F2
Q64. Write the formula/function in cell B7 to find the highest score in
Hindi.

56. ELECTRONIC SPREADSHEET MCQS
a. =maximum(B2:B6)

b. =max(B2:B6)

c. =max(B1:B6)

d. None of the above


Hide Answer
Ans. b. =max(B2:B6)
Q65. Write the formula/function in cell B8 to find the total number of
students who appeared in Hindi?
a. =counter(B2 : B6)

57. ELECTRONIC SPREADSHEET MCQS
b. =count(B2 : B6)

c. =counter(B2 : B7)

d. =count(B2 : B7)


Hide Answer
Ans. b. =count(B2 : B6)
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)

58. ELECTRONIC SPREADSHEET MCQS

c. Both of the above

d. =minimum(B2 : B6)


Hide Answer
Ans. c. Both of the above
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

59. ELECTRONIC SPREADSHEET MCQS

d. None of the above


Hide Answer
Ans. c. Both 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

60. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. b. =(B4 + C4 + D4 )/3
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


Hide Answer
Ans. c. =max(B5 + C5 + D5)

61. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. a. =Count(A2 : A6)
Electronic Spreadsheet Class 9 MCQ with Answers
Click here to check your performance
Electronic Spreadsheet Class 9 MCQ with Answers

62. ELECTRONIC SPREADSHEET MCQS
Do all questions from(71 to 80) by considering the following sheet.
Electronic Spreadsheet Class 9 MCQ with Answers
Electronic Spreadsheet Class 9 MCQ with Answers
Q71. Write the output of =SUM (A1,B1,C1)
a. 15

b. 16

c. 17

d. 18


Hide Answer
Ans. c. 17

63. ELECTRONIC SPREADSHEET MCQS
Q72. Write the output of =SUM(A1:C1,B2)
a. 24

b. 25

c. 26

d. 27


Hide Answer
Ans. a. 24
Q73. Write the output of =AVERAGE (A1:C1)
a. 5.55

64. ELECTRONIC SPREADSHEET MCQS
b. 5.66

c. 6.5

d. 6.66


Hide Answer
Ans. b. 5.66
Q74. Write the output of =AVERAGE (A1:A3,C1:C3)
a. 6

b. 6.5

c. 6.16

65. ELECTRONIC SPREADSHEET MCQS

d. 6.2


Hide Answer
Ans. c. 6.16
Q75. Write the output of : =MAX(A1,B1:C2)
a. 7

b. 8

c. 5

d. None of the above

66. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. a. 7
Electronic Spreadsheet Class 9 MCQ with Answers
Q76. Write the output of : =MIN(A2:C2,B3)
a. 5

b. 4

c. 7

d. 8


Hide Answer

67. ELECTRONIC SPREADSHEET MCQS
Ans. b. 4
Q77. Write the output of : =COUNT(A1:C1,B2)
a. 3

b. 4

c. 5

d. 2


Hide Answer
Ans. b. 4
Q78. Write the output of : =COUNT(A1:A3,C1:C3)
a. 2

68. ELECTRONIC SPREADSHEET MCQS

b. 4

c. 6

d. 8


Hide Answer
Ans. c. 6
Q79. Write the output of : =SUM(B1:C2)
a. 22

b. 23

69. ELECTRONIC SPREADSHEET MCQS
c. 24

d. 25


Hide Answer
Ans. b. 23
Q80 Write the output of : =MIN(A1,B2,C1)
a. 3

b. 4

c. 5

d. 6

70. ELECTRONIC SPREADSHEET MCQS


Hide Answer
Ans. c. 5
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

71. ELECTRONIC SPREADSHEET MCQS
d. None of the above


Hide Answer
Ans. c. Both 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


Hide Answer
Ans. a. True
Q83. Format cell dialog box can be opened by _____

72. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. c. Both of the above
Q84. Shortcut to open Format Cell dialog box is __
a. Ctrl + F2

73. ELECTRONIC SPREADSHEET MCQS
b. Ctrl + F3

c. Ctrl + F7

d. Ctrl + 1


Hide Answer
Ans. d. Ctrl + 1
Q85. In _________________ tab of Format cell dialog box, we can specify the
number of decimal places.
a. Borders

b. Background

74. ELECTRONIC SPREADSHEET MCQS
c. Numbers

d. Font


Hide Answer
Ans. c. Numbers
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

75. ELECTRONIC SPREADSHEET MCQS

d. Centre


Hide Answer
Ans. c. Justified
Q87. Shortcut of Centre Alignment in LibreOffice Calc is _____
a. Ctrl + L

b. Ctrl + E

c. Ctrl + J

d. Ctrl + C

76. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. b. Ctrl + E
Q88. Shortcut of Left Alignment in LibreOffice Calc is _____
a. Ctrl + R

b. Ctrl + T

c. Ctrl + L

d. Ctrl + C


Hide Answer
Ans. c. Ctrl + L

77. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. a. Fill Handle
Q90. Fill handle of a cell is the small black square appears in the ________
corner of the selected cell.
a. Bottom-right

78. ELECTRONIC SPREADSHEET MCQS

b. Bottom-left

c. Top-right

d. None of the above


Hide Answer
Ans. a. Bottom-right
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

79. ELECTRONIC SPREADSHEET MCQS

b. 2

c. 3

d. 4


Hide Answer
Ans. c. 3
Q92. =A1 + B1 is an example of ______ referencing.
a. Absolute

b. Relative

80. ELECTRONIC SPREADSHEET MCQS
c. Mixed

d. None of the above


Hide Answer
Ans. b. Relative
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

81. ELECTRONIC SPREADSHEET MCQS
d. None of the above


Hide Answer
Ans. a. Relative
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

82. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. b. =C6 * D6
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


Hide Answer

83. ELECTRONIC SPREADSHEET MCQS
Ans. b. =E2 * F2
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


Hide Answer
Ans. d. View > Show Formula
Q97. C$14. This is an example of __________________ referencing.

84. ELECTRONIC SPREADSHEET MCQS
a. Absolute

b. Relative

c. Mixed

d. None of the above


Hide Answer
Ans. c. Mixed
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

85. ELECTRONIC SPREADSHEET MCQS
b. =H11 + C$25

c. =H2 + C$14

d. None of the above


Hide Answer
Ans. a. =H11 + C$14
Q99. Which of the following symbol is used in referencing, to freeze a
column or a row.
a. #

b. :

86. ELECTRONIC SPREADSHEET MCQS
c. $

d. @


Hide Answer
Ans. c. $
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

87. ELECTRONIC SPREADSHEET MCQS
d. None of then above


Hide Answer
Ans. c. Mixed
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

88. ELECTRONIC SPREADSHEET MCQS
d. None of the above


Hide Answer
Ans. 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

89. ELECTRONIC SPREADSHEET MCQS
Hide Answer
Ans. b. Only column heading will changes
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


Hide Answer
Ans. a. $A$1

90. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. c. Absolute
Q105. Which of the following chart is/are available in LibreOffice Calc?
a. XY Scatter Chart

91. ELECTRONIC SPREADSHEET MCQS

b. Column Chart

c. Line Chart

d. All of the above


Hide Answer
Ans. 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

92. ELECTRONIC SPREADSHEET MCQS
b. Circular Chart

c. Oval Chart

d. Pie Chart


Hide Answer
Ans. d. Pie Chart
Q107. Chart option is available in _________ menu.
a. Insert

b. Format

c. Edit

93. ELECTRONIC SPREADSHEET MCQS

d. Sheet


Hide Answer
Ans. a. Insert
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

94. ELECTRONIC SPREADSHEET MCQS

Hide Answer
Ans. c. Both 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


Hide Answer
Ans. c. Ctrl + Shift + O

95. ELECTRONIC SPREADSHEET MCQS
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


Hide Answer
Ans. c. Fill Handle
Electronic Spreadsheet Class 9 MCQ with Answer