Solved

Digital to Binary to Digital Conversions

Question 2

Essay

Digital to Binary to Digital Conversions.Consider the following worksheet that converts the
specified decimal digit in A3 into its 4-bit binary representation in C3:F3 and the specified 4-bit
binary sequence in A7:D7 into its decimal equivalent in F7.
a.What is the Excel formula in E3?
b.What is the Excel formula in F7?
ABCDEF1 decimal to binary 2 decimal b3 b2 b1 b038100045 binary to decimal 6 b3 b2 b1 b0 decimal 7111014\begin{array}{|c|c|c|c|c|c|c|}\hline&A&B&C&D&E&F\\\hline1&\text { decimal to binary }\\\hline 2 & \text { decimal } & & \mathrm{b}_{3} & \mathrm{~b}_{2} & \mathrm{~b}_{1} & \mathrm{~b}_{0} \\\hline 3 & 8 & & 1 & 0 & 0 & 0 \\\hline4\\\hline5&\text { binary to decimal }\\\hline 6 & \mathrm{~b}_{3} & \mathrm{~b}_{2} & \mathrm{~b}_{1} & \mathrm{~b}_{0} & & \text { decimal } \\\hline 7 & 1 & 1 & 1 & 0 & & 14 \\\hline\end{array}

Correct Answer:

verifed

Verified

Related Questions