習作

答案

1.

=trunc(6.9)

6

=trunc(-7.3)

-7

2.

=int(2.9)

2

=int(-2.9)

-3

3.

=rounddown(3.2,0)

3

=rounddown(-3.27,1)

-3.2

4

=roundup(3.2,0)

4

=roundup(-3.27,1)

-3.3

5.

=round(3.2,0)

3

=round(-3.27,1)

-3.3

6.

=mod(37,5)

2

7.

=abs(38)

38

=abs(-38)

38

8.

=sqrt(121)

11

9.

寫一Excel算產生1個由1至100的隨機整數。

=int(rand( )*100+1)