Spreadsheet (LibreOffice Calc): 100 Questions & Answers

LibreOffice Calc mein Cells, Formulas, Basic Functions, Charts, Data Formatting, aur Printing Settings 

LibreOffice Calc Basics, Cells & Formatting (25 Questions)

1. Question: LibreOffice Calc kya hai? Answer: Yeh LibreOffice suite ka ek open-source spreadsheet program hai jo data processing, calculations, analysis, aur charts banane ke kaam aata hai.

2. Question: LibreOffice Calc document ka default file extension kya hota hai? Answer: .ods (OpenDocument Spreadsheet).

3. Question: LibreOffice Calc ki ek Worksheet mein kul kitni Rows aur Columns hote hain? Answer: $1,048,576$ Rows aur $1,024$ Columns (naye versions mein $16,384$ Columns tak support hai).

4. Question: Calc mein naye Workbook mein by default kitni Sheets hoti hain? Answer: $1$ Sheet (Sheet1).

5. Question: Active Cell ka address ya reference Calc screen par kahan dikhta hai? Answer: Name Box (Formula bar ke left side mein).

6. Question: Selected Cell ko Edit karne ki keyboard shortcut key kya hai? Answer: F2 key.

7. Question: LibreOffice Calc mein poori Sheet ko select karne ki shortcut key kya hai? Answer: Ctrl + A (ya Ctrl + Shift + Spacebar).

8. Question: By default, Cell mein Text aur Numbers ka alignment kis taraf hota hai? Answer: Text = Left aligned, Numbers = Right aligned.

9. Question: Text ko cell ki boundary ke andar multiple lines mein fit karne wale feature ko kya kehte hain? Answer: Wrap Text (Format -> Cells -> Alignment -> Wrap text automatically).

10. Question: Multiple cells ko mila kar ek single cell banane aur content center karne ko kya kehte hain? Answer: Merge Cells (ya Merge & Center Cells).

11. Question: Calc mein nayi Sheet insert karne ki shortcut key kya hai? Answer: Insert -> Sheet (ya Sheet tab par Right-click -> Insert Sheet).

12. Question: Direct Formatting ko Clear karne ki shortcut key LibreOffice Calc mein kya hai? Answer: Ctrl + M

13. Question: Cell contents delete karne par "Delete Contents" dialog box kholne ki key kya hai? Answer: Backspace key (ya Delete key se seedhe saara data delete hota hai).

14. Question: Selected Rows ya Columns ko Delete karne ki shortcut key kya hai? Answer: Ctrl + - (Minus key).

15. Question: Selected Rows ya Columns ko Insert karne ki shortcut key kya hai? Answer: Ctrl + + (Plus key).

16. Question: Scroll karte waqt Top Rows ya Left Columns ko screen par fixed/lock rakhne ke liye kis menu ka use hota hai? Answer: View -> Freeze Rows and Columns (ya View -> Freeze Cells).

17. Question: Non-contiguous (jo jude hue na ho) cells ko select karne ke liye kis key ko hold karte hain? Answer: Ctrl key.

18. Question: Cell mein Comment/Note insert karne ki shortcut key kya hai? Answer: Ctrl + Alt + C

19. Question: Worksheet ke sabse pehle cell ($A1$) par jump karne ki shortcut key kya hai? Answer: Ctrl + Home

20. Question: Calc Template file ka default extension kya hota hai? Answer: .ots (OpenDocument Spreadsheet Template).

21. Question: Sidebar Panel ko Open/Close (Toggle) karne ki shortcut key kya hai? Answer: Ctrl + F5

22. Question: Cell Formatting (Format Cells) dialog box kholne ki shortcut key kya hai? Answer: Ctrl + 1

23. Question: Column ki width ko uske contents ke hisab se automatically adjust karne ke liye kya karte hain? Answer: Column header border par Double-Click karke (Optimal Column Width).

24. Question: Sheet Tab ka color change karne ke liye kahan click karte hain? Answer: Sheet Tab par Right-Click -> Tab Color.

25. Question: Sheet ko Rename karne ka sabse aasan tarika kya hai? Answer: Sheet Tab par Double-Click karke naya naam type karna.

Part 2: Formulas & Cell Referencing (25 Questions)

26. Question: LibreOffice Calc mein koi bhi Formula ya Function hamesha kis symbol se shuru hota hai? Answer: Equals sign (=).

27. Question: Relative Cell Reference kya hota hai? Answer: Standard reference (jaise $A1$) jo formula copy karne par nayi cell location ke hisab se badal jata hai.

28. Question: Absolute Cell Reference kya hota hai aur ise kaise lock kiya jata hai? Answer: Fixed reference (jaise $\$A\$1$) jo copy karne par nahi badalta; ise Dollar symbol ($$) se lock kiya jata hai.

29. Question: Calc mein Cell Reference type ko Relative se Absolute/Mixed mein change karne ki shortcut key kya hai? Answer: Shift + F4 (Note: MS Excel mein yeh F4 hoti hai, Calc mein Shift + F4).

30. Question: Mixed Cell Reference ka ek example dein. Answer: $\$A1$ (Column locked) ya $A\$1$ (Row locked).

31. Question: Formula Bar par Sum button ya AutoSum add karne ka option kahan hota hai? Answer: Formula Bar par $\sum$ (Sigma) icon par click karke (ya Alt + =).

32. Question: Function Wizard dialog box kholne ki shortcut key kya hai? Answer: Ctrl + F2

33. Question: Calc mein doosri Sheet ke cell ko refer karte waqt Sheet Name aur Cell Address ke beech kaun sa symbol lagta hai? Answer: Dot/Period (.) symbol (jaise =Sheet2.A1).

34. Question: Circular Reference Warning kab aati hai? Answer: Jab koi formula calculation ke liye apne hi cell reference ka upyog kar leta hai (Err:522).

35. Question: Calc mein Formula mein Function Name galat type hone par kaun sa error code dikhta hai? Answer: #NAME? ya Err:525.

36. Question: Zero ($0$) se divide karne par Calc mein kaun sa error code aata hai? Answer: Err:503 (ya #DIV/0!).

37. Question: #REF! ya Err:524 error kab aata hai? Answer: Jab formula dwara refer kiya gaya cell delete ho jata hai (Invalid Cell Reference).

38. Question: #VALUE! error ka kya matlab hai? Answer: Jab formula mein wrong data type use hota hai (jaise text ko number se multiply karna).

39. Question: Cell ke andar ### (Hash marks) kyun dikhne lagte hain? Answer: Jab Column ki width utni badi nahi hoti ki poori numerical value ya date display ho sake.

40. Question: Sheet par saare formulas ek saath Show/Hide karne ki shortcut key kya hai? Answer: Ctrl + ~ (Tilde key) ya View -> Show Formula.

41. Question: Formulas mein Mathematical Operators ki Precedence order kya hai? Answer: Parentheses (), Exponentiation ^, Multiplication * & Division /, Addition + & Subtraction -.

42. Question: Do text strings ko jodne (Concatenate) ke liye kis operator ka upyog hota hai? Answer: Ampersand (&) operator.

43. Question: Power / Exponentiation ke liye kaun sa symbol use hota hai? Answer: Caret (^) symbol (jaise =2^3 output $8$ deta hai).

44. Question: Comparison operators mein "Not Equal To" kaise likha jata hai? Answer: <>

45. Question: =20-4*2 ka output kya hoga? Answer: $12$ (pehle Multiplication $4 \times 2 = 8$, fir Subtraction $20 - 8 = 12$).

46. Question: =(20-4)*2 ka output kya hoga? Answer: $32$ (pehle Brackets solve hoga $16 \times 2 = 32$).

47. Question: Formula mein Text values ko kis me enclose karke likha jata hai? Answer: Double Quotes (" ") ke andar.

48. Question: Calc Formula Bar ke 2 main components kaun se hain? Answer: Name Box aur Input Line.

49. Question: Re-calculate all formulas manually karne ki shortcut key Calc mein kya hai? Answer: F9 (Hard Recalculate = Ctrl + Shift + F9).

50. Question: =A1&" "&B1 formula ka output kya hoga jab $A1=\text{"Amit"}$ aur $B1=\text{"Sharma"}$ ho? Answer: "Amit Sharma"

Part 3: Basic Functions (Math, Text, Logical & Lookup) (25 Questions)

51. Question: Numeric range ka Total calculate karne wala function kaun sa hai? Answer: =SUM(range)

52. Question: Given values ki Average (ausat) nikalne wala function kaun sa hai? Answer: =AVERAGE(range)

53. Question: COUNT aur COUNTA functions mein kya antar hai? Answer: COUNT sirf numeric values ginta hai, jabki COUNTA non-empty (text + numbers) sabhi cells ginta hai.

54. Question: Range mein khali (empty) cells ginne ke liye kaun sa function hai? Answer: =COUNTBLANK(range)

55. Question: Range se Maximum aur Minimum value nikalne ke functions kaun se hain? Answer: Max = =MAX(range), Min = =MIN(range).

56. Question: Range mein $k$-th largest value (jaise 2nd highest number) nikalne ke liye kya use karte hain? Answer: =LARGE(range, k)

57. Question: IF function ka basic syntax kya hai? Answer: =IF(Test, Then_Value, Otherwise_Value)

58. Question: "Nested IF" ka matlab kya hai? Answer: Ek IF function ke andar doosre IF function ka use karna.

59. Question: COUNTIF function ka kya kaam hai? Answer: Specific condition ya criteria match hone par cells ko count karna.

60. Question: SUMIF function kya karta hai? Answer: Criteria match hone par hi corresponding values ka sum karta hai.

61. Question: =ROUND(45.678, 2) ka result kya hoga? Answer: $45.68$

62. Question: INT function ka output =INT(9.8) par kya aayega? Answer: $9$ (Decimal part hata kar lower integer deta hai).

63. Question: ABS function ka kaam kya hai? Answer: Negative number ko Positive (Absolute value) mein convert karna (e.g., =ABS(-25) gives $25$).

64. Question: Number ka Square Root nikalne ke liye kaun sa function hai? Answer: =SQRT(number)

65. Question: Text ko UPPERCASE, lowercase, aur Title Case mein convert karne wale functions kaun se hain? Answer: =UPPER(text), =LOWER(text), =PROPER(text).

66. Question: LEN function kya batata hai? Answer: Cell mein मौजूद string ke total characters ki sankhya.

67. Question: TRIM function ka upyog kyun hota hai? Answer: Text ke aage, piche aur beech ke unnecessary extra spaces ko remove karne ke liye.

68. Question: Text string ke Left, Right ya Middle se character extract karne ke functions? Answer: =LEFT(text, number), =RIGHT(text, number), =MID(text, start, number).

69. Question: Current System Date aur Current Date with Time dene wale functions? Answer: Current Date = =TODAY(), Current Date & Time = =NOW().

70. Question: DATE function ka syntax kya hai? Answer: =DATE(year, month, day)

71. Question: VLOOKUP function ka full form aur kaam kya hai? Answer: Vertical Lookup; data table ke pehle column mein search karke corresponding row se data retrieve karna.

72. Question: VLOOKUP function ka syntax Calc mein kya hota hai? Answer: =VLOOKUP(Lookup_Value, Search_Array, Index, [Sort_Order])

73. Question: VLOOKUP mein Exact Match ke liye Sort_Order argument kya diya jata hai? Answer: 0 (ya FALSE).

74. Question: HLOOKUP aur VLOOKUP mein kya antar hai? Answer: VLOOKUP Vertically (Columns mein) search karta hai, jabki HLOOKUP Horizontally (Rows mein) search karta hai.

75. Question: Formula error aane par custom message dikhane ke liye kaun sa function use hota hai? Answer: =IFERROR(expression, value_if_error)

Part 4: Charts, Data Tools & Printing Settings (25 Questions)

76. Question: Spreadsheet mein Chart kya hota hai? Answer: Cell data ka visual/graphical representation.

77. Question: Calc mein Chart Insert karne ka menu path kya hai? Answer: Insert -> Chart... (ya Standard Toolbar par Chart icon).

78. Question: Column Chart aur Bar Chart mein mukhya antar kya hai? Answer: Column Chart vertical bars use karta hai, jabki Bar Chart horizontal bars use karta hai.

79. Question: Time ke saath data trends (jaise sales growth over months) dikhane ke liye sabse upyogi chart kaun sa hai? Answer: Line Chart.

80. Question: Proportions ya Percentages ($100\%$ total parts) dikhane ke liye kaun sa chart suitable hai? Answer: Pie Chart.

81. Question: XY (Scatter) Chart ka primary purpose kya hota hai? Answer: Do numerical variables ke beech relationship/correlation dikhana.

82. Question: Chart Legend kya hota hai? Answer: Chart mein alag-alag data series aur colors ki pehchan karwane wali key/box.

83. Question: Chart Data Labels kya hote hain? Answer: Bars ya pie slices par unki actual numeric values ko print/display karna.

84. Question: Chart Title aur Axis Titles ka kaam kya hai? Answer: Chart ki main heading aur X/Y axis ko label describe karna.

85. Question: Chart Background par banne wali horizontal aur vertical lines ko kya kehte hain? Answer: Gridlines.

86. Question: AutoFilter feature activate karne ki shortcut key Calc mein kya hai? Answer: Ctrl + Shift + L (ya Data -> AutoFilter).

87. Question: Data Sorting ka kya matlab hota hai? Answer: Data ko Ascending (A to Z / Smallest to Largest) ya Descending order mein arrange karna (Data -> Sort).

88. Question: Conditional Formatting feature ka kya kaam hai? Answer: Criteria/Rules ke aadhar par cells ka visual formatting (color, highlight) badalna (Format -> Conditional).

89. Question: Validity (Data Validation) feature ka upyog kyun hota hai? Answer: Cell mein wrong data entry ko rokne ke liye rules set karna (e.g., Only numbers $1-100$ allowed) (Data -> Validity...).

90. Question: Specific print area define karne ke liye kis option ka use hota hai? Answer: Format -> Print Ranges -> Define.

91. Question: Large sheet ko single printed page ki width par fit karne ki setting kahan hoti hai? Answer: Format -> Page Style -> Sheet tab -> Scale (Fit print range(s) to width/height).

92. Question: Printed paper par Gridlines aur Column/Row Headings ko include karne ke liye kya setting karte hain? Answer: Format -> Page Style -> Sheet tab -> Print section mein Grid aur Column/Row headers check mark karna.

93. Question: Multi-page printout par Top Header Row ko har page par repeat karne ke liye kya setting hai? Answer: Format -> Print Ranges -> Edit -> Rows to Repeat.

94. Question: LibreOffice Calc mein Print Preview dekhne ki shortcut key kya hai? Answer: Ctrl + Shift + O

95. Question: Print Dialog box open karne ki shortcut key kya hai? Answer: Ctrl + P

96. Question: Page Orientation ke do modes kaun se hain? Answer: Portrait (Vertical) aur Landscape (Horizontal).

97. Question: Pivot Table (DataPilot) ka primary purpose kya hai? Answer: Large data sets ko bina formulas ke summarize, analyze, aur pivot report mein convert karna (Insert -> Pivot Table...).

98. Question: Goal Seek tool kis kaam aata hai? Answer: Desired target output pane ke liye input value mein required change calculate karna (Tools -> Goal Seek...).

99. Question: Sheet ya Document ko Password se protect karne ka option kahan milti hai? Answer: Tools -> Protect Sheet... (ya Tools -> Protect Spreadsheet Structure...).

100. Question: Calc Window close karne aur LibreOffice Suite se Exit karne ki shortcut keys kya hain? Answer: Close Window = Ctrl + W, Exit LibreOffice = Ctrl + Q.