Formulas - O Level (NIELIT)

Qus. 1 : Which error code indicates the missing equals sign from the formula in calc?

Qus. 2 : Shortcut to trace dependents in LibreOffice Calc is ___

Shift+F2
Shift+F5
Shift+F3
CTRL+F9

Qus. 3 : what will be the output of =100/-10/2 in LibreOffice calc?

-5
5
25
50

Qus. 4 : What will be the result of =A1+A2? if sheet is empty (i.e. No value present in A1 and A2)

Qus. 5 : What is a cell reference in LibreOffice Calc?

A unique identifier for each cell in the spreadsheet
A function used to format cells
A hyperlink to another cell or document
A shortcut key for accessing cells

Qus. 6 : Which of these is a correct formula?

=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16

Qus. 7 : Match the following error types in LibreOffice Calc with their meanings.<table class="table table-bordered"><tbody><tr><td>Error Type</td><td>Meaning</td></tr><tr><td>A. #DIV/0!</td><td>1. Reference to a deleted or invalid cell</td></tr><tr><td>B. #NAME?</td><td>2. Attempted to divide by zero or by an empty cell</td></tr><tr><td>C. #REF!</td><td>3. Wrong data type or operation on incompatible values</td></tr><tr><td>D. #VALUE!</td><td>4. Invalid function name or unrecognized text in formula</td></tr></tbody></table>

A-1, B-2, C-3, D-4
A-3, B-1, C-4, D-2
A-4, B-3, C-2, D-1
A-2, B-4, C-1, D-3

Qus. 8 : Match the following LibreOffice Calc Error code with its description <table class="table table-bordered"><tbody><tr><td>Error Code</td><td>Description</td></tr><tr><td>1 #DIV/0!</td><td>A Invalid value or function used</td></tr><tr><td>2 #NAME?</td><td>B Division by zero error</td></tr><tr><td>3 #REF!</td><td>C Incorrect argument or operand</td></tr><tr><td>4 #VALUE!</td><td>D Invalid reference, possibly due to deleted cells</td></tr><tr><td> </td><td>E Data type mismatch in the function</td></tr><tr><td> </td><td>F Function name not recognized or misspelled</td></tr></tbody></table>