1.number of rows in LibreOffice Calc spreadsheet ?
(a) 1,048,576
(b) 256
(c) 2,048,571
(d) 1111
ans. 1,048,576
2. number of columns in LibreOffice calc spreadsheet?
(a) 256
(b) 257
(c) 1024
(d)210
ans. 1024
3. shortcut key used for help?
(a) ctrl + f 1
(b) ctrl + f2
(c) f 1
(d) f 7
ans. f 1
4. shortcut key used for superscript LibreOffice calc?
(a) ctrl + shift+p
(b) ctrl+ s
(c) ctrl + a
(d) ctrl+ shift+b
ans. ctrl + shift+p
5.extension of LibreOffice calc spreadsheet ?
(A) . ods
(b) .xlx
(c) .odp
(d) .odt
ans. . ods
6. how many spreadsheets on LibreOffice calc by default?
(a) 2
(b)3
(c) 1
(d) 0
ans. 1
7. short cut used for print preview LibreOffice Calc?
(a) CTRL+SHIFT+o
(b) CTRL+P
(C) CTRL+F
(D) CTRL+O
ANS. CTRL+SHIFT+o
8. WHAT WILL RESULT FROM ADDING =A 1+A 2 TO CALC?
(A) ###
(B) 5
(C)1
(D) 0
ANS. 0
9. WHAT IS THE MAXIMUM NUMBER OF SPREADSHEETS IN CALC?
(A) 32000
(B) 1000
(C) 5000
(D) 255
ANS. 32000
10. WHAT IS THE SHORTCUT OF DATE IN LIBREOFFICE CALC?
(A) CTRL+D
(B) CTRL+SHIFT+:
(C) CTRL+ ;
(D) NONE
ANS. CTRL+ ;
11. CALC FORMULA WILL START FROM WHICH OF THE FOLLOWING SYMBOL?
(A) @
(B) =
(C) #
(D) &
ANS. =
12. WHAT IS THE MAXIMUM NUMBER OF CHARACTERS IN ONE CELL IN CALC SPREADSHEET?
(A) 32767
(B) 1024
(C) 6000
(D) 255
ANS. 32767
13. WHAT IS THE MAXIMUM NUMBER OF CELL PER SPREADSHEETS IN CALC?
(A) 10737741824
(B) 1000
(C) 6000
(D) 1,048,576
ANS. 10737741824
14. MOVES THE CURSOR TO THE FIRST CELL (A 1 ) IN THE SHEET IN LIBREOFFICE?
(A) CTRL+HOME
(B)CTRL+F1
(C)ALT+F 1
(D)CTRL+O
ANS, CTRL+HOME
15. KEY USED TO OPENS MANAGE TEMPLATE IN LIBREOFFICE CALC?
(A) CTRL+SHIFT+N
(B) CTRL+T
(C) CTRL+ F 1
(D) CTRL+O
ANS. CTRL+SHIFT+N
16. MINIMUM ZOOM % IN CALC IS….?
(A) 20%
(B) 0%
(C)10%
(D)15%
ANS. 20%
17. KEY USED TO PRINT A DOCUMENT IN LIBREOFFICE CALC?
(A) CTRL+P
(B)CTRL+T
(C) CTRL+F 1
(D) CTRL+O
ANS. CTRL+P
18. SHORTCUT KEY USED TO OPENS THE FUNCTION WIZARD IN LIBREOFFICE CALC?
(A) ALT+ F 1
(B) CTRL+ F6
(C) F 2
(D) CTRL+F 2
ANS. CTRL+F 2
19. CAN’T MAXIMIZE LIBREOFFICE CALC ZOOM?
(A) 200
(B) 300
(C) 500
(D) 400
ANS. 500
20. SHORTCUT KEY USED TO INCREASE WIDTH OF CURRENT CELL IN LIBREOFFICE CALC?
(A) ALT+RIGHT ARROW
(B) ALT+END
(C) F 2
(D) CTRL+F 2
ANS. ALT+RIGHT ARROW
21. SHORTCUT KEY USED TO DECREASE HEIGHT OF CURRENT ROW IN LIBREOFFICE CALC?
(A) ALT+UP ARROW
(B) ALT+ END
(C) F 2
(D) CTRL+ F 2
ANS. ALT+UP ARROW
22. REDUCE THE CELL WIDTH OF THE CURRENT CELL
(A) ALT+ END
(B) ALT+ LEFT ARROW KEY
(C) F 2
(D) CTRL+ F 2
ANS. ALT+ LEFT ARROW KEY
23. SHORT CUT KEY REACH TO LAST EDIT CELL IN LIBREOFFICE CALC?
(A) CTRL+ HOME
(B) ALT+CTRL+O
(C) CTRL+END
(D) CTRL+H
ANS. CTRL+END
24. OUTPUT OF THE CALC EXPRESSION IS =100/10/2?
(A) 25
(B) 50
(C) 5
(D) 200
ANS. 5
25. THE COMBINATION OF THE COLUMN LETTER AND ROW NUMBER FOR A CELL IN AN CALC SPREADSHEET IS CALLED ?
(A) CELL ACROSS
(B) CELL IDENTIFICATION NUMBER
(C) CELL REFERENCE
(D) CELL IDENTIFY
ANS. CELL REFERENCE