|
Part Six: Creating the worksheet to record your data
1. On your lab computer, open Excel and start a new spreadsheet. Label the columns
“Frequency,” “Vin,” “dV,” “Vout,” “Delay,” “Phase” and “Gain.”
2. Below “Frequency,” enter each frequency you plan to test (refer to your lab procedures).
3. Below “Vout” in cell D2, enter this formula: =B2+C2
4. Press return. The “=B2+C2” turns into a zero since we haven’t entered anything into B2 or C2.
5. Press Ctrl+D, then return. The formula gets copied from D2 into D3, with Excel changing its
formula into “=B3+C3” automatically. Keep pressing Ctrl+D then return until you fill the column for
each of your frequencies.
|
|