Functions

Qus. 1 : In Libreoffice Calc a formula always starts with a symbol?

1. %
2. $
3. &
4. =

Qus. 2 : What will be the result of the formula = COUNT (B1: B3)? Where B1 = 5, B2 = 4, B3 = 6

1. 15
2. 3
3. 4
4. 5

Qus. 3 : What is the result of the formula = MAX (B1: B3) + MIN (B1: B3)? Where B1 = 5, B2 = 2, B3 = 7

1. 7,2
2. 7+2
3. 9
4. 5,7

Qus. 4 : COS, EVEN, FACT, EXP are which categories of functions in LibreOffice Calc?

1. Data
2. Math / Tring
3. Mathematical
4. String

Qus. 5 : Which shortcut key is used to insert function in libreOffice calc

1. Ctrl + F2
2. Ctrl + F4
3. Ctrl + F3
4. None of these

Qus. 6 : Which sign is visible when there is a formula error in Libreoffice Calc?

1. @
2. #
3. $
4. &

Qus. 7 : What will be the value of = round (247, -2)?

1. 247
2. 200
3. 240
4. 200.47

Qus. 8 : What will be the value of =Product (7, -5)?

1. 35
2. -35
3. 12
4. 2

Qus. 9 : What will be the value of = Product (7, 8)?

1. 1
2. 15
3. 56
4. -1

Qus. 10 : = Value of ROUND (275, -2) .....?

1. 200
2. 300
3. 00
4. 2.75

Qus. 11 : = What will be the value of Ceiling (97,7)?

1. 98
2. 97
3. 91
4. None

Qus. 12 : Which option is used to insert a chart?

1. Chart wizard
2. Pie wizard
3. Object
4. Shap

Qus. 13 : Which shortcut is used to insert function in LibreOffice Calc?

1. Shift + F3
2. Ctrl + F2
3. Ctrl + F3
4. Alt + F3

Qus. 14 : COS, EVEN, FACT, EXP are the function of which category in LibreOffice Calc?

1. Data
2. Text
3. Mathematical
4. String

Qus. 15 : Which Shortcut key used for insert the Current Date in Libreoffice

1. Ctrl + ;
2. Shift + D
3. Ctrl + D
4. Alt + D

Qus. 16 : What will be the value of =floor (1209,11)

1. 1199
2. 1210
3. 1188
4. None

Qus. 17 : = Product (5,2) will result in LibreOffice Clac

1. 10
2. 7
3. 3
4. No one

Qus. 18 : Function inside another function known as ?

1. Nested Function
2. Function
3. General Function
4. Condition Function

Qus. 19 : What is the result of = sum (5,2) in LibreOffice Calc?

1. 7
2. 10
3. 3
4. 1

Qus. 20 : Which shortcut key is used to insert date and time in Libreoffice Calc

1. Ctrl + ;
2. Ctrl + Shift + :
3. A and B both
4. None

Qus. 21 : What will happen if the Excel formula bar does not contain = before the formula?

1. #name?
2. #name
3. Whatever is written in a formula will remain the same
4. ####

Qus. 22 : What will be the value of = product (5,2)?

1. 10
2. 3
3. 7
4. 1

Qus. 23 : Which type of formulas and functions are present in spreadsheet ?

1. Mathematical
2. Financial
3. Statistical, logical
4. All of these

Qus. 24 : How can we calculate the total of values entered in a worksheet of column?

1. By manual entry
2. By auto-sum
3. By formula
4. By sum function

Qus. 25 : Spreadsheet file can be emailed as in LibreOffice Calc as

1. OpenDocument
2. Microsoft Excel
3. PDF
4. All the above

Qus. 26 : Which of the following function is used to display current date and time in LibreOffice Calc?

1. Date( )
2. Date( )
3. Now( )
4. Time( )

Qus. 27 : What will be the value of =round(14243.2567,-2)

1. 14000
2. 14200
3. 14300
4. 14243.25

Qus. 28 : The CALC __________ function counts matching records in a database using criteria and an optional field

1. DCOUNT
2. DCOUNTA
3. DSUM
4. SUM

Programs

---

---

---

---

---

---

---

---