Home » MCQs » Microsoft Excel MCQs

Which is the correct syntax of the HEX2BIN() function in MS Excel?

56. Which is the correct syntax of the HEX2BIN() function in MS Excel?

1. =HEX2BIN (number, [places])
2. =HEX2BIN (number)
3. =HEX2BIN (number, BASE, [places])
4. =HEX2BIN (number, BASE)

Answer: A) =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