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.
Sub TT_row()
Range("A2").Value = Range("A2").Value + 1
If Range("A2").Value > 7 Then
Range("A2").Value = 0
End If
End Sub
You might also like to view...
What kind of geometric characteristic symbol is shown in Figure 6?
a. Datum b. Flatness c. Parallelism d. Straightness
Cells and batteries have a fixed polarity, which gives rise to a ____ current flow.
a. direct b neutral c. multi-directional d. unidirectional
Permanent antifreeze is mostly ________
A) Glycerin B) Methanol C) Ethylene glycol D) Kerosene
How does a three-state device switch between normal and high-impedance modes?
A) It is in high-impedance mode when the data input is LOW. B) It is in the normal mode when the data input is LOW. C) It uses an extra input called an enable input to select modes. D) It is in normal mode whenever the clock is LOW.