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

Question 1

A user saves a spreadsheet document in LibreOffice Calc and another in MS Excel (2016).

What are the standard default file extensions for LibreOffice Calc and MS Excel (.xlsx era) respectively?

Accepted Answer

A) .ods and .xlsx

Answer

B) .calc and .xls

Answer

C) .xls and .ods

Answer

D) .xlsx and .ods

Question 2

Which spreadsheet function counts only the cells containing numeric values within a given range?

Accepted Answer

B) COUNT

Answer

A) COUNTIF

Answer

C) COUNTA

Answer

D) SUM

Question 3

By default, how are text values and numeric values aligned horizontally inside cell boundaries in MS Excel and LibreOffice Calc?

Accepted Answer

C) Text is Left-aligned; Numbers are Right-aligned

Answer

A) Both text and numbers are Left-aligned

Answer

B) Text is Right-aligned; Numbers are Left-aligned

Answer

D) Both text and numbers are Center-aligned

Question 4

What value is returned when the formula =MOD(29, 4) is evaluated in a spreadsheet cell?

Accepted Answer

B) 1

Answer

A) 7

Answer

C) 0.25

Answer

D) 4

Question 5

Which keyboard shortcut is used in Microsoft Excel to instantly insert the current system date into the selected cell?

Accepted Answer

B) Ctrl + ;

Answer

A) Ctrl + Shift + ;

Answer

C) Alt + Shift + D

Answer

D) Ctrl + D

Question 6

In both MS Excel and LibreOffice Calc, what type of cell reference is $B$5?

Accepted Answer

C) Absolute cell reference

Answer

A) Relative cell reference

Answer

B) Mixed cell reference

Answer

D) Dynamic cell reference

Question 7

What is the output of the text function formula =LEN("Calc 2026")?

Accepted Answer

B) 9

Answer

A) 8

Answer

C) 4

Answer

D) 10

Question 8

What is the total number of rows supported per worksheet in modern MS Excel (.xlsx format)?

Accepted Answer

B) 1,048,576

Answer

A) 65,536

Answer

C) 512,000

Answer

D) 2,097,152

Question 9

Which spreadsheet function returns both the current date and current time dynamically?

Accepted Answer

B) NOW()

Answer

A) TODAY()

Answer

C) CURRENT()

Answer

D) TIME()

Question 10

Evaluating the formula =UPPER("excel") in a spreadsheet cell produces:

Accepted Answer

B) EXCEL

Answer

A) Excel

Answer

C) excel

Answer

D) #VALUE!

Question 11

Which standard error code displays in a cell when a formula attempts to divide a numerical value by zero or an empty cell?

Accepted Answer

C) #DIV/0!

Answer

A) #VALUE!

Answer

B) #N/A

Answer

D) #REF!

Question 12

Which keyboard shortcut key toggles the worksheet display between cell values and underlying formulas in MS Excel?

Accepted Answer

A) Ctrl + ~

Answer

B) Alt + F9

Answer

C) Shift + F3

Answer

D) Ctrl + F1

Question 13

Which formula correctly rounds the value 45.678 to two decimal places in LibreOffice Calc or MS Excel?

Accepted Answer

A) =ROUND(45.678, 2)

Answer

B) =TRUNC(45.678, 2)

Answer

C) =INT(45.678)

Answer

D) =ROUNDUP(45.678, 1)

Question 14

Which operator is used to join or concatenate two text strings in a cell without calling the CONCATENATE function?

Accepted Answer

B) &

Answer

A) +

Answer

C) #

Answer

D) @

Question 15

How is a rectangular cell range spanning from cell A1 to cell D10 designated in LibreOffice Calc and Excel formulas?

Accepted Answer

C) A1:D10

Answer

A) A1-D10

Answer

B) A1..D10

Answer

D) A1;D10

Question 16

What is the result of evaluating the logical formula =IF(OR(10>20, 5=5), "Yes", "No")?

Accepted Answer

A) Yes

Answer

B) No

Answer

C) FALSE

Answer

D) TRUE

Question 17

Which function searches for a lookup value in the first column of a table and returns a value in the same row from a specified column?

Accepted Answer

B) VLOOKUP

Answer

A) HLOOKUP

Answer

C) INDEX

Answer

D) MATCH

Question 18

In Microsoft Excel, which shortcut key combination opens the Format Cells dialog box?

Accepted Answer

A) Ctrl + 1

Answer

B) Ctrl + F

Answer

C) Alt + F11

Answer

D) Shift + F1

Question 19

Under which menu tab will you find the "Freeze Panes" feature in modern MS Excel and LibreOffice Calc?

Accepted Answer

C) View

Answer

A) Insert

Answer

B) Data

Answer

D) Format

Question 20

What is the output of the mathematical formula =POWER(3, 3) in a spreadsheet?

Accepted Answer

B) 27

Answer

A) 9

Answer

C) 81

Answer

D) 6