|
|
|
|
|
1 |
e-test¼Ò°³ , ÃâÁ¦ ±âÁØ, ½ÃÇè ÀÀ½Ã ¹æ¹ý |
: |
|
|
2 |
¿¢¼¿ 2007 È¸é ±¸¼º, µ¥ÀÌÅÍ ÀÔ·Â ¹× ¼öÁ¤, ÇÑÀÚ ¹× ±âÈ£ ÀÔ·Â, ÀúÀå ¹× ºÒ·¯¿À±â |
: |
|
|
3 |
ÀÚµ¿ ä¿ì±â, ¼½Ä µµ±¸ ¸ðÀ½ (±Û²Ã , ¸ÂÃã) |
: |
|
|
4 |
¼¿ ¼½Ä ÁöÁ¤, Å׵θ® ¼³Á¤ ¹× ä¿ì±â, Çà/¿ °ü¸® |
: |
|
|
5 |
¼ö½Ä °è»ê, Àý´ë ÂüÁ¶, »ó´ë ÂüÁ¶ |
: |
|
|
6 |
Á¶°ÇºÎ ¼½Ä, ÀÚµ¿ ÇÊÅÍ |
: |
|
|
7 |
ÀÚµ¿ÇÔ¼ö, ¼öÇÐ/»ï°¢ ÇÔ¼ö(sum, sumif, product, sumproduct,round,rounddown µî) |
: |
|
|
8 |
³í¸®ÇÔ¼ö(if, and, or µî) |
: |
|
|
9 |
ÅؽºÆ® ÇÔ¼ö(left, right, mid, len, trim µî) |
: |
|
|
10 |
³¯Â¥/½Ã°£ ÇÔ¼ö(year, month, day, date, today µî) |
: |
|
|
11 |
Åë°è ÇÔ¼ö(average, count, max, min, rank µî) |
: |
|
|
12 |
ã±â/ÂüÁ¶ ÇÔ¼ö (vlookup , hlookup , index, choose µî) |
: |
|
|
13 |
µ¥ÀÌÅͺ£À̽º ÇÔ¼ö, Á¤º¸ ÇÔ¼ö (dsum, daverage, dmax, iserr, iserror µî) |
: |
|
|
14 |
Â÷Æ® ÀÛ¼º ¹× ÆíÁý , Â÷Æ® ¹®Á¦ |
: |
|
|
15 |
Çǹþ Å×ÀÌºí ¸¸µé±â, ¿öÅ©½ÃÆ® °ü¸®, Á¤·Ä ¹× ºÎºÐÇÕ |
: |
|
|
16 |
ÅؽºÆ® ³ª´©±â, ¸ñÇ¥°ª ã±â, ½Ã³ª¸®¿À ÀÛ¼º |
: |
|
|
17 |
±âÃâ¹®Á¦Ç®ÀÌ A-1 |
: |
|
|
18 |
±âÃâ¹®Á¦Ç®ÀÌ A-2 |
: |
|
|
19 |
±âÃâ¹®Á¦Ç®ÀÌ A-3 |
: |
|
|
20 |
±âÃâ¹®Á¦Ç®ÀÌ B-1 |
: |
|
|
21 |
±âÃâ¹®Á¦Ç®ÀÌ B-2 |
: |
|
|
22 |
±âÃâ¹®Á¦Ç®ÀÌ B-3 |
: |
|
|
23 |
±âÃâ¹®Á¦Ç®ÀÌ C-1 |
: |
|
|
24 |
±âÃâ¹®Á¦Ç®ÀÌ C-2 |
: |
|
|
25 |
±âÃâ¹®Á¦Ç®ÀÌ C-3 |
: |
|
|
|