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