|
1.
|
$B;2>H(B
|
|
|
$B;2>H$G$O!"(B
$B%o!<%/%7!<%H$N%;%k(B
$B$^$?$O%;%kHO0O$r(B
$B<1JL$7!"(B
$B?t<0$G;H$&CM$d(B
$B%G!<%?$N0LCV$r(B
$B;XDj$7$^$9!#(B
$B;2>H$r;H$&$H!"(B
$B0[$J$k%o!<%/%7!<%H$N%G!<%?$r(B 1 $B$D$N?t<0$G;HMQ$7$?$j!"(B
1 $B$D$N%;%k$NCM$rJ#?t$N?t<0$G;HMQ$7$?$j$9$k$3$H$,$G$-$^$9!#(B
$B$^$?!"F1$8%V%C%/$K$"$kB>$N%7!<%H$N%;%k$N;2>H!"(B
$BB>$N%V%C%/$K$"$k%;%k$N;2>H$r9T$&$3$H$b$G$-$^$9!#(B
$BB>$N%V%C%/$K$"$k%;%k$N;2>H$r%j%s%/$H$$$$$^$9!#(B
|
|
2.
|
A1 $B7A<0$N%;%k;2>H(B
|
|
|
$B4{Dj$G$O!"(BA1 $B;2>H7A<0$,;HMQ$5$l$^$9!#(B
$B$3$N;2>H7A<0$G$O!"(B
$BNs$K%"%k%U%!%Y%C%HJ8;z(B (A $B!A(B IV $B$N7W(B 256 $BNs(B)$B!"(B
$B9T$KHV9f(B (1 $B!A(B 65536 $B$^$G(B) $B$r;H$C$F%;%k$r;2>H$7$^$9!#(B
$B$3$l$i$NJ8;z$HHV9f$O$=$l$>$lNs8+=P$7!"9T8+=P$7$H8F$P$l$^$9!#(B
$B%;%k$r;2>H$9$k$K$O!"Ns$rI=$9J8;z$KB3$1$F9THV9f$rF~NO$7$^$9!#(B
$B$?$H$($P!"(B
B2 $B$ONs(B B $B$H9T(B 2 $B$,8r$o$k0LCV$K$"$k%;%k$N;2>H$rI=$7$^$9!#(B
|
$B;2>H%;%k(B ($B$^$?$O%;%kHO0O(B)
|
$BF~NO$9$kJ8;zNs!V%;%kHVCO!W(B
|
|
$BNs(B A$B!"9T(B 10 $B$N%;%k(B
|
A10
|
|
|
|
$BNs(B A$B!"9T(B 10 $B!A9T(B 20 $B$N%;%kHO0O(B
|
A10:A20
|
|
|
|
$B9T(B 15$B!"Ns(B B $B!ANs(B E $B$N%;%kHO0O(B
|
B15:E15
|
|
|
|
$B9T(B 5 $B$N$9$Y$F$N%;%k(B
|
5:5
|
|
|
|
$B9T(B 5 $B!A(B 10 $B$N$9$Y$F$N%;%k(B
|
5:10
|
|
|
|
$BNs(B H $B$N$9$Y$F$N%;%k(B
|
H:H
|
|
|
|
$BNs(B H $B!A(B J $B$N$9$Y$F$N%;%k(B
|
H:J
|
|
|
|
$BNs(B A $B!A(B E$B!"9T(B 10 $B!A(B 20 $B$N%;%kHO0O(B
|
A10:E20
|
|
|
|
|
3.
|
$BB>$N%o!<%/%7!<%H$X$N;2>H(B
|
|
|
$B
$BF1$8%V%C%/$K$"$k(B "$B%^!<%1%F%#%s%0(B" $B$H$$$&L>A0$N%7!<%H$N%;%kHO0O(B B1:B10 $B$NJ?6QCM$r7W;;$7$^$9!#(B
$BF1$8%V%C%/$NB>$N%o!<%/%7!<%H$X$N%j%s%/(B
$B%o!<%/%7!<%HL>$H46C2Id(B (!) $B$KB3$1$F%;%kHO0O$N;2>H$rF~NO$7$^$9!#(B
|
|
4.
|
$BAjBP;2>H$H@dBP;2>H$N0c$$(B
|
|
|
$BAjBP;2>H(B
A1
$B$J$I$NAjBP%;%k;2>H$r?t<0$G;HMQ$9$k$H!"(B
$B?t<0$,F~NO$5$l$F$$$k%;%k0LCV$r4pE@$K$7$F!"(B
$B;2>H$9$k%;%k$,7h$^$j$^$9!#(B
$B?t<0$r4^$`%;%k$N0LCV$rJQ99$7$?>l9g!"(B
$B;2>H$bJQ99$5$l$^$9!#(B
$B?t<0$r$[$+$N9T$dNs$K%3%T!<$7$?>l9g!"(B
$B;2>H$b<+F0E*$KD4@0$5$l$^$9!#(B
$B4{Dj$G$O!"?7$7$/:n@.$7$??t<0$K$OAjBP;2>H$,;HMQ$5$l$^$9!#(B
$B$?$H$($P!"%;%k(B B2 $B$K$"$kAjBP;2>H$r(B B3 $B$K%3%T!<$9$k$H!"(B=A1 $B$O<+F0E*$K(B =A2 $B$KJQ99$5$l$^$9!#(B
$BAjBP;2>H$r;HMQ$7$??t<0$N%3%T!<(B
|
|
|
$B@dBP;2>H(B
$A$1
$B$J$I$N@dBP;2>H$r?t<0$G;HMQ$9$k$H!"(B
$BFCDj$N0LCV$K$"$k%;%k$,I,$:;2>H$5$l$^$9!#(B
$B?t<0$r4^$`%;%k$N0LCV$rJQ99$7$F$b!"(B
$B@dBP;2>H$G;2>H$9$k%;%k$OJQ99$5$l$^$;$s!#(B
$B$=$N?t<0$r$[$+$N9T$dNs$K%3%T!<$7$F$b!"(B
$B@dBP;2>H$OJQ$o$j$^$;$s!#(B
$B4{Dj$G$O!"?7$7$/:n@.$7$??t<0$K$OAjBP;2>H$,;HMQ$5$l$k$?$a!"(B
$B@dBP;2>H$r;HMQ$9$k$K$O!"@Z$jBX$($r9T$&I,MW$,$"$j$^$9!#(B
$B$?$H$($P!"%;%k(B B2 $B$K$"$k@dBP;2>H$r(B $B%;%k(B B3 $B$K%3%T!<$7$?>l9g!"(B
$B$I$A$i$N;2>H$b(B =$A$ $B$K$J$j$^$9!#(B
$B@dBP;2>H$r;HMQ$7$??t<0$N%3%T!<(B
|
|
|
$BJ#9g;2>H(B
$BJ#9g;2>H$G$O!"@dBPNs;2>H$HAjBP9T;2>H!"(B
$B$^$?$O@dBP9T;2>H$HAjBPNs;2>H$rAH$_9g$o$;$F;HMQ$7$^$9!#(B
$B@dBPNs;2>H$O!"(B$A1 $B$d(B $B1 $B$N$h$&$K;XDj$7$^$9!#(B
$B$^$?!"@dBP9T;2>H$O!"(BA$1 $B$d(B B$1 $B$N$h$&$K;XDj$7$^$9!#(B
$B?t<0$r4^$`%;%k$N0LCV$rJQ99$7$?>l9g!"(B
$BAjBP;2>H$OJQ99$5$l$^$9$,!"@dBP;2>H$O$=$N$^$^$G$9!#(B
$B?t<0$r$[$+$N9T$dNs$K%3%T!<$7$?>l9g!"(B
$BAjBP;2>H$O<+F0E*$KD4@0$5$l$^$9$,!"@dBP;2>H$O$O$=$N$^$^$G$9!#(B
$B$?$H$($P!"J#9g;2>H$r(B $B%;%k(B A2 $B$+$i(B B3 $B$K%3%T!<$9$k$H!"(B
$B?t<0$N(B =A$1 $B$O(B =B$1 $B$KJQ99$5$l$^$9!#(B
$BJ#9g;2>H$r;HMQ$7$??t<0$N%3%T!<(B
|
|
5.
|
3-D $B;2>H7A<0(B
|
|
|
$B%V%C%/Fb$NJ#?t$N%o!<%/%7!<%H$NF1$8%;%k(B
$B$^$?$O%;%kHO0O$N%G!<%?$rJ,@O$9$k>l9g$O!"(B
3-D $B;2>H$r;H$$$^$9!#(B
3-D $B;2>H$G$O!"%o!<%/%7!<%HHO0O$N8e$K%;%k;2>H(B
$B$^$?$O%;%kHO0O$N;2>H$r;XDj$7$^$9!#(B
$B;XDj$7$?@hF,$N%7!<%HL>$HKvHx$N%7!<%HL>$N4V$N(B
$B$9$Y$F$N%o!<%/%7!<%H$,;2>H$K;HMQ$5$l$^$9!#(B
$B$?$H$($P!"(B3-D $B;2>H$r;HMQ$7$F(B
$B!V(B=SUM(Sheet2:Sheet13!B5)$B!W$H$$$&?t<0$rF~NO$9$k$H!"(B
$B%o!<%/%7!<%H(B Sheet 2 $B$+$i(B Sheet 13 $B$^$G$N$9$Y$F$N(B
$B%;%k(B B5 $B$NCM$,9g7W$5$l$^$9!#(B
- 3-D $B;2>H$r;H$&$H!"B>$N%7!<%H$N%;%k$r;2>H$7$?$j!"(B
$BL>A0$rDj5A$7$?$j!"(B
$B
SUM$B!"(BAVERAGE$B!"(BAVERAGEA$B!"(BCOUNT$B!"(BCOUNTA$B!"(BMAX$B!"(BMAXA$B!"(BMIN$B!"(BMINA$B!"(BPRODUCT$B!"(BSTDEV$B!"(BSTDEVA$B!"(BSTDEVP$B!"(BSTDEVPA$B!"(BVAR$B!"(BVARA$B!"(BVARP$B!"$*$h$S(B
VARPA $B$,$"$j$^$9!#(B
- 3-D $B;2>H$O!"(B$BG[Ns?t<0(B
($BG[Ns?t<0(B : 1 $B$D$^$?$OJ#?t$NCM%;%C%H$K4p$E$$$FJ#?t$N7W;;$rCtrl $B%-!<$H(B Shift $B%-!<$r2!$7$J$,$i(B Enter $B%-!<$r2!$7$FF~NO$7$^$9!#(B)
$B$G$O;HMQ$G$-$^$;$s!#(B
- 3-D $B;2>H$O!"6&DLItJ,$N(B$B1i;;;R(B
($B1i;;;R(B : $B<0$r9=@.$9$k5-9f$dC18l!#$3$l$K$h$j!"H1i;;;R$J$I$,$"$j$^$9!#(B)
($B%9%Z!<%9(B 1 $B$D(B)$B!"(B
$B$^$?$O(B$B6&DLItJ,(B
($B6&DLItJ,(B : 1 $B$D$N%;%k$G$O$J$$$,!"(B1 $B$D$N%;%k$N$h$&$K7W;;$5$l$k%;%kHO0O$X$N;2>H!#%;%k(B C10 $B$K?t<0(B
=B5: B15*5 $B$,F~NO$5$l$F$$$k>l9g!"%;%k(B B10 $B$H%;%k(B C10 $B$OF1$89T$K$"$k$?$a!"%;%k(B B10 $B$NCM$K(B 5 $B$,>h;;$5$l$^$9!#(B)
$B$r;HMQ$9$k?t<0$G$O;HMQ$G$-$^$;$s!#(B
|
|
6.
|
$B%o!<%/%7!<%H$N0\F0!"%3%T!l9g$N(B 3-D $B;2>H$X$N1F6A(B
|
|
|
$B3-D $B;2>H$K4^$^$l$k%o!<%/%7!<%H$N(B
$B0\F0!"%3%T!
$B$3$NNc$G$O!"%o!<%/%7!<%H(B 2 $B!A(B 6 (Sheet2 $B!A(B Sheet6) $B$NHO0O$K$"$k(B
$B%;%k(B A2 $B!A(B A5 $B$r9g7W$9$k?t<0(B
=SUM(Sheet2:Sheet6!A2:A5)
$B$r;H$$$^$9!#(B
$BA^F~$H%3%T!<(B
Sheet2
$B$H(B Sheet6 ($B$3$NNc$G$ON>C<$N%7!<%H(B) $B$N4V$K(B
$B%7!<%H$rA^F~$^$?$O%3%T!<$9$k$H!"(B
$BDI2C$7$?%7!<%H$N%;%k(B A2 $B!A(B A5 $B$KF~NO$5$l$F$$$kCM$b4^$a$F(B
$B$9$Y$F$NCM$,7W;;$5$l$^$9!#(B
$B:o=|(B
Sheet2
$B$H(B Sheet6 $B$N4V$N(B
$B%7!<%H$r:o=|$9$k$H!"(B
$B:o=|$7$?%7!<%H$NCM$O=|$$$F7W;;$5$l$^$9!#(B
$B0\F0(B
Sheet2
$B$H(B Sheet6 $B$N4V$K$"$k(B
$B%7!<%H$r;2>H$5$l$F$$$k%7!<%HHO0O$N30$K(B
$B0\F0$9$k$H!"(B
$B0\F0$7$?%7!<%H$NCM$O=|$$$F7W;;$5$l$^$9!#(B
$BN>C<$N%7!<%H$N0\F0(B
Sheet2
$B$H(B Sheet6 $B$N$$$:$l$+$rF1$8%V%C%/Fb$NB>$N0LCV$K(B
$B0\F0$9$k$H!"(B
$B0\F08e$N(B Sheet2 $B$H(B Sheet6 $B$N4V$K$"$k%7!<%H$NCM$,7W;;$5$l$^$9!#(B
$BN>C<$N%7!<%H$N:o=|(B
Sheet2
$B$H(B Sheet6 $B$N$$$:$l$+$r:o=|$9$k$H!"(B
$B:o=|$7$?%7!<%H$r=|$/%7!<%H$NCM$,7W;;$5$l$^$9!#(B
|
|
7.
|
R1C1 $B;2>H7A<0(B
|
|
|
$B%o!<%/%7!<%H$N(B
$B9T$HNs$NN>J}$K(B
$BHV9f$r;XDj$9$k;2>H7A<0$r;H$&$3$H$b$G$-$^$9!#(B
R1C1 $B;2>H7A<0$O!"(B$B%^%/%m(B
($B%^%/%m(B : 1 $B$D$^$?$OJ#?t$N%"%/%7%g%s$r<+F0E*$K
$B$r;H$C$F9T$HNs$N0LCV$r7W;;$9$k>l9g$KJXMx$G$9!#(B
R1C1 $B;2>H7A<0$G$O!"(B
"R" $B$KB3$1$F9THV9f$r;XDj$7!"(B
$B$=$N8e(B "C" $B$KB3$1$FNsHV9f$r;XDj$7$F(B
$B%;%k$N0LCV$rI=$7$^$9!#(B
|
$B;2>H(B
|
$BFbMF(B
|
|
R[-2]C
|
$BF1$8Ns$G(B 2 $B9T>e$N%;%k$rI=$9(B$BAjBP;2>H(B
($BAjBP;2>H(B : $B?t<0$,F~NO$5$l$F$$$k%;%k$r4pE@$H$7$F!"AjBPE*0LCV$K4p$E$$$F<($5$l$k%;%k$N;2>HJ}K!!#?t<0$r%3%T!<$9$k$H!"AjBP;2>H$O<+F0E*$KJQ99$5$l$^$9!#AjBP;2>H$O!"(BA1
$B$N$h$&$J7A<0$G<($5$l$^$9!#(B)
|
|
R[2]C[2]
|
2 $B9T2<$G(B 2 $BNs1&$N%;%k$rI=$9AjBP;2>H(B
|
|
R2C2
|
$B9T(B 2 $B$NNs(B 2 $B$K$"$k%;%k$rI=$9(B$B@dBP;2>H(B
($B@dBP;2>H(B : $B?t<0$,F~NO$5$l$F$$$k%;%k$N0LCV$K$+$+$o$i$:!";2>H$9$k%;%k$N@dBP%"%I%l%9!#@dBPE*$J%;%k;2>H$O(B $A$1
$B$N$h$&$KI=$7$^$9!#(B)
|
|
R[-1]
|
$B%"%/%F%#%V(B $B%;%k$N(B 1 $B$D>e$N9TA4BN$rI=$9AjBP;2>H(B
|
|
R
|
$B%"%/%F%#%V(B $B%;%k$N$"$k9T$rI=$9@dBP;2>H(B
|
$B%^%/%m$r5-O?$7$?>l9g!"(B
R1C1 $B;2>H7A<0$,;H$o$l$k%3%^%s%I$,$"$j$^$9!#(B
$B$?$H$($P!"%^%/%m$N5-O?$r3+;O$7$F$+$i!"(B
[$B%*!<%H(B SUM] $B$r%/%j%C%/$7$F(B
$B%;%kHO0O$NCM$r9g7W$9$k?t<0$rA^F~$9$k$H!"(B
A1 $B7A<0$G$O$J$/(B R1C1 $B7A<0$r;HMQ$7$F%^%/%m$,5-O?$5$l$^$9!#(B
|
|
8.
|
R1C1 $B;2>HJ}<0$N;HMQ$r@_Dj$9$k(B
|
|
|
1.
[$B%D!<%k(B] $B%a%K%e!<$N(B [$B%*%W%7%g%s(B]
$B$r%/%j%C%/$7!"(B[$BA4HL(B] $B%?%V$r%/%j%C%/$7$^$9!#(B
2.
R1C1 $B;2>HJ}<0$r;HMQ$9$k>l9g$K$O!"(B[$B@_Dj(B]
$B$N(B [R1C1 $B;2>HJ}<0$r;HMQ$9$k(B] $B%A%'%C%/(B $B%\%C%/%9$r%*%s$K!";HMQ$7$J$$>l9g$O%*%U$K$7$^$9!#(B
|
|
|
|
$B%H%C%W%Z!<%8$KLa$k(B
|
|
$B
|
|
|
|
|
|