Binary and Decimal Conversions

This video tutorial explains how to convert binary numbers to decimal numbers and vice versa, using both manual calculations and Excel functions. It provides examples of binary to decimal conversion and demonstrates how to use Excel's DECIMAL and BASE functions for these conversions. The video also covers alternative Excel functions like BINARY2DECIMAL and DECIMAL2BINARY, offering a comprehensive guide to binary-decimal conversions.

What is the decimal equivalent of the binary number 1010?

• 14

• 10

• 8

• 12

In the binary number 11001, which decimal values are added to get the final result?

• 8, 2, 1

• 16, 4, 1

• 8, 4, 2

• 16, 8, 1

What is the decimal value of the binary number 101101?

• 94

• 92

• 88

• 90

Which Excel function can be used to convert a binary number to a decimal number?

• CONVERT

• BINARY2DEC

• BIN2DEC

• DECIMAL

How do you specify the base when using the DECIMAL function in Excel?

• By writing 'base2'

• By writing '2' after a comma

• By writing 'base=2'

• By writing 'binary'

What is the result of using the function =BINARY2DECIMAL(11001) in Excel?

• 26

• 25

• 24

• 27

Which function can be used to convert a decimal number back to binary in Excel?

• CONVERT

• DECIMAL2BINARY

• BASE

• DEC2BIN

What binary number do you get when you convert the decimal number 90 using the BASE function?

• 101101

• 1011101

• 1101010

• 1011010

What is the alternative function to DECIMAL for converting binary to decimal in Excel?

• DECIMAL2BIN

• BINARY2DECIMAL

• BIN2DEC

• BASE

What is the main topic covered in this video tutorial?

• Binary to hexadecimal conversion

• Binary to decimal conversion

• Decimal to binary conversion

• Decimal to hexadecimal conversion