1) Which of the following techniques can be used to allow only date value in cell?
a) Data formatting
b) Data sorting
c) Data
d) Data validation
Ans: d)Data validation
2) Which of the following options when selected deletes all data validation?
a) Delete
b) Delete all
c) Delete formula
d) Delete me
Ans:a)Delete formatting
3) We can replace multiple occurrences of a word using which of the following facilities of Calc?
a) Find and
b) By copy only
c) By copy
d) By preview command
Ans: a)find and replace
4) What is the name of mechanism to arrange the data in a particular order?
a)Sorting
b) Searching
c) Filtering
d) Validating
Ans:a)sorting
5) What is the name of mechanism to filter out unnecessary data?
a) Sorting
b) Searching
c) Filtering
d) Validating
Ans:c)filtering
6) Which of the following type of package does Calc refer to?
a) Spreadsheet
b) Double sheet
c) Multi-sheet
d) Cannot determine
Ans:a)spreadsheet
7) Which of the following is an extension of a worksheet created in Calc?
a) .ods
b) .odd
c) .xls
d) .obj
Ans:a).ods
8) How can one calculate the total of values entered in a worksheet column of?
a) By manual entry
b) By auto-sum
c) By formula
d) By sum functions
Ans:d)by sum functions
9) What is the correct way to enter a function in Calc?
a) Directly typing function name in a cell
b) Using function wizard to selecting from toolbar
c) Both (a) and (b)
d) Depends on the function
Ans:d)depends on the function
10) A function should start with———————
a) ‘=’ sign
b) alphabets
c) numbers
d) All of the above
Ans: a)’=’ sign
11) What is Spreadsheet in LibreOffice?
a) Draw
b) Impress
c) Calc
d) Writer
Ans: c)Calc
12) Which key is used with ctrl to add a new line or paragraph within cell of LibreOffice Calc?
a) Shift
b) Alt
c) Tab
d) Enter
Ans: d)Enter
13) What will be the result of formula=”Hello”&””&”World”?
a) “Hello”&””&”World”
b) Hello && World
c) HelloWorld
d) Formula will not work
Ans: c)HelloWorld
14) What will be the result of formula=COUNT(B1:B3)? Where B1=5,B2=4,B3=6
a) 15
b) 3
c) 4
d) 5
Ans: b)3
15) What is the result of formula=MAX(B1:B3) + MIN(B1:B3)? Where B1=5,B2=2,B3=7
a) 7,2
b) 7+2
c) 9
d) 5,7
Ans: c)
16) What is the result of formula=CONCATENATE(“CCC”;”Tyari”)?
a) CCC
b) Tyari
c) CCCTyari
d) CCC Tyari
Ans: c)ccctyari
17) How many types of cell reference in LibreOffice Calc?
a) 1cc
b) 2
c) 3
d) 4
Ans: b)2
18) How many maximum rows & columns in LibreOffice Calc?
a) 1048576 or 1024
b) 1048576 or 16384
c) 16384 or 1048576
d) 1024 or 1048576
Ans: a)1048576or 1024
19) How many maximum worksheets can be in LibreOffice Calc?
a) 256
b) 1028
c) 10000
d) None
Ans: c)10000
20) What is the shortcut key to open cell format dialog box in LibreOffice Calc?
a) Shift + 1
b) Ctrl + 1
c) Alt + 1
d) Ctrl + Alt + 1
Ans: b)ctrl+ 1
21) What is the result of formula=if(C2>20;”Yes”;”No”)? Where C2=5
a) Yes
b) No
Ans: b)no
22) In LibreOffice Calc Spreadsheet can be only one sheet?
a) True
b) False
Ans: b)false
23) What is the shortcut key to insert function in LibreOffice Calc?
a) Shift + F3
b) Ctrl + F2
c) Ctrl + F3
d) Alt + F3
Ans: b)ctrl+f2
24) In LibreOffice Calc COS,EVEN,FACT,EXP functions belong to which category?
a) Data
b) Math / Trig
c) Mathematical
d) String
Ans: c)mathematical
25) What is the shortcut key of print preview in LibreOffice Calc?
a) Ctrl + Shift + P
b) Ctrl + Shift + O
c) Ctrl + P
d) None
Ans: b)ctrl+shift+o
26) Which key is used in LibreOffice Calc to come cell in Edit mode?
a) F2
b) Ctrl + Shift + M
c) Ctrl + M
d) F3
Ans: a)f2
27) Which is key is used to insert time in LibreOffice Calc?
a) Ctrl + ;
b) Ctrl + Shift + ;
c) Ctrl + T
d) None
Ans: b)ctrl+shift+;
28) Which key is used for cell formatting in LibreOffice Calc?
a) Ctrl + 1
b) Ctrl + F2
c) Ctrl + 2
d) Ctrl + M
Ans: a)ctrl+1
29) In which Menu, Merge Cells command found in LibreOffice Calc?
a) Format
B) Style
c) Sheet
d) Edit
Ans: a)format
30) What is the result come in LibreOffice Calc if value is greater than cell?
a) ###
b) Cell become large and right result come
c) ####
d) #Name?
Ans: a)###
31) What is the shortcut key to delete any cell?
a) Ctrl + +
b) Ctrl + –
c) Ctrl + D
d) Delete
Ans: c)ctrl+d
32) In LibreOffice Calc maximum zoom cannot be possible?
a) 300%
b) 200%
c) 400%
d) 500%
Ans: d)500%
33) How many columns in LibreOffice Calc?
a) 1024
b) 1048576
c) 16384
d) None
Ans: a)1024
34) Which shortcut key is used to select a row?
a) Ctrl + Space
b) Shift + Space
c) Ctrl + Shift + Page down
d) None
Ans: b)shift+space
35) What is the by default name of LibreOffice Calc file?
a) Untitled1
b) Calc1
c) Spreadsheet1
d) None
Ans: a)untitled1
36) What is the shortcut key to exit from current window in Calc?
a) Ctrl + w
b) Ctrl + Q
c) Ctrl + Shift + C
d) Shift + w
Ans: a)ctrl+w
37) Which key is used to change any number into currency format in LibreOffice Calc?
a) Ctrl + Shift + 1
b) Ctrl + shift + 5
c) Ctrl + Shift + 4
d) Ctrl + Shift + 3
Ans: c)ctrl+shift+4
38) What is the shortcut key to clear format directly inLibreOffice Calc?
a) Ctrl + v
b) Ctrl + M
c) Ctrl + Shift + F
d) Ctrl + 1
Ans: b)ctrl+m
39) Where Name Box appear?
a) Left side of below Menu bar
b) Left side of above Menu bar
c) At Status bar
d) Right side of below Menu bar
Ans: a)left side of below menu bar
40) Which key is used to come into next sheet?
a) Tab
b) Ctrl + Tab
c) Ctrl + Shift + Tab
d) Shift + Tab
Ans: b)ctrl+tab
41) Which shortcut key is used to Highlight any value in LibreOfficeCalc?
a) Ctrl + F6
b) Ctrl
c) Ctrl + F8
d) Ctrl + F1
Ans: c)ctrl+f8
42) Where the address of any cell appear in LibreOffice Calc?
a) Formula Bar
b) Address Book
c) Name box
d) None
Ans: c)name box
43) What is the address of last cell in Calc?
a) $D$10
b) AMJ1048576
c) XFD1048576
d)$AMD$1048576
Ans: b)amj1048576
44) Which shortcut key is used to select whole sheet in LibreOffice Calc?
a) Ctrl + A
b) Ctrl + Shift + Space
c) Ctrl + Shift + A
d) Both (a) & (b)
Ans: d)both (a)&(b)
45) To unmerge a merged cell in LibreOffice Calc to select that cell and Which key is clicked?
a) Center
b) Split
c) Split and Merge
d) Merge and Center
Ans: d)merge and center
46) What is the address of last column in LibreOffice Calc?
a) AMJ
b) XFD
c) AMG
d) EMJ
Ans: a)amj
47) What will be the result of =round(247,-2)?
a) 247
b) 200
c) 240
d) 200.47
Ans: b)200
48) What will be the result of =10*20/4*8 in LibreOffice Calc?
a) 400
b) 6.25
c) 7
d) 500
Ans: a)400
49) What will be the result of =Product(7,-5)?
a) 35
b) -35
c) 12
d) 2
Ans: b)-35
50) How many axes does chart in Calc have?
a) Two
b) Three
c) Two or Three
d) Four
Ans: a)two