Google News
logo
Microsoft Excel - Quiz(MCQ)
Which is the correct syntax of the HEX2BIN() function in MS Excel?
A)
=HEX2BIN (number)
B)
=HEX2BIN (number, BASE)
C)
=HEX2BIN (number, BASE, [places])
D)
=HEX2BIN (number, [places])

Correct Answer : Option (D) :   =HEX2BIN (number, [places])


Explanation :

The correct syntax of HEX2BIN() function in MS Excel is:
 
=HEX2BIN (number, [places])
 
Example:
 
=HEX2BIN("F") // Return 1111
=HEX2BIN("F",8) // Returns 00001111

Advertisement