Competitive Exams : Computer Awareness - Microsoft Excel and LibreOffice Calc (Set 1)

Question 1

What is the default file extension for a spreadsheet document saved in LibreOffice Calc?

Accepted Answer

B) .ods

Answer

A) .xlsx

Answer

C) .doc

Answer

D) .odp

Question 2

What is the total number of rows available in a standard Microsoft Excel (2007 and later) worksheet?

Accepted Answer

B) 1,048,576

Answer

A) 65,536

Answer

C) 524,288

Answer

D) 2,097,152

Question 3

Which keyboard shortcut is used to edit the content of an active cell in both MS Excel and LibreOffice Calc?

Accepted Answer

C) F2

Answer

A) F4

Answer

B) F7

Answer

D) F11

Question 4

In Microsoft Excel and LibreOffice Calc, which character must precede any formula entry?

Accepted Answer

B) =

Answer

A) @

Answer

C) #

Answer

D) $

Question 5

Which formula function returns the current system date without the current time in both MS Excel and LibreOffice Calc?

Accepted Answer

C) TODAY()

Answer

A) NOW()

Answer

B) DATE()

Answer

D) CURRENT()

Question 6

In MS Excel, which keyboard shortcut inserts the current system time into the active cell?

Accepted Answer

B) Ctrl + Shift + ;

Answer

A) Ctrl + ;

Answer

C) Alt + ;

Answer

D) Shift + F3

Question 7

What type of cell reference is represented by $ C $ 5 in spreadsheet applications like MS Excel and Calc?

Accepted Answer

C) Mixed cell reference

Answer

A) Relative cell reference

Answer

B) Absolute cell reference

Answer

D) Circular cell reference

Question 8

In MS Excel and LibreOffice Calc, what is the default cell reference type when selecting a cell while entering a formula?

Accepted Answer

A) Relative reference

Answer

B) Absolute reference

Answer

C) Mixed reference

Answer

D) 3D reference

Question 9

What is the output of the formula $=COUNT(1, "2", "Excel", TRUE, 5)$ in MS Excel when entered directly as arguments?

Accepted Answer

C) 4

Answer

A) 2

Answer

B) 3

Answer

D) 5

Question 10

In LibreOffice Calc, which key combination is used to automatically insert the current system time into the active cell?

Accepted Answer

A) Ctrl + Shift + ;

Answer

B) Ctrl + ;

Answer

C) Alt + Shift + T

Answer

D) Shift + F3

Question 11

What is the maximum number of rows available in a single worksheet in Microsoft Excel 2010 and later versions?

Accepted Answer

B) 1,048,576

Answer

A) 65,536

Answer

C) 16,384

Answer

D) 1,000,000

Question 12

In Microsoft Excel, what does the error code #DIV/0! indicate?

Accepted Answer

A) A formula is trying to divide by zero or an empty cell

Answer

B) An unrecognized text string is used in a formula

Answer

C) An invalid cell reference is specified

Answer

D) A value is not available to a function

Question 13

In LibreOffice Calc, what is the default OpenDocument file format extension for saving spreadsheet files?

Accepted Answer

B) .ods

Answer

A) .xlsx

Answer

C) .xls

Answer

D) .odt

Question 14

What will be the result of evaluating the formula $=LEN("MS Excel 365")$ in MS Excel?

Accepted Answer

C) 12

Answer

A) 10

Answer

B) 11

Answer

D) 13

Question 15

Which tool in MS Excel and LibreOffice Calc allows copying formatting attributes from one cell and applying them to another?

Accepted Answer

B) Format Painter

Answer

A) AutoFill

Answer

C) Conditional Formatting

Answer

D) Cell Styles

Question 16

What is the output of the formula $=PRODUCT(2, 3, SQRT(16))$ in Microsoft Excel?

Accepted Answer

B) 24

Answer

A) 18

Answer

C) 32

Answer

D) 48

Question 17

Which keyboard shortcut is used to edit the active cell in Microsoft Excel and LibreOffice Calc?

Accepted Answer

A) F2

Answer

B) F4

Answer

C) F7

Answer

D) F11

Question 18

Which symbol is placed before a column letter and row number to create an absolute cell reference (e.g., $ A $ 1)?

Accepted Answer

C) $

Answer

A) #

Answer

B) &

Answer

D) %

Question 19

What is the output of the nested formula $=MAX(10, MIN(20, 5), 15)$ in MS Excel?

Accepted Answer

C) 15

Answer

A) 5

Answer

B) 10

Answer

D) 20

Question 20

In MS Excel, setting the fourth argument (range_lookup) of the VLOOKUP function to FALSE (or 0) specifies:

Accepted Answer

A) An exact match search

Answer

B) An approximate match search

Answer

C) Ascending order sorting

Answer

D) A case-sensitive search

Set 1Competitive Exams : Computer Awareness - Microsoft Excel and LibreOffice Calc