Welcome to your LibreOffice Calc
1.
What is the name of mechanism to filter out unnecessary data?
2.
We can replace multiple occurrences of a word using which of the following facilities of Calc?
3.
How many maximum rows & columns in LibreOffice Calc?
4.
What is the name of mechanism to arrange the data in a particular order?
5.
Which of the following is an extension of a worksheet created in Calc?
6.
What will be the result of formula=”Hello”&””&”World”?
7.
How can one calculate the total of values entered in a worksheet column of?
8.
A function should start with---------------------
9.
Which key is used with ctrl to add a new line or paragraph within cell of LibreOffice Calc?
10.
What is the correct way to enter a function in Calc?
11.
What is Spreadsheet in LibreOffice?
12.
Which of the following type of package does Calc refer to?
13.
What is the result of formula=CONCATENATE(“CCC”;”Tyari”)?
14.
What is the shortcut key to open cell format dialog box in LibreOffice Calc?
15.
Which of the following options when selected deletes all data validation?
16.
How many types of cell reference in LibreOffice Calc?
17.
Which of the following techniques can be used to allow only date value in cell?
18.
What is the result of formula=MAX(B1:B3) + MIN(B1:B3)? Where B1=5,B2=2,B3=7
19.
How many maximum worksheets can be in LibreOffice Calc?
20.
What will be the result of formula=COUNT(B1:B3)? Where B1=5,B2=4,B3=6
