- WHICH OF THE FOLLOWING IS NOT A TEXT FUNCTION ?
A) ABS()
B) VAR()
C) LEN()
D) CHAR()
ANS. LEN()
2. WHICH OF THE FOLLOWING IS DEFAULT FILE EXTENSION IN SPREADSHEET OF LIBREOFFICE ?
A) ODP
B) ODS
C) ODD
D) OTT
ANS. ODS
3. IN LIBREOFFICE CALC A FORMULA ALWAYS STARTS WITH?
A) %
B) $
C) &
D) =
ANS.&
4. HOW MANY TYPE OF CELL REFERENCES DOES LIBREOFFICE CALC HAVE?
A) 1
B) 2
C) 3
D) 4
ANS. 4
5. WHAT IS MAXIMUM NUMBER OF ROWS AND COLUMNS IN LIBREOFFICE CALC?
A) 1048576 AND 1024
B)1048576 AND 16384
C) 16384 AND 1048576
D) 1024 AND 1048576
ANS.1048576 AND 1024
6. WHICH SHORTCUT KEY COMBINATION IS USED TO START A NEW PARAGRAPH/ NEW LINE IN LIBREOFFICE CALC?
A) CTRL+ENTER
B) SHIFT+ENTER
C) ALT+ENTER
D) CTRL+SHIFT
ANS. CTRL+ENTER
7. WHAT IS MAXIMUM NUMBER OF WORKSHEET IN LIBREOFFICE CALC?
A) 1200
B) 256
C) 2048
D) 10000
ANS. 10000
8. WHICH IS SHORT CUT KEY TO OPEN CELL FORMAT DIALOG BOX IN LIBREOFFICE CALC?
A) SHIFT+1
B) CTRL+1
C) ALT+1
D) CTRL+ALT+1
ANS.CTRL+1
9. WHAT IS SHORT CUT KEY TO PRINT PREVIEW IN LIBREOFFICE CALC?
A) CTRL+SHIFT+P
B) CTRL+P
C) CTRL+ SHIFT+O
D) NONE
ANS.CTRL+ SHIFT+O
10. MERGE CELL COMMAND IS FOUND IN WHICH MENU?
A) FORMAT
B) STYLE
C) SHEET
D) EDIT
ANS.FORMAT
11. WHAT IS THE VALUE DISPLAYED IN CELL IF VALUE OF CELL IS LARGER THAN CELL?
A) $$$
B) ###
C) # NAME
D) NONE
ANS. ###
12. WHAT IS THE SHORT CUT KEY TO DELETE A CELL?
A) CTRL++
B) CTRL+-
C) CTRL+D
D) DELETE
ANS. CTRL+-
13. WHAT IS THE MAXIMUM ZOOM LEVEL IN LIBREOFFICE CALC?
A) 500%
B) 700%
C) 100%
D) 200%
ANS. 500%
14. WHAT IS THE DEFAULT NAME OF THE FILE IN LIBREOFFICE CALC?
A) NO NAME 1
B) CALC 1
C) UNTITLED 1
D) NONE
ANS. UNTITLED 1
15. CELL ADDRESS IS DISPLAYED IN WHICH BAR IN LIBREOFFICE CALC?
A) NAME BOX
B) ADDRESS BAR
C) FORMULA BAR
D) NONE
ANS. NAME BOX
16. WHAT IS LAST CELL ADDRESS IN LIBREOFFICE CALC?
A) $D$10
B) A M J 1048576
C) X F D 1048575
D) A M D 1048576
ANS A M J 1048576
17. TO BREAK A MERGE CELL ” SELECT CELL AND PRESS WHICH OF THE FOLLOWING BUTTON ” IN LIBREOFFICE CALC?
A) CENTRE
B) SPLIT
C) SPLIT AND MERGE
D) MERGE AND CENTRE
ANS. MERGE AND CENTRE
18. WHICH OF THE FOLLOWING IS A FEATURE OF LIBREOFFICE CALC?
A) CALCULATION AND WHAT IS ANALYSIS
B) DATABASE FUNCTION AND ARRANGING DATA
C) DYNAMIC CHARTS
D) ALL OF ABOVE
ANS.ALL OF ABOVE
19. WHICH OF THE FOLLOWING IS NOT AN ELEMENT OF LIBREOFFICE CALC?
A) FORMULA BAR
B) ACTIVE CELL
C) REVIEW MENU
D) NAME BOX
ANS.REVIEW MENU
20. WHICH OF THE FOLLOWING OPTION APPEARS IF A FORMULA CONTAINS ERROR IN LIBREOFFICE CALC?
A) $
B) #
C) *
D) /
ANS. #
21. WHAT WILL BE RESULT OF FORMULA = ROUND ( 247, -2) IN LIBREOFFICE CALC?
A) 247
B) 240
C) 200
D) 0
ANS.200
22. WHICH OF THE FOLLOWING AUTOMATICALLY MOVES AS WORD THAT IS LONG TO FIT ON A LINE TO THE BEGINNING OF NEXT LINE ?
A) FORMAT PRINTER
B) WORD WRAP
C) HYPHENATION
D) SPELL CHECK
ANS.WORD WRAP
23. WHICH OF THE FOLLOWING IS NOT A TOOL FOR ANALYZING SPREADSHEET?
A) GOAL SEEK
B) SORTING
C) MAIL MERGE
D) CHART
ANS.MAIL MERGE
24. TO DISPLAY VALUE OF THE CELL CONTAINING THE EXCEL EXPRESSION “=8/A” IS ?
A) 0
B) # DIV/0!
C) # NAME?
D) # N/A
ANS.# NAME?
25. PIVOT TABLE OPTION IN LIBREOFFICE CALC IS FOUND IN WHICH OF THE FOLLOWING MENU?
A) TOOLS
B) DATA
C) FORMAT
D) NONE
ANS . DATA