Essay
Truth table and logic gates and VBA Macro.Consider the following worksheet that forms a truth
table row number in A2 and converts the row number into the corresponding logic variable (A, B
and C) input values in C2:E2.Elementary gates are formed: Y = NOT(A) in A5, Y= AND(ABC) in C5
and Y = OR(ABC) in E5.VBA Macro TT_row assigned to the row arrow increments the value in A2
and resets it to 0 if it is greater than 7.
a.What is the Excel formula in C2?
b.What is the Excel formula in D2?
c.What is the Excel formula in E2?
d.What is the Excel formula in A5?
e.What is the Excel formula in C5?
f.What is the Excel formula in E5?
g.Compose Macro TT_row.
Correct Answer:

Verified
Correct Answer:
Verified
Q1: Switch array.Consider the following worksheet that shows
Q2: Digital to Binary to Digital Conversions.Consider
Q3: Modulo-K counter.Consider the following worksheet that forms
Q5: Rand() to form other random numbers
Q6: Using Standardized Gaussian PRNG to generate
Q7: Simple formula with relative and absolute
Q8: Generating random bits with RAND() and
Q9: DAC output with random inputs.Consider the
Q10: Formulas with random time sequence with
Q11: Generating sinusoidal signal in noise and