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