{"id":60960,"date":"2017-10-21T08:31:35","date_gmt":"2017-10-21T02:01:35","guid":{"rendered":"http:\/\/moemaka.com\/?p=60960"},"modified":"2017-10-21T06:33:42","modified_gmt":"2017-10-21T00:03:42","slug":"%e1%80%b1%e1%80%9c%e1%80%ac%e1%80%80%e1%80%93%e1%80%ac%e1%80%90%e1%80%b9%e1%80%81%e1%80%94%e1%80%b9%e1%80%b8-%e1%80%9e%e1%80%ac%e1%80%82%e1%80%ad-office-application-in-the-cloud-31","status":"publish","type":"post","link":"https:\/\/moemaka.net\/wpmmk\/archives\/60960","title":{"rendered":"\u1031\u101c\u102c\u1000\u1013\u102c\u1010\u1039\u1001\u1014\u1039\u1038 \u101e\u102c\u1002\u102d \u2013 Office Application in the Cloud (31)"},"content":{"rendered":"
\u1031\u101c\u102c\u1000\u1013\u102c\u1010\u1039\u1001\u1014\u1039\u1038 \u101e\u102c\u1002\u102d \u2013 Office Application in the Cloud (31)<\/span><\/div>\n
\u1021\u102d\u1019\u1039\u101e\u102f\u102f\u1036\u1038 \u1031\u1000\u103a\u102c\u1004\u1039\u1038\u101e\u102f\u102f\u1036\u1038 \u101b\u102f\u102f\u1036\u1038\u101e\u1036\u102f\u102f\u1038 – GMail \u1014\u1032\u1094 Google Office Application \u1021\u1031\u103b\u1001\u1001\u1036\u101c\u1019\u1039\u1038\u100a\u108a\u1014\u1039<\/span><\/div>\n
(\u1019\u102d\u102f\u1038\u1019\u1001) \u1031\u1021\u102c\u1000\u1039\u1010\u102d\u102f\u1018\u102c \u1041\u1042\u104a \u1042\u1040\u1041\u1047<\/span><\/div>\n

 <\/p>\n

Function (\u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038) \u1019\u102d\u1010\u1039\u1006\u1000\u1039<\/span><\/h3>\n

 <\/p>\n

\u1021\u1005\u1010\u102f\u1014\u1039\u1038\u1000\u1031\u1010\u102c\u1037 \u100a\u102e\u1019\u103d\u103a\u103b\u1001\u1004\u1039\u1038\u1014\u1032\u1094 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1031\u1010\u103c\u1000\u102d\u102f sheet\u2019s cell \u1031\u1010\u103c\u1019\u103d\u102c \u1011\u100a\u1039\u1037\u1010\u103c\u1000\u1039\u107e\u1000\u1010\u101a\u1039\u104b d1=a1+c1 \u1012\u102b\u1019\u103a\u1033\u102d\u1038\u1031\u1015\u102b\u1037\u104b \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1000\u102d\u102f \u1011\u100a\u1039\u1037\u1010\u102c\u1015\u102b\u104b \u1031\u1014\u102c\u1000\u1039\u1010\u1001\u102f\u1000\u1031\u1010\u102c\u1037 function \u1006\u102d\u102f\u1010\u1032\u1037 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1011\u100a\u1039\u1037\u1011\u102c\u1038\u103b\u1015\u102e\u1038\u101e\u102c\u1038 \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038\u1000\u102d\u102f \u1031\u1001\u105a\u101e\u102f\u1036\u1038\u1010\u102c\u1015\u102b\u104b \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038\u1006\u102d\u102f\u1010\u102c\u1000 <\/span>sum<\/span>, <\/span>average<\/span>, <\/span>count<\/span>, <\/span>maximum value<\/span>, and <\/span>minimum value<\/span> \u1006\u102d\u102f\u1010\u1032\u1037 \u1031\u1015\u102b\u1004\u1039\u1038\u101c\u1012\u1039\u104a \u1015\u103a\u1019\u1039\u1038\u1019\u103d\u103a\u103b\u1001\u1004\u1039\u1038\u104a \u1021\u1031\u101b\u1021\u1010\u103c\u1000\u1039\u104a \u1021\u1019\u103a\u102c\u1038\u1006\u102f\u1036\u1038\u1000\u102d\u1014\u1039\u1038\u104a \u1021\u1014\u100a\u1039\u1038\u1006\u102f\u1036\u1038\u1000\u102d\u1014\u1039\u1038 \u1006\u102d\u102f\u1010\u102c\u1031\u1010\u103c\u1000\u102d\u102f CELL \u1031\u1010\u103c\u1000\u102d\u102f \u1006\u101c\u1000\u1039\u101c\u102f\u1015\u1039\u103b\u1015\u102e\u1038 \u1010\u103c\u1000\u1039\u1001\u102d\u102f\u1004\u1039\u1038\u1010\u102c\u1015\u102b\u104b \u1021\u1032\u101e\u100a\u1039 function \u1000\u102d\u102f \u1031\u1001\u105a\u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1094 \u101b\u1015\u102b\u1010\u101a\u1039\u104b \u1031\u1015\u102b\u1004\u1039\u1038\u101c\u1012\u1039\u1021\u1010\u103c\u1000\u1039 formula \u1000\u102d\u102f d1=a1+c1+b1 \u1031\u1010\u103c \u101c\u102f\u1015\u1039\u1019\u1031\u1014\u1018\u1032 d1=sum(a1,b1,c1) \u101c\u102d\u102f\u1094 \u1010\u1014\u1039\u1038 \u1031\u1001\u105a\u101e\u102f\u1036\u1038\u1010\u102c\u1000\u102d\u102f \u1006\u102f\u102d\u101c\u102d\u102f\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n

The parts of a function<\/span><\/h4>\n
\u1016\u1014\u1039\u101b\u103d\u1004\u1039\u101b\u1032\u1037 \u1021\u1005\u102d\u1010\u1039\u1021\u1015\u102d\u102f\u1004\u1039\u1038\u1031\u1010\u103c\u1000\u102d\u102f\u1031\u1010\u102c\u1037 <\/span><\/div>\n
equals sign (=)<\/span>, a <\/span>function name <\/span>(AVERAGE, SUM \u1006\u102d\u102f\u1010\u1032\u1037 \u1016\u1014\u1039\u101b\u103d\u1004\u1039\u101b\u1032\u1037 \u1021\u1019\u100a\u1039\u1019\u103d\u1014\u1039) \u103b\u1015\u102e\u1038\u1031\u1010\u102c\u1037 <\/span>argument<\/span> (\u1006\u102d\u102f\u1010\u1032\u1037 \u00a0\u101e\u1010\u1039\u1019\u103d\u1010\u1039\u1001\u103a\u1000\u1039\u104a \u101b\u100a\u1039\u100a\u108a\u1014\u1039\u1038\u1001\u103a\u1000\u1039 \u1006\u102d\u102f\u1010\u102c) \u1015\u102b\u101b\u1019\u101a\u1039\u104b \u1018\u101a\u1039 \u1006\u1032\u101c\u1039\u1031\u1010\u103c\u1000\u102d\u102f \u101b\u100a\u1039\u100a\u108a\u1014\u1039\u1038\u1011\u102c\u1038\u1010\u102c\u101c\u1032 \u1006\u102d\u102f\u1010\u102c\u1019\u103a\u1033\u102d\u1038\u104b <\/span><\/div>\n

 <\/p>\n

\"Syntax<\/span><\/div>\n

Working with arguments<\/span><\/h4>\n
\u101b\u100a\u1039\u100a\u108a\u1014\u1039\u1038\u1001\u103a\u1000\u1039\u104a \u101e\u1010\u1039\u1019\u103d\u1010\u1039\u1001\u103a\u1000\u1039\u1006\u102d\u102f\u1010\u102c \u1000 \u1006\u1032\u101c\u1039\u101c\u102d\u1015\u1039\u1005\u102c \u1010\u1001\u102f \u101e\u102d\u102f\u1094\u1019\u101f\u102f\u1010\u1039 \u1006\u1032\u101c\u1039\u101c\u102d\u1015\u1039\u1005\u102c \u1021\u1005\u102f\u1021\u1031\u1040\u1038\u1000\u102d\u102f \u1000\u103c\u1004\u1039\u1038\u1005 \u1000\u103c\u1004\u1039\u1038\u1015\u102d\u1010\u1039\u1011\u1032\u1019\u103d\u102c \u1011\u100a\u1039\u1037\u1011\u102c\u1038\u1010\u102c\u1000\u102d\u102f \u1031\u103b\u1015\u102c\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n
\u1025\u1015\u1019\u102c\u1021\u102c\u1038\u103b\u1016\u1004\u1039\u1037 – \u1015\u103a\u1019\u1039\u1038\u1019\u103d\u103a\u103b\u102f\u1001\u1004\u1039\u1038\u1000\u102d\u102f \u101b\u103d\u102c\u1010\u1032\u1037 function <\/span>=AVERAGE(B1:B9) <\/span>\u00a0\u1006\u102d\u102f\u1010\u102c cell range <\/span>B1:B9<\/span> \u1011\u1032\u1000 \u1002\u100f\u1014\u1039\u1038\u1031\u1010\u103c\u1000\u102d\u102f \u101b\u100a\u1039\u100a\u108a\u1014\u1039\u1038\u103b\u1015\u102e\u1038\u1031\u1010\u102c\u1037 \u101e\u1030\u1010\u102d\u102f\u1094\u1021\u102c\u1038\u101c\u102f\u1036\u1038\u101b\u1032\u1037 average – \u1015\u103a\u1019\u1039\u1038\u1019\u103d\u103a\u103b\u1001\u1004\u1039\u1038\u1000\u102d\u102f \u101b\u103d\u102c\u1001\u102d\u102f\u1004\u1039\u1038\u1010\u1032\u1037 \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038 \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b <\/span><\/div>\n

 <\/p>\n

\"A<\/span><\/div>\n

 <\/p>\n

\u101e\u1010\u1039\u1019\u103d\u1010\u1039\u1001\u103a\u1000\u1039 \u100a\u108a\u1014\u1039\u1038\u1006\u102d\u102f\u1001\u103a\u1000\u1039 \u1021\u1019\u103a\u102c\u1038\u1021\u103b\u1015\u102c\u1038\u1000\u102d\u102f\u101c\u100a\u1039\u1038 \u1000\u103c\u1004\u1039\u1038\u1011\u1032\u1019\u103d\u102c \u1011\u100a\u1039\u1037\u108f\u102d\u102f\u1004\u1039\u1015\u102b\u1010\u101a\u1039\u104b \u1021\u1032\u101c\u102d\u102f\u1006\u102d\u102f\u101b\u1004\u1039\u1031\u1010\u102c\u1037 argument \u1011\u1032\u1019\u103d\u102c \u1021\u102f\u1015\u1039\u1005\u102f\u1031\u1010\u103c\u1000\u102d\u102f , \u1031\u1000\u102c\u1039\u1019\u102c\u1014\u1032\u1094 \u103b\u1001\u102c\u1038\u1011\u102c\u1038\u101c\u102d\u102f\u1094 \u101b\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n

 <\/p>\n

\u1025\u1015\u1019\u102c – <\/span>=SUM(A1:A3, C1:C2, E1) <\/span>\u1006\u102d\u102f\u1010\u102c \u1031\u1015\u102b\u1004\u1039\u1038\u101c\u1012\u1039\u1000\u102d\u102f \u101b\u103d\u102c\u1001\u102d\u102f\u1004\u1039\u1038\u1010\u102c\u1019\u103d\u102c (a1:a3) \u1010\u1005\u102f \u1031\u1015\u102b\u1004\u1039\u1038\u104a \u103b\u1015\u102e\u1038\u1031\u1010\u102c\u1037 (c1:c2) \u1010\u1005\u102f\u1031\u1015\u102b\u1004\u1039\u1038\u104a \u103b\u1015\u102e\u1038\u1031\u1010\u102c\u1037 e2 \u1014\u1032\u1094 \u1010\u103c\u1032\u103b\u1015\u102e\u1038 \u1021\u102c\u1038\u101c\u102f\u1036\u1038\u1031\u1015\u102b\u1004\u1039\u1038\u101c\u1012\u1039\u1000\u102d\u102f \u1011\u102f\u1010\u1039\u1001\u102d\u102f\u1004\u1039\u1038\u1010\u102c \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n

 <\/p>\n

\"A<\/span><\/div>\n

Creating a function<\/span><\/h3>\n
\u1016\u1014\u1039\u101b\u103d\u1004\u1039\u1019\u103a\u102c\u1038\u1000\u102d\u102f \u1031\u1001\u105a\u101e\u102f\u1036\u1038\u103b\u1001\u1004\u1039\u1038<\/span><\/div>\n
    \n
  • \n
    SUM<\/span>: \u1006\u102d\u102f\u1010\u102c\u1000 argument () \u1011\u1032\u1000 cell \u1031\u1010\u103c\u101b\u1032\u1037 \u1005\u102f\u1005\u102f\u1031\u1015\u102b\u1004\u1039\u1038\u101b\u101c\u1012\u1039\u1000\u102d\u102f \u1031\u1015\u1038\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n<\/li>\n
  • \n
    AVERAGE<\/span>: \u1006\u102d\u102f\u1010\u102c\u1000 argument () \u00a0\u1011\u1032\u1000 cell \u1031\u1010\u103c\u101b\u1032\u1037 \u1015\u103a\u1019\u1039\u1038\u1019\u103d\u103a\u1000\u102d\u1014\u1039\u1038\u1000\u102d\u102f \u1011\u102f\u1010\u1039\u1031\u1015\u1038\u1015\u102b\u1010\u101a\u1039\u104b \u101e\u1031\u1018\u102c\u1000\u1031\u1010\u102c\u1037 cell \u1031\u1010\u103c\u1000\u102d\u102f \u1021\u101b\u1004\u1039\u1031\u1015\u102b\u1004\u1039\u1038\u103b\u1015\u102e\u1038\u1031\u1010\u102c\u1037 cell \u1021\u1031\u101b\u1021\u1010\u103c\u1000\u1039\u1014\u1032\u1094\u1005\u102c\u1038\u103b\u1015\u102e\u1038 \u101b\u101c\u1012\u1039 \u1011\u102f\u1010\u1039\u1010\u102c\u1000\u102d\u102f \u1010\u103c\u1000\u1039\u1031\u1015\u1038\u1010\u102c\u1031\u1015\u102b\u1037\u104b<\/span><\/div>\n<\/li>\n
  • \n
    COUNT<\/span>: \u1006\u102d\u102f\u1010\u102c\u1000 argument () \u1011\u1032\u1000 cell \u1021\u1031\u101b\u1021\u1010\u103c\u1000\u1039\u1000\u102d\u102f \u101b\u103d\u102c\u1031\u1015\u1038\u1010\u102c\u1015\u102b\u104b<\/span><\/div>\n<\/li>\n
  • \n
    MAX<\/span>: \u1006\u102d\u102f\u1010\u102c\u1000 cell \u1031\u1010\u103c\u1011\u1032\u1000 \u1021\u107e\u1000\u102e\u1038\u1006\u102f\u1036\u1038 \u1000\u102d\u1014\u1039\u1038\u1000\u102d\u102f \u101b\u103d\u102c\u1031\u1015\u1038\u1010\u102c\u104b <\/span>highest<\/span> cell value<\/span> \u1031\u1015\u102b\u1037\u104b<\/span><\/div>\n<\/li>\n
  • \n
    MIN<\/span>: \u00a0\u1006\u102d\u102f\u1010\u102c\u1000 \u1021\u1014\u102d\u1019\u1039\u1037\u1006\u102f\u1036\u1038\u1000\u102d\u1014\u1039\u1038 <\/span>lowest cell value<\/span> \u1000\u102d\u102f \u101b\u103d\u102c\u1031\u1015\u1038\u1010\u102c\u1015\u102b\u104b<\/span><\/div>\n<\/li>\n<\/ul>\n

     <\/p>\n

    To create a function using the Functions button:<\/span><\/div>\n
    Function \u1001\u101c\u102f\u1015\u1039\u101e\u102f\u1036\u1038\u103b\u1015\u102e\u1038 \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038\u1019\u103a\u102c\u1038 \u1031\u1001\u105a\u101e\u102f\u1036\u1038\u103b\u1001\u1004\u1039\u1038<\/span><\/div>\n

     <\/p>\n

      \n
    1. \n
      \u1015\u102f\u1036\u1019\u103d\u102c \u1015\u102b\u1010\u1032\u1037\u1021\u1010\u102d\u102f\u1004\u1039\u1038 cell \u00a0<\/span>D3:D12 <\/span>\u1000\u102d\u102f \u1006\u101c\u1000\u1039\u101c\u102f\u1015\u1039\u1015\u102b\u104b<\/span> \"Selecting<\/span><\/div>\n<\/li>\n
    2. <\/li>\n
    3. \n
      Functions button<\/span> \u1000\u102d\u102f \u1019\u102e\u1038\u108f\u1030\u1038\u1000\u1031\u1014 \u1006\u103c\u1032\u1001\u103a\u1015\u102b\u104b<\/span><\/div>\n<\/li>\n
    4. \n
      \"Selecting<\/span><\/div>\n<\/li>\n
    5. \n
      SUM \u1000\u102d\u102f \u1031\u101b\u103c\u1038\u101c\u102d\u102f\u1000\u1039\u101b\u1004\u1039 – \u1010\u1001\u102b\u1010\u100a\u1039\u1038 function \u1000\u102d\u102f \u1006\u101c\u1000\u1039\u101c\u102f\u1015\u1039\u1011\u102c\u1038\u1010\u1032\u1037 \u1006\u1032\u101c\u1039\u1031\u1010\u103c\u1014\u1032\u1094 argument \u101e\u103c\u1004\u1039\u1038\u103b\u1015\u102e\u1038\u101e\u102c\u1038 \u1031\u1015\u105a\u101c\u102c\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n<\/li>\n
    6. \n
      \"The<\/span><\/div>\n<\/li>\n
    7. \n
      Enter<\/span> \u1031\u1001\u102b\u1000\u1039\u101c\u102d\u102f\u1000\u1039\u1015\u102b\u104b \u00a0\u1010\u1001\u102b\u1010\u100a\u1039\u1038 \u1010\u103c\u1000\u1039\u1011\u102c\u1038\u1010\u1032\u1037 \u1021\u1031\u103b\u1016 \u1031\u1015\u105a\u101c\u102c\u1015\u102b\u1010\u101a\u1039\u104b sum of <\/span>D3:D12<\/span> is <\/span>$765.29<\/span>.<\/span><\/div>\n<\/li>\n
    8. \n
      \"The<\/span><\/div>\n<\/li>\n<\/ol>\n

      To create a function manually:<\/span><\/h4>\n
      \u1016\u1014\u1039\u101b\u103d\u1004\u1039\u1031\u1010\u103c\u1000\u102d\u102f \u1000\u102d\u102f\u101a\u1039\u1037\u1016\u102c\u101e\u102c\u1000\u102d\u102f\u101a\u1039 \u101b\u102d\u102f\u1000\u1039\u1011\u100a\u1039\u1037\u103b\u1015\u102e\u1038 \u101e\u102f\u1036\u1038\u103b\u1001\u1004\u1039\u1038<\/span><\/div>\n

       <\/p>\n

      \u1016\u1014\u1039\u101b\u103d\u1004\u1039\u1021\u1019\u100a\u1039\u1031\u1010\u103c\u1000\u102d\u102f \u101e\u102d\u1031\u1014\u103b\u1015\u102e\u1006\u102d\u102f\u101b\u1004\u1039\u1031\u1010\u102c\u1037 \u1016\u1014\u1039\u101b\u103d\u1004\u1039\u1000\u102d\u102f \u1005\u102c\u1014\u1032\u1094 \u1010\u1014\u1039\u1038\u103b\u1015\u102e\u1038 \u101b\u102d\u102f\u1000\u1039\u1011\u100a\u1039\u1037\u101c\u102d\u102f\u1094 \u101b\u1015\u102b\u1010\u101a\u1039\u104b menu pulldown \u1000\u1031\u1014 \u1031\u1001\u105a\u101e\u102f\u1036\u1038\u1005\u101b\u102c \u1019\u101c\u102d\u102f\u1015\u102b\u104b <\/span>AVERAGE<\/span> function \u1000\u102d\u102f \u1031\u1001\u105a\u103b\u1015\u102e\u1038\u1031\u1010\u102c\u1037 \u1031\u1021\u102c\u1000\u1039\u1031\u1016\u102c\u1039\u103b\u1015\u1015\u102b \u101e\u1004\u1039\u1001\u1014\u1039\u1038\u1005\u102c\u1000 \u1021\u1031\u101b\u102c\u1004\u1039\u1038\u1005\u102c\u101b\u1004\u1039\u1038\u1000\u1031\u1014 \u1031\u101b\u102c\u1004\u1039\u1038\u101b\u1031\u1004\u103c\u1031\u1010\u103c\u1011\u1032\u1000 \u1010\u1001\u102f\u1001\u103a\u1004\u1039\u1038\u1005\u102e\u101b\u1032\u1037 \u1015\u103a\u1019\u1039\u1038\u1019\u103d\u103a\u1021\u1031\u101b\u102c\u1004\u1039\u1038\u1000\u102d\u102f \u1010\u103c\u1000\u1039\u107e\u1000\u100a\u1039\u1037\u101b\u1031\u1021\u102c\u1004\u1039\u104b<\/span><\/div>\n
        \n
      1. \n
        C10 <\/span>\u1000\u102d\u102f \u1006\u101c\u1000\u1039\u101c\u102f\u1015\u1039\u1015\u102b\u104b<\/span><\/div>\n<\/li>\n
      2. \n
        \"Selecting<\/span><\/div>\n<\/li>\n
      3. \n
        equals sign (=)<\/span> \u00a0\u1000\u102d\u102f \u101b\u102d\u102f\u1000\u1039\u103b\u1015\u102e\u1038\u1031\u1014\u102c\u1000\u1039 \u101e\u102d\u1011\u102c\u1038\u1010\u1032\u1037 \u1016\u1014\u1039\u101b\u103d\u1004\u1039\u1021\u1019\u100a\u1039 <\/span>function name<\/span> \u1000\u102d\u102f\u1005\u101b\u102f\u102d\u1000\u1039\u107e\u1000\u100a\u1039\u1037\u1015\u102b\u104b \u1002\u1030\u1038\u1002\u1032\u101b\u103d\u102d\u1000\u1031\u1014 \u101e\u1030\u1006\u102e\u1019\u103d\u102c \u101b\u103d\u102d\u1010\u1032\u1037 A\u1014\u1032\u1094 \u1005\u1010\u1032\u1037 function \u1031\u1010\u103c\u1000\u102d\u102f suggest \u101c\u102f\u1015\u1039\u1010\u102c \u1031\u1010\u103c\u1094\u101b\u1019\u101a\u1039\u1031\u1014\u102c\u1039\u104b <\/span>suggested<\/span> functions<\/span> \u00a0\u1011\u1032\u1000\u1031\u1014 \u101e\u100a\u1039\u101c\u102d\u102f \u101b\u102d\u102f\u1000\u1039\u1011\u100a\u1039\u1037\u101c\u102d\u102f\u1000\u1039\u1015\u102b\u104b <\/span>=AVERAGE<\/span>.<\/span><\/div>\n<\/li>\n
      4. \n
        \"Typing<\/span><\/div>\n<\/li>\n
      5. \n
        \u1021\u1032\u101e\u100a\u1039 \u101b\u102d\u102f\u1000\u1039\u101c\u102d\u102f\u1000\u1039\u1010\u102c\u1014\u1032\u1094 function \u1031\u1014\u102c\u1000\u1039\u1019\u103d\u102c \u101c\u102d\u102f\u1000\u1039\u1015\u102b\u101b\u1019\u100a\u1039\u1037 \u1000\u103c\u1004\u1039\u1038\u1005\u1000\u103c\u1004\u1039\u1038\u1015\u102d\u1010\u1039\u1014\u1032\u1094 \u101e\u1010\u1039\u1019\u103d\u1010\u1039\u1001\u103a\u1000\u1039 \u101b\u100a\u1039\u100a\u108a\u1014\u1039\u1038\u1001\u103a\u1000\u1039\u1031\u1010\u103c\u1000\u102d\u102f \u1002\u1030\u1038\u1002\u1032\u1000\u1031\u1014 \u1006\u1000\u1039\u1031\u1010\u102c\u1004\u1039\u1038\u1015\u102b\u1010\u101a\u1039\u104b argument \u1031\u1010\u103c \u1018\u102c\u1031\u1010\u103c \u101c\u102f\u102d\u101e\u101c\u1032\u1006\u102d\u102f\u1010\u102c\u1000\u102d\u102f \u101e\u1030\u1000 suggest \u101c\u102f\u1015\u1039\u1031\u1015\u1038\u1010\u102c\u1031\u1015\u102b\u1037\u104b<\/span><\/div>\n<\/li>\n
      6. \n
        \"Google<\/span><\/div>\n<\/li>\n
      7. \n
        cell range<\/span> \u00a0\u1000\u102d\u102f <\/span>parentheses<\/span> \u101c\u102d\u102f\u1094\u1031\u1001\u105a\u1010\u1032\u1037 \u1000\u103c\u1004\u1039\u1038\u1005\u1000\u103c\u1004\u1039\u1038\u1015\u102d\u1010\u1039\u1011\u1032\u1019\u103d\u102c \u101b\u102d\u102f\u1000\u1039\u1011\u100a\u1039\u1037\u1015\u102b\u104b <\/span>(C3:C9)<\/span> \u1031\u1015\u102b\u1037\u104b \u101c\u102d\u102f\u1001\u103a\u1004\u1039\u1010\u102c\u1000 \u1031\u101b\u102c\u1004\u1039\u1038\u101b\u1010\u1032\u1037 \u1031\u1005\u103a\u1038\u1031\u1010\u103c\u1011\u1032\u1000 \u1015\u103a\u1019\u1039\u1038\u1019\u103d\u103a\u1021\u1031\u101b\u102c\u1004\u1039\u1038 \u1018\u101a\u1039\u1031\u101c\u102c\u1000\u1039\u101c\u1032\u1006\u102d\u102f\u1010\u102c\u1000\u102d\u102f \u101e\u102d\u1001\u103a\u1004\u1039\u1010\u102c\u1000\u102d\u102f\u1038\u104b<\/span>\"Entering<\/span><\/div>\n<\/li>\n
      8. \n
        Enter <\/span>\u1031\u1001\u102b\u1000\u1039\u101c\u102d\u102f\u1000\u1039\u1010\u102c\u1014\u1032\u1094 \u1021\u1031\u103b\u1016\u1011\u103c\u1000\u1039\u101c\u102c\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n<\/li>\n
      9. \n
        \"Displaying<\/span><\/div>\n<\/li>\n<\/ol>\n

         <\/p>\n

        Google Sheets function list<\/span><\/h3>\n
        \u1002\u1030\u1038\u1002\u1032\u104f \u1016\u1014\u1039\u101b\u103d\u1004\u1039 \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038\u1019\u103a\u102c\u1038 \u1005\u102c\u101b\u1004\u1039\u1038\u1000\u102d\u102f \u1002\u1030\u1038\u1002\u1032\u1019\u103d\u102c \u101b\u102d\u102f\u1000\u1039\u103b\u1015\u102e\u1038 \u101b\u103d\u102c\u107e\u1000\u100a\u1039\u1037\u1015\u102b\u104b<\/span><\/div>\n
        \"The<\/span><\/div>\n
        Excel \u1014\u1032\u1094 Google Function \u1031\u1010\u103c\u1000 \u1006\u1004\u1039\u1010\u1030\u1031\u1010\u103c \u1019\u103a\u102c\u1038\u1015\u102b\u1010\u101a\u1039\u104b Excel \u101e\u102f\u1036\u1038\u101e\u1030\u1031\u1010\u103c\u1021\u1010\u103c\u1000\u1039 \u1019\u1001\u1000\u1039\u1015\u102b\u104b<\/span><\/div>\n

        To access the function list:<\/span><\/h4>\n
        \u1016\u1014\u1039\u101b\u103d\u1004\u1039\u1005\u102c\u101b\u1004\u1039\u1038\u1000\u102d\u102f menu pulldown \u1000\u1031\u1014 \u1031\u1001\u105a\u101e\u102f\u1036\u1038\u103b\u1001\u1004\u1039\u1038<\/span><\/div>\n

         <\/p>\n

        Functions button<\/span> \u1000\u102d\u102f \u1006\u103c\u1032\u1001\u103a\u1015\u102b\u104b <\/span>More functions…<\/span> \u00a0\u1000\u102d\u102f\u108f\u103d\u102d\u1015\u1039\u101c\u102d\u102f\u1000\u1039\u1015\u102b\u104b <\/span>Google sheets function list<\/span> \u1000\u102d\u102f \u1040\u1004\u1039\u1038\u1012\u102d\u102f\u1038\u1010\u1001\u102f\u1014\u1032\u1094 \u1031\u1016\u102c\u1039\u103b\u1015\u1015\u102b\u101c\u102d\u1019\u1039\u1037\u1019\u101a\u1039\u104b<\/span><\/div>\n
        \"Selecting<\/span><\/div>\n

         <\/p>\n

        \u1031\u1014\u102c\u1000\u1039 \u1005\u1019\u1039\u1038\u101e\u102f\u1036\u1038\u1001\u103a\u1004\u1039\u1005\u101b\u102c \u1016\u1014\u1039\u101b\u103d\u1004\u1039\u1010\u1001\u102f\u1000\u1031\u1010\u102c\u1037 VLOOKUP \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b \u1012\u102b\u1000\u102d\u102f \u101e\u1004\u1039\u1010\u1014\u1039\u1038\u1006\u101b\u102c\u1000 \u103b\u1015\u101e\u1031\u1015\u1038\u101b\u1019\u103d\u102c \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b VLookup \u1006\u102d\u102f\u1010\u102c\u1000 \u1019\u102d\u1019\u102d sheet \u1011\u1032\u1000\u1031\u1014 argument \u1031\u1010\u103c \u1021\u1019\u103a\u102c\u1038\u107e\u1000\u102e\u1038 \u1011\u102f\u1010\u1039\u103b\u1015\u102e\u1038 \u1031\u1012\u1010\u102c\u1000\u102d\u102f \u101b\u103d\u102c\u1010\u102c \u1005\u102e\u1005\u1025\u1039\u1010\u102c \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b \u1025\u1015\u1019\u102c – <\/span>=VLOOKUP(“Photo frame”, A2:B16, 2, FALSE) <\/span>\u1006\u102d\u102f\u1010\u102c\u1000\u102d\u102f \u1018\u101a\u1039\u101c\u102d\u102f \u101e\u102f\u1036\u1038\u101e\u101c\u1032\u1006\u102d\u102f\u1010\u102c \u1005\u1019\u1039\u1038\u1001\u102d\u102f\u1004\u1039\u1038\u1015\u102b\u104b<\/span><\/div>\n

         <\/p>\n

        <\/span><\/div>\n

        Challenge! \u1021\u102d\u1019\u1039\u1005\u102c<\/span><\/h3>\n

         <\/p>\n

          \n
        1. \n
          cell <\/span>C10<\/span> \u00a0\u1019\u103d\u102c \u1015\u1005\u1065\u100a\u1039\u1038 \u1021\u1031\u101b\u1021\u1010\u103c\u1000\u1039 \u1015\u103a\u1019\u1039\u1038\u1019\u103d\u103a \u1018\u101a\u1039\u1031\u101c\u102c\u1000\u1039 \u1031\u101b\u102c\u1004\u1039\u1038\u101b\u101e\u101c\u1032 \u1006\u102d\u102f\u1010\u102c \u101b\u103d\u102c\u1015\u102b\u104b \u00a0finds the average number of units sold by all of the troops.<\/span><\/div>\n<\/li>\n
        2. \n
          cell <\/span>C11<\/span> \u1019\u103d\u102c \u00a0\u1031\u101b\u102c\u1004\u1039\u1038\u101b\u1010\u1032\u1037 \u1015\u1005\u1065\u100a\u1039\u1038 \u1021\u1031\u101b\u1021\u1010\u103c\u1000\u1039 \u1031\u1015\u102b\u1004\u1039\u1038\u101c\u1012\u1039\u1000\u102d\u102f \u101b\u103d\u102c\u1015\u102b\u104b find the total amount of units sold by all of the troops.<\/span><\/div>\n<\/li>\n
        3. \n
          cell <\/span>C12<\/span>, \u1019\u103d\u102c \u1018\u101a\u1039\u1021\u1016\u103c\u1032\u1094\u1000 \u1021\u1019\u103a\u102c\u1038<\/span>\u00a0\u00a0\u00a0 <\/span>\u1006\u102f\u1036\u1038 \u1015\u1005\u1065\u100a\u1039\u1038\u1021\u1031\u101b\u1021\u1010\u103c\u1000\u1039 \u1031\u101b\u102c\u1004\u1039\u1038\u101b\u101e\u101c\u1032 \u1006\u102d\u102f\u1010\u102c \u101b\u103d\u102c\u1015\u102b\u104b <\/span><\/div>\n<\/li>\n
        4. \n
          \u1021\u1031\u103b\u1016\u1000 \u1012\u102e\u101c\u102d\u102f\u1031\u1015\u105a\u101b\u1015\u102b\u1019\u101a\u1039\u104b<\/span><\/div>\n<\/li>\n
        5. \n
          \"functions<\/span><\/div>\n<\/li>\n<\/ol>\n

           <\/p>\n

          (\u1006\u1000\u1039\u101c\u1000\u1039\u1031\u1016\u102c\u1039\u103b\u1015\u1015\u102b\u1019\u100a\u1039)<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

          \u1031\u101c\u102c\u1000\u1013\u102c\u1010\u1039\u1001\u1014\u1039\u1038 \u101e\u102c\u1002\u102d \u2013 Office Application in the Cloud (31) \u1021\u102d\u1019\u1039\u101e\u102f\u102f\u1036\u1038 \u1031\u1000\u103a\u102c\u1004\u1039\u1038\u101e\u102f\u102f\u1036\u1038 \u101b\u102f\u102f\u1036\u1038\u101e\u1036\u102f\u102f\u1038 – GMail \u1014\u1032\u1094 Google Office Application \u1021\u1031\u103b\u1001\u1001\u1036\u101c\u1019\u1039\u1038\u100a\u108a\u1014\u1039 (\u1019\u102d\u102f\u1038\u1019\u1001) \u1031\u1021\u102c\u1000\u1039\u1010\u102d\u102f\u1018\u102c \u1041\u1042\u104a \u1042\u1040\u1041\u1047   Function (\u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038) \u1019\u102d\u1010\u1039\u1006\u1000\u1039   \u1021\u1005\u1010\u102f\u1014\u1039\u1038\u1000\u1031\u1010\u102c\u1037 \u100a\u102e\u1019\u103d\u103a\u103b\u1001\u1004\u1039\u1038\u1014\u1032\u1094… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[961,856],"tags":[],"class_list":["post-60960","post","type-post","status-publish","format-standard","hentry","category-961","category-856"],"_links":{"self":[{"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/posts\/60960"}],"collection":[{"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/comments?post=60960"}],"version-history":[{"count":0,"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/posts\/60960\/revisions"}],"wp:attachment":[{"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/media?parent=60960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/categories?post=60960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/tags?post=60960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}