Anyone here good at using microsoft excel? I am suppose to construct a simulation output of a digitally oscillating signal using microsoft excel. Here are the requirements:
simulation must include 100 data points.
signal must oscillate at 100 Hz.
two full periods of the signal should be shown on the chart.
duty cycle should be equal to 50%.
signal must alternate between 0 and 5 volts.
Hint given was: simulation can be completed quickly using a time column and the "IF" function in Excel's function list.
My question is how exactly do you go about doing this in Excel? Thanks for any help given!
simulation must include 100 data points.
signal must oscillate at 100 Hz.
two full periods of the signal should be shown on the chart.
duty cycle should be equal to 50%.
signal must alternate between 0 and 5 volts.
Hint given was: simulation can be completed quickly using a time column and the "IF" function in Excel's function list.
My question is how exactly do you go about doing this in Excel? Thanks for any help given!