ECE 304: Using EXCEL Preliminaries ..................................................................................................................... 3 Construction of Spreadsheet............................................................................................. 3 Figure 1:..................................................................................................................... 3 FORMAT CELLS menu with selected font settings. ............................................... 3 Using WordArt in EXCEL ....................................................................................................3 Figure 2:..................................................................................................................... 4 WORD ART menu with selection circled............................................................... 4 Figure 3:..................................................................................................................... 4 EDIT WORDART TEXT menu ................................................................................. 4 Figure 4:..................................................................................................................... 5 FORMAT WORDART menu with black FILL COLOR selected and the SEMITRANSPARENT box unchecked .....................................................................5 Figure 5:..................................................................................................................... 5 The spreadsheet after adding WordArt............................................................... 5 Figure 6:..................................................................................................................... 5 The spreadsheet after adding the row labels...................................................... 5 Setting Fonts.....................................................................................................................5 Figure 7:..................................................................................................................... 6 Spreadsheet after putting variables in D4-D7..................................................... 6 Figure 8:..................................................................................................................... 6 Selecting the Symbol font for β........................................................................... 6 Naming Variable Cells....................................................................................................... 6 Figure 9:..................................................................................................................... 7 Naming the variables in cells E4-E8 ................................................................... 7 Figure 10:................................................................................................................... 7 Spreadsheet after coloring Input Cells green and Output Cells blue.................. 7 Filling in a Series...............................................................................................................7 Figure 11:................................................................................................................... 8 The SERIES menu showing selection of the GROWTH option with each step incremented by a factor given by the STEP VALUE of 2. The fill is to stop at a frequency of 10GHz,........................................................................................... 8 Figure 12:................................................................................................................... 8 The first few cells of the Calculate Worksheet with the frequencies entered as powers of 2. ........................................................................................................ 8 Naming Variable Arrays .................................................................................................... 8 Entering Formulas using Built-in Functions....................................................................... 8 Figure 13:................................................................................................................... 9 The PASTE FUNCTION menu showing the built-in functions available in EXCEL .. 9 Using Charts in EXCEL ...................................................................................................... 9 Figure 14:................................................................................................................... 9 Section of Chart input data with both frequency and dB columns highlighted. Insertion of variable pi is discussed later. ........................................................... 9 Figure 15:................................................................................................................. 10 The CHART WIZARD menu with XY plot selected and a subspecies of XY plot selected that fits a curved line to the data points but doesn’t show the data points. ............................................................................................................... 10 Figure 16:................................................................................................................. 10 Initial form of chart from the chart wizard.......................................................... 10 Figure 17:................................................................................................................. 11 Copyright by John R Brews Page 1 12/19/2001The FORMAT PLOT AREA menu with the white background square in the AREA array of colors selected..................................................................................... 11 Figure 18:................................................................................................................. 11 The FORMAT DATA SERIES menu with color indigo blue selected and the heaviest weight available.................................................................................. 11 Figure 19:................................................................................................................. 12 The FORMAT AXIS menu with the CROSSES AT box set to −500 as the position where the X-axis crosses the Y-axis................................................................. 12 Figure 20:................................................................................................................. 12 The CHART