Which option is used to hide/show the Headings in MS Excel?
View Menu > Show Group > Headings
View Menu > Show Group > Gridlines
View Menu > Show Group > Headers
View Menu > Show Group > Titles
Correct answer is A
No explanation has been provided for this answer.
Workbook Statistics
Statistics
Excel Statistics
Workbook Analysis
Correct answer is A
No explanation has been provided for this answer.
Which function is used to find the sum of complex numbers in MS Excel?
SUM()
ADD()
CSUM()
IMSUM()
Correct answer is D
Example:
=IMSUM("1-2i", "2+4i") // Returns 3+2i
Which is the correct syntax of the HEX2BIN() function in MS Excel?
=HEX2BIN (number, [places])
=HEX2BIN (number)
=HEX2BIN (number, BASE, [places])
=HEX2BIN (number, BASE)
Correct answer is A
Example:
=HEX2BIN("F") // Return 1111
=HEX2BIN("F",8) // Returns 00001111
Which function is used to remove extra spaces from the text in MS Excel?
REMOVE()
TRIM()
TRUNC()
All of the above
Correct answer is B
The TRIM() function in Excel removes extra spaces from text. It deletes all leading, trailing and in-between spaces except for a single space character between words.
Syntax:
=TRIM (text)
Example:
=TRIM(" Hello World! ") // Returns "Hello World!"