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

Question 1

What is the result returned by the spreadsheet formula =SQRT(81) + 2^3 in LibreOffice Calc or MS Excel?

Accepted Answer

A) 17

Answer

B) 15

Answer

C) 25

Answer

D) 14

Question 2

In LibreOffice Calc, what is the default native file extension used when saving a standard spreadsheet document?

Accepted Answer

B) .ods

Answer

A) .xlsx

Answer

C) .xls

Answer

D) .odt

Question 3

Cell	A	B	C
1	5	10	15
2	20	25	30

Based on the table above, what is the output of the formula =SUMIF(A1:C2, ">12")?

Accepted Answer

C) 90

Answer

A) 70

Answer

B) 85

Answer

D) 105

Question 4

Which keyboard shortcut is used to open the 'Function Wizard' dialog box in LibreOffice Calc?

Accepted Answer

A) Ctrl + F2

Answer

B) Shift + F3

Answer

C) Alt + F1

Answer

D) Ctrl + F4

Question 5

In MS Excel, if the cell formula =$A1 + B$2 located in cell C3 is copied and pasted into cell D4, what does the formula become in D4?

Accepted Answer

B) =$A2 + C$2

Answer

A) =$A1 + C$2

Answer

C) =$B2 + C$3

Answer

D) =$A2 + B$2

Question 6

Which cell display error appears in Excel or Calc when a column is not wide enough to display the formatted number?

Accepted Answer

D) ###

Answer

A) #VALUE!

Answer

B) #REF!

Answer

C) #NAME?

Question 7

What is the fundamental functional difference between =COUNT() and =COUNTA() in spreadsheet applications?

Accepted Answer

C) COUNT counts numeric values only; COUNTA counts all non-empty cells.

Answer

A) COUNT includes text; COUNTA includes only numbers.

Answer

B) COUNT counts blank cells; COUNTA counts filled cells.

Answer

D) Both functions perform identical operations.

Question 8

What is the maximum number of rows available in a single worksheet of Microsoft Excel 2016 or LibreOffice Calc 7.0+?

Accepted Answer

A) 1,048,576

Answer

B) 65,536

Answer

C) 524,288

Answer

D) 2,097,152

Question 9

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

Accepted Answer

B) Text is left-aligned; Numbers are right-aligned

Answer

A) Text is right-aligned; Numbers are left-aligned

Answer

C) Both text and numbers are left-aligned

Answer

D) Both text and numbers are center-aligned

Question 10

Cell	A	B	C
1	5	10	15
2	20	25	30

Refer to the grid above. What is the value evaluated by the formula =A1/B1 + A2*B2?

Accepted Answer

D) 19

Answer

A) 11

Answer

B) 22

Answer

C) 14

Question 11

Which spreadsheet function returns the current system date without including the current time?

Accepted Answer

A) =TODAY()

Answer

B) =NOW()

Answer

C) =DATE()

Answer

D) =CURRENTDATE()

Question 12

In Microsoft Excel, which function key automatically creates a chart sheet from selected cell data instantly?

Accepted Answer

B) F11

Answer

A) F2

Answer

C) F4

Answer

D) F7

Question 13

Cell	A	B	C
1	5	10	15
2	20	25	30

Using the lookup table above, what is returned by =VLOOKUP(102, A1:C3, 3, FALSE)?

Accepted Answer

C) 92

Answer

A) Anish

Answer

B) Priya

Answer

D) 78

Question 14

What is the shortcut key to clear direct formatting applied to selected cells in LibreOffice Calc?

Accepted Answer

A) Ctrl + M

Answer

B) Ctrl + Shift + F

Answer

C) Alt + Shift + C

Answer

D) Ctrl + Backspace

Question 15

Which prefix character forces Excel or Calc to treat a number or formula as plain literal text?

Accepted Answer

D) Single quote (')

Answer

A) Double quotes (")

Answer

B) Hash sign (#)

Answer

C) Tilde (~)

Question 16

Cell	A	B	C
1	5	10	15
2	20	25	30

From the data table above, calculate the output of =SUM(SQRT(A1), SQRT(B2)).

Accepted Answer

B) 7

Answer

A) 5

Answer

C) 9

Answer

D) 13

Question 17

Which shortcut key combination toggles between displaying cell formulas and displaying evaluated cell results in MS Excel?

Accepted Answer

C) Ctrl + `

Answer

A) Ctrl + Shift + F

Answer

B) Alt + F8

Answer

D) Shift + F11

Question 18

Which specific error code is displayed by Calc or Excel when a formula contains a cell reference that has been deleted?

Accepted Answer

B) #REF!

Answer

A) #NULL!

Answer

C) #VALUE!

Answer

D) #NUM!

Question 19

What text value is generated by evaluating the string formula ="Data" & " " & "Science"?

Accepted Answer

A) Data Science

Answer

B) DataScience

Answer

C) "Data Science"

Answer

D) Data&Science

Question 20

Cell	A	B	C
1	5	10	15
2	20	25	30

Given column values A1:A4 above, what is the output of =AVERAGE(A1:A4)?

Accepted Answer

C) 30

Answer

A) 25

Answer

B) 28

Answer

D) 35