HEAD M EXCEL PROBLEM #1 - PIPE VOLUME VS. PIPE LENGTH o Using Excel, & Create a table which computes the volume (in cm3) of a cylinder with a diameter of 1/2" and lengths 6 in 60 inches, in increments of 6 inches. = & Repeat this calculation in a second column but set the diameter of the cylinder to 1". FLO & Create a X Y Scatter Chart (with straight lines) of your table. Label the two volume columns as "1/2 ID" and "1 ID", respectively. Add X and Y axis titles as "Length, in" and "Volume,cm3" and set the Chart Title to "Pipe Volume vs. Length." DASTATE JIO Notes: Excel uses the function pi() for . COLLES