lesson40204_1
lesson1_Excel_function1
| A | B | C | D |
| NO. | QUESTION | ANS by excel | Excel_code |
| 1 | 1+2=? | =1+2 | =1+2,Enter |
| 2 | 3-2=? | =3-2 | =3-2,enter |
| 3 | 2*3=? | =2*3 | =2*3,enter |
| 4 | 2/3=? | =2/3 | =2/3,enter |
| 5 | 2^3=? | =2^3 | =2^3,enter |
| 6 | 2^(0.5)=? | =2^(0.5) | =2^(0.5),enter |
| 7 | 2^(1/2)=? | =2^(1/2) | =2^(1/2),enter |
| 8 | sqrt(2)=? | =sqrt(2) | =sqrt(2),enter ; sqrt=square root |
| 9 | 8^(1/3)=? | =8^(1/3) | =8^(1/3),enter ; cubic root |
| 10 | log(100,10)=? | =log(100,10) | =log(100,10),enter common_log10100 |
| 11 | log(8,2)=? | =log(8,2) | =log(8,2),enter,log28 |
| 12 | exp(1)=? | =exp(1) | =exp(1); e=2.71828...( math_cosntant) |
| 13 | ln(2)=? | =ln(2) | =ln(2),enter=loge2 |
| 14 | 1E1=? | =1E1 | =1E1,enter,=10^1,format sciencetific |
| 15 | 1E-2=? | =1E-2 | =1E-2,enter |
| 16 | 9.0E+9=? | =9.0E+9 | =9.0E+9,enter |
| 17 | 1.60e-19=? | =1.60E-19 | =1.60E-19,enter |
| 19 | PI()=? | =PI() | =PI(),enter,pi=3.14159... |
| 20 | 1 degree=?radian | =pi()/180 | =pi()/180,enter |
| 21 | 1 radian=?degree | =180/pi() | =180/pi(),enter |
| 22 | sin(30o)=? | =sin(30*pi()/180) | =sin(30*pi()/180),enter |
| 23 | asin(0.5)=?deg. | =asin(0.5)*180/pi() | =asin(0.5)*180/pi() ; convertrad. to deg. |
| 24 | cos(60o)=? | =cos(60*pi()/180) | =cos(60*pi()/180),enter |
| 25 | acos(0.5)=?deg. | =acos(0.5)*180/pi() | =acos(0.5)*180/pi(); convert rad. to deg. |
| 26 | tan(45o)=? | =tan(45*pi()/180) | =tan(45*pi()/180) |
| 27 | atan(1.0)=?deg | =atan(1.0)*180/pi() | =atan(1.0)*180/pi() |
| 28 | Fx=F*cos(60)=? | =10*cos(60*pi()/180) | X_axis vector_componet,F=10 N,theta=60o |
| 29 | Fy=F*sin(60)=? | =10*sin(60*pi()/180) | Y-axis vector_component ,F=10 N,theta=60o |
| 30 | F=sqrt(Fx^2+Fy^2)=? | =sqrt(3^2+4^2) | Resultant -vector ,Fx=3 N,Fy=4 N |
| 31 | theta(deg.)=tan-1(Fy/Fx)=? | =atan(4/3)*180/pi() | =atan(4/3)*180/pi() ; enter |
edit @ 2006/05/14 12:29:30
edit @ 2006/05/19 21:24:18
edit @ 2006/08/20 16:08:41
edit @ 28 Oct 2007 20:33:12 by physicsmatayom
