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?
- =HEX2BIN (number, [places])
- =HEX2BIN (number)
- =HEX2BIN (number, BASE, [places])
- =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