CREATE AN EXCEL SPREADSHEET

1. The horizontal range of a projectile fired into the air at angle O degrees is given by the formula: 2-72 sin cose R= 8 Create a worksheet that computes R for a selected initial velocity V and angle 0. Use g=9.81 m/sec, initial velocity (1) of 150 m/sec and @= 25, 30, 35 ... 90 So Convert degrees to radians by using the RADIANS() function as Excel SINO and COSO functions use angles in radians. (a) Use max() function to find the maximum value of R? (b) Create a bar/column graph of R versus @ in degrees