LIBREOFFICE CALC ALL QUESTIONS WITH ANSWER (CCC में पूछे जाने वाले लिब्रेऑफिस कैल्क से सम्बंधित प्रश्न व उत्तर)
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
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
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).
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
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
नोट:यदि आप सीसीसी की तैयारी कर रहे हैं, आप हमारी ब्लॉगर साईट 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
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
102. What is the Spreadsheet in Libreoffice? - Calc (It is a spreadsheet program like as M.S. Excel)
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)
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
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
.png)