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?
$\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}$

Question

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?
 $\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}$

Quizplus · Accepted Answer

The Answer of 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?
 $\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}$