1) Which of the following technique can be used to allow only date value in cell.
a) Data formatting
b) Data sorting
c) Data filtering
d) Data validation
Ans: d)
2) Which of the following options when selected deletes all data validation?
a) Delete formatting
b) Delete all
c) Delete formula
d) Delete me
Ans: a)
3) We can replace multiple occurrences of a word using which of the following facilities of Calc?
a) Find and replace
b) By copy only
c) By copy command
d) By preview command
Ans: a)
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)
5) What is the name of mechanism to filter out unnecessary data?
a) Sorting
b) Searching
c) Filtering
d) Validating
Ans: c)
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)
7) Which of the following is an extension of a worksheet created in Calc?
a) .ods
b) .odd
c) .xls
d) .obj
Ans: a)
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)
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)
10) A function should start with……………..
a) ‘=’ sign
b) alphabets
c) numbers
d) All of the above
Ans: a)
11) What is Spreadsheet in LibreOffice?
a) Draw
b) Impress
c) Calc
d) Writer
Ans: c)
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)
13) What will be the result of formula=”Hello”&””&”World”?
a) “Hello”&””&”World”
b) Hello & & World
c) Hello World
d) Formula will not work
Ans: c)
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)
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)
17) How many types of cell reference in LibreOffice Calc?
a) 1
b) 2
c) 3
d) 4
Ans: b)
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)
19) How many maximum worksheets can be in LibreOffice Calc?
a) 256
b) 1028
c) 10000
d) None
Ans: c)
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)
21) What is the result of formula=if(C2>20;”Yes”;”No”)? Where C2=5
a) Yes
b) No
Ans: b)
22) In LibreOffice Calc Spreadsheet can be only one sheet?
a) True
b) False
Ans: b)
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)
24) In LibreOffice Calc COS,EVEN,FACT,EXP functions belong to which category?
a) Data
b) Math / Tring
c) Mathematical
d) String
Ans: c)
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)
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)
27) Which is key is used to insert time in LibreOffice Calc?
a) Ctrl + ;
b) Ctrl + Shift + ;
c) Ctrl + T
d) None
Ans: b)
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)
29) In which Menu, Merge Cells command found in LibreOffice Calc?
a) Format
B) Style
c) Sheet
d) Edit
Ans: a)
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: b)
32) In LibreOffice Calc maximum zoom cannot be possible?
a) 300%
b) 200%
c) 400%
d) 500%
Ans: d)
33) How many columns in LibreOffice Calc?
a) 1024
b) 1048576
c) 16384
d) None
Ans: a)
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)
35) What is the by default name of LibreOffice Calc file?
a) Untitled1
b) Calc1
c) Spreadsheet1
d) None
Ans: a)
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)
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)
38) What is the shortcut key to clear format directly in LibreOffice Calc?
a) Ctrl + v
b) Ctrl + M
c) Ctrl + Shift + F
d) Ctrl + 1
Ans: b)
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)
40) Which key is used to come into next sheet?
a) Tab
b) Ctrl + Tab
c) Ctrl + Shift + Tab
d) Shift + Tab
Ans: b)
41) Which shortcut key is used to Highlight any value in LibreOffice Calc?
a) Ctrl + F6
b) Ctrl
c) Ctrl + F8
d) Ctrl + F1
Ans: c)
42) Where the address of any cell appear in LibreOffice Calc?
a) Formula Bar
b) Address Book
c) Name box
d) None
Ans: c)
43) What is the address of last cell in Calc?
a) $D$10
b) AMJ1048576
c) XFD1048576
d)$AMD$1048576
Ans: b)
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)
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)
46) What is the address of last column in LibreOffice Calc?
a) AMJ
b) XFD
c) AMG
d) EMJ
Ans: a)
47) What will be the result of =round(247,-2)?
a) 247
b) 200
c) 240
d) 200.47
Ans: b)
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)
49) What will be the result of =Product(7,-5)?
a) 35
b) -35
c) 12
d) 2
Ans: b)
50) How many axes does chart in Calc have?
a) Two
b) Three
c) Two or Three
d) Four
Ans: a)
51) Which of the following option is used to print a chart?
a) Insert -> Chart
b) File -> View
c) File -> Print
d) View -> Chart
Ans: c)
52) The Chart preview can be seen in—
a) Page preview
b) Chart preview
c) Export chart
d) All of these
Ans: d)
53) In LibreOffice Calc to back one cell left which key is used?
a) Alt + Tab
b) Tab
c) Alt
d) Shift + Tab
Ans: d)
54) Shortcut key for reach to last edit cell in LibreOffice Calc?
a) Ctrl + End
b) Shift + End
c) Alt + End
d) Ctrl + Shift + End
Ans: a)
55) In LibreOffice Calc to add cell which shortcut key is used?
a) Ctrl + +
b) Ctrl + –
c) Ctrl + :
d) None
Ans: a)
56) If the cell address changes after copying the formula, the address is known as…….
a) Relative address
b) Absolute address
c) Mixed address
d) Dynamic address
Ans: a)
57) Calc is capable for which of the following…..
a) Store data
b) Manipulate data
c) Create graphical representation of data
d) All of these
Ans: d)
58) Which sign is visible when there is a formula error in LibreOffice Calc?
a) $
b) *
c) /
d) #
Ans: d)
59) In which menu is the Merge Cells command found in LibreOffice Calc?
a) Format
b) Style
c) Sheet
d) Edit
Ans: a)
60) What is the shortcut key to superscript in LibreOffice Calc?
a) Ctrl + Shift + B
b) Ctrl + Shift +P
c) Ctrl + Shift + +
d) None of these
Ans: b)
61) What is the matching point of row and column called?
a) Cell
b) Column
c) Row
d) Sheet
Ans: a)
62) In Calc, most common commands present in which Bar?
a) Title bar
b) Standard Toolbar
c) Formatting Toolbar
d) Formula Bar
Ans: b)
63) What is included in Calc to prepare result analysis and merit list preparation?
a) Calculating result
b) Sorting on result
c) Filtering on result
d) All of these
Ans: d)
64) Which option is used to insert a chart?
a) Chart wizard
b) Pie wizard
c) Object
d) Shape
Ans: a)
65) What you do to write from Monday to Sunday in LibreOffice Calc?
a) Monday, hold down right corner and pull down
b) Do enter press by writing Monday
c) = week() uses the function
d) All of the above
Ans: a)
66) Which options are available in scroll button on LibreOffice Calc?
a) Up and Down scroll
b) Right and left
c) Horizontal and vertical
d) All of the above
Ans: a)
67) Which type of facilities does spreadsheet gives to make the work easy?
a) To add data
b) Formatting
c) To add formula
d) All of these
Ans: d)
68) Where are the options like line, curve, polygon are available?
a) Shape
b) Object
c) Chart
d) Pie
Ans: a)
69) What is the shortcut key for Paste Special?
a) Ctrl + Shift + V
b) Ctrl + V
c) Ctrl + Alt + V
d) Shift + V
Ans: a)
70) Which program is used for fast and accurate calculations as well as formatting of data in a document?
a) Calc
b) Base
c) Writer
d) Impress
Ans: a)
71) Which type of Formulas and functions are present in spreadsheet?
a) Mathematical
b) Financial
c) Statistical, logical
d) All of these
Ans: d)
72) What will be the value of Ceiling (97,7)?
a) 98
b) 97
c) 91
d) None
Ans: a)
73) Which menu is used to toolbar can be turn off and on?
a) File
b) Edit
c) View
d) Insert
Ans: c)
74) Before printing we see the document on screen, what is called this process?
a) Print View
b) Print Preview
c) Print Screen
d) Print Document
Ans: b)
75) What tools are available on Standard toolbar?
a) Bold, Italic, Underline
b) Left, Center, Right, Justify
c) Font Name, Font Size, Font color
d) None of these
Ans: d)
76) What will be the value of floor (1209,11)?
a) 1199
b) 1210
c) 1188
d) None
Ans: a)
77) Which key do you use to comment in LibreOffice?
a) Ctrl + Shift + C
b) Ctrl + C
c) Ctrl + Shift + T
d) Ctrl + Alt + C
Ans: CTRL + ALT + C
78) Which dialog box is open when we click Save As option in file menu?
a) Save As
b) Save
c) Save File
d) Save As File
Ans: a)
79) How many sheets we can insert in LibreOffice Calc?
a) 32000
b) 48000
c) 60000
d) None of these
Ans: d)
80) Which key will be used to select the entire sheet in LibreOffice Calc?
a) Ctrl + A
b) Ctrl + Shift + Space
c) Ctrl + Shift + A
d) Both (a) & (b)
Ans: a)
81) How many sheets does LibreOffice Calc have?
a) 256
b) 1028
c) 10000
d) None
Ans: c)
82) What is the use of Shortcut key Ctrl + F12 in LibreOffice Calc?
a) Insert function
b) Insert media
c) Insert image
d) Insert document
Ans: a)
83) What is the result of formula=product(2,sum(5,7)) in LibreOffice Calc?
a) 24
b) 42
c) 20
d) 22
Ans: a)
84) What is the shortcut key to select a Column in LibreOffice Calc?
a) Shift + Spacebar
b) Ctrl + Spacebar
c) Shift + +
d) Ctrl + +
Ans: a)
85) From the following , which options are available in Edit menu?
a) Cut, Copy, Paste
b) Find and Replace
c) Select All
d) All of these
Ans: d)
86) Pivot table option in LibreOffice Calc is found in which of the following menu?
a) Tools
b) Data
c) Format
d) None
Ans: b)
87) What will be the result of formula=abs(-67) in LibreOffice Calc?
a) -67
b) 67
c) 76
d) -76
Ans: b)
88) What will be the result of formula=int(45.6) in LibreOffice Calc?
a) 45.6
b) 45
c) 46
d) None
Ans: b)
89) What will be the result of formula=today() in LibreOffice Calc?
a) Gives Current System Date
b) Gives Current System date and time
c) Gives Current Month
d) None
Ans: a)