LIBREOFFICE CALC QUESTIONS WITH ANSWER (CCC में पूछे जाने वाले लिब्रेऑफिस कैल्क से सम्बंधित प्रश्न व उत्तर)

LIBREOFFICE CALC ALL QUESTIONS WITH ANSWER (CCC में पूछे जाने वाले लिब्रेऑफिस कैल्क से सम्बंधित प्रश्न व उत्तर)

नोट:यदि आप सीसीसी की तैयारी कर रहे हैं, आप हमारी ब्लॉगर साईट www.satyamtrivedi.blogspot.com पर विजिट कर सकते है और न्यू कोर्स आधारित सीसीसी से सम्बन्धित सभी नोट्स प्राप्त कर सकते है अथवा आप हमे हमारे नंबर 9026728220 , 8707603559 पर Whatsapp करके सभी नोट्स प्राप्त कर सकते हैं .

                                      ---------Let us now starts:---------

1. Default Font in Libreoffice Calc   -    Liberation Sans

2.  Default Font Size in Libreoffice Calc   -    10 (Ten)

3.  Default Text Orientation in Libreoffice Calc   -    0° (Zero Digree)

4. Default Zoom Size in Libreoffice Calc   -    100%

5. Minimum Zoom Size in Libreoffice Calc   -    20%

6. Maximum Zoom Size in Libreoffice Calc   -   400% 

7. The Shortcut key To Select   All OR Select whole Worksheet  - Ctrl+A And Ctrl+Shift+Spacebar

8. The Shortcut key To Select a Row in Calc - Shift+Spacebar

9. The Shortcut key To Select a Column in Calc - Ctrl+Spacebar

10. Default Number of Sheet in Libreoffice Calc, When we open it  -   1 (One)

11. The Formula bar displayed under the  - Formatting Tool Bar

12.The Shortcut key Select OR Go To  Next Sheet -  Ctrl+Shift+Page Down Or Ctrl+Tab

13.The Shortcut key Select OR Go To Previous Sheet -  Ctrl+Shift+Page Up Or Ctrl+Shift+Tab

14.The Shortcut key To  Cell Edit Mode Or Edit Cell -  F2

15.The Shortcut key For Edit Mode  -   Ctrl+Shift+M

16. The Shortcut key For  Value Highlighting - Ctrl+8

17. The Shortcut Key for Navigator in Calc. -  F5

18. The Shortcut Key for Save as Template in Calc. - Shift + F11 

19. The Shortcut Key for Style in Calc -  F11 

20. The Shortcut for Undo  - Ctrl+Z

21. The Shortcut for Redo - Ctrl+Y

22. The Shortcut for Repeat - Ctrl+Shift+Y

23. The Shortcut for Paste special in Calc  -  Ctrl+Shift+V

24. The Shortcut for Find in Calc -    Ctrl+F

25 . The Shortcut for Find and Replace in  Calc -  Ctrl+H

26. The Shortcut Key for Fullscreen  in Calc.   - Ctrl + Shift + J

27. The Shortcut for Hide or Unhide the Side bar in Calc  - Ctrl+F5

28. The Shortcut for display the Function Wizard (Function or Formula Window) - Ctrl+F2

29. The Shortcut for Data Source  - Ctrl+Shift+F4

30. Which Type of Print Preview in Calc.  -  Potrait

31. The Shortcut Key for Print Preview in Libreoffice Calc  -  Ctrl + Shift + O

32. The Shortcut Key for Comment in Calc  - Ctrl+Alt+C
                                 
                                               Note:- This option displayed in Insert Menu.

33. The Shortcut Key for Hyperlink in Calc - Ctrl+K

34. The Shortcut Key for Inset Date on the Calc Sheet (Spreadsheet) in Libreoffice Calc - Ctrl + ;   (Control + Semicolen)

35. The Shortcut Key for Inset Time on the Calc Sheet (Spreadsheet) in Libreoffice Calc - Ctrl + Shift + ;   (Control + Shift + Semicolen)

36. The Shortcut Key for Superscript in Calc.  -  Ctrl + Shift +P

37. The Shortcut Key for Subscript in Calc.  -  Ctrl + Shift +B

38. The Shortcut Key for Cycle case in Calc  - Shift+F3

39. The Shortcut Key for Display Format Cell  Dialogbox  - Ctrl+1

40. The Shortcut Key for Double Line Space - Ctrl+2

41. The Shortcut Key for 1.5  Line Space - Ctrl+5

42. The Shortcut for Left Align in Calc     - Ctrl+L

43. The Shortcut for Right Align in Calc   - Ctrl+R

44. The Shortcut for Center Align in Calc - Ctrl+E

45. The Shortcut for Justify Align in Calc  - Ctrl+J

46. Default Font Style in Libreoffice Calc   -    Regular

47. The Shortcut for Number Format (Number) - Ctrl+Shift+1

48. The Shortcut for Number Format (Scienctific) - Ctrl+Shift+2

49. The Shortcut for Number Format (Date) - Ctrl+Shift+3

50. The Shortcut for Number Format (Currency) - Ctrl+Shift+4

51. The Shortcut for Number Format (Percent) - Ctrl+Shift+5

52. The Shortcut for Number Format (General) - Ctrl+Shift+6

53. The Shortcut for Clear Direct Formatting  - Ctrl+M

54. The Default value of Row Hight In Calc - 0.18

55. The Minimum value of Row Hight In Calc - 0.0

56. The Maximum value of Row Hight In Calc - 39.37

57. The Default value of  Optimal Hight of Row  In Calc - 0.7

58. The Minimum value of  Optimal Hight of Row  In Calc - 0.0

59. The Maximum value of  Optimal Hight of Row  In Calc - 16.5

60. The Default value of Column Width In Calc - 0.89

61. The Minimum value of Column Width In Calc - 0.1

62. The Maximum value of Column Width In Calc - 39.37

64. The Default value of  Optimal Width of Column In Calc - 0.1

65. The Minimum value of  Optimal Width of Column In Calc - 0.0

66. The Maximum value of  Optimal Width of Column In Calc - 16.5

67. The Shortcut Key for Manage Style in Calc. - F11

68. The Shortcut Key for Insert OR Add Cell/Row/Column - Ctrl + +(Control+Plus)

69. The Shortcut Key for Delete OR Remove Cell/Row/Column - Ctrl + - (Control+Minus)

70. The Shortcut Key for Clear Cells - Backspace

71. The Shortcut key Navigate OR Move To Next Sheet -  Ctrl+Shift+Page Down Or Ctrl+Tab

72.  The Shortcut key Navigate OR Move To Previous Sheet - Ctrl+Shift+Page Up Or Ctrl+Shift+Tab

73. The Shortcut Key for Fill Down - Ctrl+D

74. The Shortcut Key for Recalculate - F9

75. The Shortcut Key for Recalculate  Hard - Ctrl+Shift+F9

76. The Shortcut Key for Group - F12

77. The Shortcut Key for Ungroup - Ctrl+F12

78. The Shortcut Key for Automatic Spell Cheking in Calc -Shift+F7

79.  The Shortcut Key for Spelling in Calc - F7

80.  The Shortcut Key for Thesaurus in Calc -Ctrl+F7

81. The Shortcut Key for Extension Manager in Calc - Ctrl+Alt+E

82. The Shortcut Key for Close Window in Calc - Ctrl+W

83. The Shortcut Key for Exit Libreoffice Calc  - Ctrl+Q And Alt+F4

84. The Shortcut Key for Help - F1

85.  The Shortcut For Bold - Ctrl+B And Ctrl+Shift+B

86.  The Shortcut For Italic - Ctrl+I

87. The Shortcut For Underline - Ctrl+U

88. Calc Supports (समर्थन करना) Pivot Table - True

89. What is the shortcut key to go from a cell in A1 cell in Calc - Ctrl+Home/End

90. What is the shortcut key to go from First Column A to Last Column AMJ - Ctrl+Right Arrow

91. What is the shortcut key to go from First Row 1 to Last Row 1048576 - Ctrl+Down Arrow

92. Which Shortcut is used to go begining of Row in Calc - Home

93. Number of Rows in Calc - 1048576

94. What is the Filter in Calc -To view specific Rows (विशिष्ट पंक्तियों को देखने के लिए)

95. In calc extension for Spreadsheet Template is - .OTS (Dot Open Template Spreadsheet)

96. What could be the last address of LibreOffice Calc Row - AMJ

97. It is necessary to have a plus (+) before the formula in calc - False (Correct Ans is equal to (=)

98. Calc is a Representative - False   

  Note:- Calc is a spreadsheet program but Impress is a representative program.

99.  Output of the excel expression of =64/8/2   - 4 (Four)

                                     Note: - Fist we multyply 8 and 2 then divide to 64. (2*8=16 then 64/64= 4)

100. The Count Formula in Libreoffice Calc represents the Present Number in the cell -True

101. What is the extension of Libreoffice Calc program ? - .ODS (dot Open Document Spreadsheet) 

102. What is the Spreadsheet in Libreoffice? - Calc (It is a spreadsheet program like as M.S. Excel)

103. Which key is used with the Ctrl to create a new line or paragraph inside the cell of the Libreoffice Calc ? - Enter
                       
          Note:- (We press Ctrl+Enter for create a new line or change/break a line into cell)

104. Which Symbol always starts with the Formula in Libreoffice Calc ? - Equal to (=)

105. What is the result/Output of the Formula =("Hello"&""&"Ram")↩      - Hello Ram
                        
  Note:- &( Ampersand symbol is a conjection Symbol that Combined or Conject Two words)

106. Maximum number of Columns per worksheet  in Libreoffice Calc= 1024 (Col A1 to AMJ).

107. Maximum number of cells per worksheet  in Libreoffice Calc - 1073741824 (2^30).

  

Note:- [You can Multiply Total Number of Column and Rows {1024*1048576= 1073741824}and you get total number of cells]

108. Maximum number of Rows per worksheet = 1048576 (2^20).

109. Maximum number of worksheets in a workbook = 10000

110. For open Cell Format Dialogbox in Calc we press - Ctrl+1

111. The date and Time in Libreoffice Calc are internally treated as numbers. (लिब्रे ऑफिस कैल्क में संग्रहित दिनांक और समय को आतंरिक रूप से संख्याओ के रूप में जाना जाता है) - True

112. Libreoffice calc's Workbook can have only one Sheet - False  (Correct Ans -Max- 10000 Sheets)

113. How many characters can fit into a single cell? - 32,767 (The total number of characters a cell can contain is 32,767.)

114. Libreoffice calc's Workbook have only one Sheet when you open it. - True

115. In Libreoffice calc have the functions like COS, EVEN, FACT, etc, These are Which types function or formula - Mathmatical 

116. The shortcut for Print Preview in Calc - Ctrl+Shift+O

117. By default Save the File With Name in Libreoffice Calc  - Untitled-1

118. For change a given number in Currency Format then we press - Ctrl+Shift+4

119. Where Placed the Name Box - Just below of the Format bar in Left Hand side Corner

120. For Highlight the value in Calc spreadsheet, We press - Ctrl+F8

121. The cell address diplayed in - Name Box.

122. The last cell address in Calc - AMJ1048576.

123. For Split a Merge cell we click on - Merge And Center

124. What do you do to write Monday to Sunday on Libreoffice calc sheet - First write Monday and hold down the right corner then drag and put (drop) it Down.

125. Which shortcut use to go to the left of the cell in Calc - Shift+Tab

126. Which shortcut use to go to the Right of the cell in Calc - Tab

127. Which shortcut use to go to the Down of the cell in Calc - Enter Or Down Arrow Key (↓)

129. Which shortcut use to go to the Up of the cell in Calc - Shift+Enter Or Up Arrow Key (↑)

130. What is the formula of all worksheets called (सभी वर्कशीट के फार्मूला को क्या खा जाता है ?) -Return of Formula Result

131. What happens when we add Row and Column in Calc- Cell

132. Which symbol appears when a formula error occurs ?(कैल्क में फार्मूला एरर होने पर कौन सा सिंबल दिखाई देता है ?) - #                                          NOTE:- (#NAME?)

133. In Libreoffice calc, Number is in Right alignment and Alphabet in Left alignment - True

134. A bar that have save, open, print, cut, copy etc, command, the bar is called -Standard Toolbar

135. The option Freeze Rows And Colums found in - View Menu

136. Total menu in Libreoffice calc - 11 
                 Note:- (File Edit View Insert Fotmat Style Sheet Data Tools Window Help)

137. The shortcut for open a new template in Calc - Ctrl+Shift+N

138. In Libreoffice Calc, We input The Data in - Rows And Column (Cell)

139. Vertical and Horizontal lines that are displayed on the worksheet (Calc spreadsheet) are called - Grid Lines

140. In Libreoffice Calc we can move the Drawing Toolbar from a place to another place. - True

141. A Function(Formula) inside a function is called a Nested Function(Formula) - True
                 Note:- Example:- =SUM(2,4*(Product(2,5)))↩
                                                = 42

143. To copy a cell, when will you hold the control key and simultaneously (साथ साथ) hold the cell. ?- When copying more than one cell.

144. What is the intersection (प्रतिच्छेदन या परस्पर एक दुसरे को काटना) of Rows and Columns is called - Cell

145. Which shortcut is used to increase cell width in Libreoffice Calc - Alt+Right Arrow (Alt + →)

146. Which shortcut is used to Decrease cell width in Libreoffice Calc - Alt+Left Arrow (Alt + ←)

147. Libreoffice Calc also known as - Spreadsheet

148. In Libreoffice What is Mail marge - Send an E-mail to many Persons in one Time.

149. In Libreoffce, Number Align is - Right Align

150. The intersection of Row and Column is Called -  Cell

151. The shortcut for Paste Spacial in Libreoffice Calc - Ctrl+Shift+V

152. The Last cell in Libreoffice Calc - AMJ1 (ए एम जे वन)

153. In Libreoffice calc, Column are known as -  A, B, C, D,......................AMJ. (A to AMJ)

154. In Libreoffice calc, Rows are known as - 1, 2, 3, 4, .............................. 1048576 ( 1 to 1048576 )

155. The form of data is organized (व्यवस्थित) in the worksheet -  Row and Column

                                   😄 Thanks For Visiting!! 😄

                               Dear Friends And Students Please Like And Share My Posts
           If you want any query, You call me or Whatsapp on my contact no - 9026728220,           8707603559
           You also can visit my Blogger site -- www.itcicomputerhardoi.blogspot.com