DAC Output with Random Inputs

DAC output with random inputs.Consider the following worksheet that shows ten random
samples in Column B that have been matched to a b-bit quantizer with Δ=1 and b specified in
B1.The maximum amplitude that is matched to the quantizer is computed in D1.Column C
computes the b-bit code using the Excel formula that converts a numerical value to its quantized
b-bit binary value.Column D computes the b-bit DAC level using the Excel formula that converts
a binary value to its decimal value.
a.What is the Excel formula in D1?
b.What is the Excel formula in B7?
c.What is the Excel formula in C7?
d.What is the Excel formula in D7?
$$\begin{array} { | c | c | c | c | c | } \hline & A & B & C & D \\\hline 1 & \mathrm {~b} = & 6 & \mathrm {~V} _ { \max } = & 63 \\\hline 2 & & & & \\\hline 3 & \mathrm { i } & \mathrm { S } _ { \mathrm { i } } & \text { bit-code } & \text { DAC Level } \\\hline 4 & 0 & 32.63 & 100000 & 32 \\\hline 5 & 1 & 40.59 & 101000 & 40 \\\hline 6 & 2 & 28.06 & 011100 & 28 \\\hline 7 & 3 & 42.19 & 101010 & 42 \\\hline 8 & 4 & 15.98 & 001111 & 15 \\\hline 9 & 5 & 8.04 & 001000 & 8 \\\hline 10 & 6 & 42.73 & 101010 & 42 \\\hline 11 & 7 & 33.69 & 100001 & 33 \\\hline 12 & 8 & 5.95 & 000101 & 5 \\\hline 13 & 9 & 19.92 & 010011 & 19 \\\hline\end{array}$$