{"id":60846,"date":"2017-10-12T07:00:43","date_gmt":"2017-10-12T00:30:43","guid":{"rendered":"http:\/\/moemaka.com\/?p=60846"},"modified":"2017-10-12T06:35:24","modified_gmt":"2017-10-12T00:05:24","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-30","status":"publish","type":"post","link":"https:\/\/moemaka.net\/wpmmk\/archives\/60846","title":{"rendered":"\u1031\u101c\u102c\u1000\u1013\u102c\u1010\u1039\u1001\u1014\u1039\u1038 \u101e\u102c\u1002\u102d \u2013 Office Application in the Cloud (30)"},"content":{"rendered":"
\u1031\u101c\u102c\u1000\u1013\u102c\u1010\u1039\u1001\u1014\u1039\u1038 \u101e\u102c\u1002\u102d \u2013 Office Application in the Cloud (30)<\/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

\u1006\u1032\u101c\u1039\u1019\u103a\u102c\u1038\u1000\u102d\u102f \u100a\u108a\u1014\u1039\u1038\u1006\u102d\u102f\u103b\u1001\u1004\u1039\u1038<\/span><\/div>\n
\u1006\u1032\u101c\u1039\u1019\u103a\u102c\u1038\u1000\u102d\u102f \u100a\u108a\u1014\u1039\u1038\u1006\u102d\u102f\u101b\u102c\u1019\u103d\u102c \u101c\u102d\u1015\u1039\u1005\u102c A1 B1 \u1005\u1010\u1032\u1037 \u1021\u100a\u108a\u1014\u1039\u1038\u1014\u1032\u1094 cell \u1021\u1010\u103c\u1004\u1039\u1038\u1000 \u1000\u102d\u1014\u1039\u1038\u1002\u100f\u1014\u1039\u1038\u1000\u102d\u102f \u1006\u102d\u102f\u107e\u1000\u1015\u102b\u1010\u101a\u1039\u104b \u1021\u1032\u101e\u100a\u1039\u1019\u103d\u102c relative reference \u1014\u1032\u1094 absolute reference \u1006\u102d\u102f\u103b\u1015\u102e\u1038 \u101b\u103d\u102d\u1015\u102b\u1010\u101a\u1039\u104b \u101e\u102c\u1019\u1014\u1039 \u1021\u1031\u1015\u105a\u1000 \u1021\u100a\u108a\u108a\u1014\u1039\u1038\u1000\u1031\u1010\u102c\u1037 relative reference \u1015\u102b\u104b A1 \u1006\u102d\u102f\u1010\u102c \u1031\u1000\u102c\u1039\u101c\u1036 A \u1014\u1032\u1094 \u1021\u1010\u1014\u1039\u1038 1 \u1006\u102f\u1036\u101b\u102c Cell \u101c\u102d\u1015\u1039\u1005\u102c\u1021\u100a\u108a\u1014\u1039\u1038\u1015\u102b\u104b \u1021\u1032\u101e\u100a\u1039 \u101c\u102d\u1015\u1039\u1005\u102c\u1021\u100a\u108a\u1014\u1039\u1038\u1011\u1032\u1037\u1011\u102c\u1038\u1010\u1032\u1037 Cell \u1000\u102f\u102d \u1031\u1000\u102c\u1039\u1015\u102e\u1000\u1030\u1038\u103b\u1015\u102e\u1038 \u1021\u103b\u1001\u102c\u1038 Cell \u1021\u101e\u1005\u1039\u1000\u102d\u102f \u1031\u1015\u1037\u1005\u1039 \u101c\u102f\u1015\u1039\u101c\u102d\u102f\u1000\u1039\u101b\u1004\u1039 \u1006\u102d\u102f\u1004\u1039\u101b\u102c\u1021\u100a\u108a\u1014\u1039\u1038\u101c\u102d\u1015\u1039\u1005\u102c\u101c\u100a\u1039\u1038 (relative reference) \u101c\u100a\u1039\u1038 \u101c\u102d\u102f\u1000\u1039\u1031\u103b\u1015\u102c\u1004\u1039\u1038\u1015\u102b\u1010\u101a\u1039\u104b absolute reference \u1006\u102d\u102f\u1010\u102c\u1000\u1031\u1010\u102c\u1037 \u1015\u102f\u1036\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038\u101c\u102d\u1015\u1039\u1005\u102c\u1015\u102b\u104b A1 \u1011\u1032\u1000 \u1000\u102d\u1014\u1039\u1038\u1000\u102d\u102f \u1021\u103b\u1001\u102c\u1038 Cell \u1031\u1010\u103c\u1000\u1031\u1014 \u100a\u108a\u1014\u1039\u1038\u1006\u102d\u102f\u101b\u1004\u1039 \u101e\u1030\u1000 \u101c\u102d\u1015\u1039\u1005\u102c\u1021\u1031\u103b\u1015\u102c\u1004\u1039\u1038\u1019\u101b\u103d\u102d \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u103b\u1016\u1005\u1039 \u101c\u102d\u102f\u1000\u1039\u1015\u102b\u1010\u101a\u1039\u101c\u102d\u102f\u1094 \u1006\u102d\u102f\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n
\u1012\u102b\u1000\u102d\u102f \u1025\u1015\u1019\u102c\u1031\u1010\u103c\u1014\u1032\u1094 \u101b\u103d\u1004\u1039\u1038\u103b\u1015\u1019\u103d \u101b\u103d\u1004\u1039\u1038\u1015\u102b\u101c\u102d\u1019\u1039\u1037\u1019\u101a\u1039\u104b<\/span><\/div>\n
to copy and fill relative and absolute references.<\/span><\/div>\n

Relative references<\/span><\/h3>\n

 <\/p>\n

\u1025\u1015\u1019\u102c\u1000\u1031\u1010\u102c\u1037 A \u1031\u1000\u102c\u1039\u101c\u1036\u1014\u1032\u1094 B \u1031\u1000\u102c\u1039\u101c\u1036\u1000 \u1002\u100f\u1014\u1039\u1038 \u1042 \u101c\u102f\u1036\u1038\u1005\u102e\u1000\u102d\u102f \u1031\u1015\u102b\u1004\u1039\u1038\u103b\u1015\u102e\u1038 C \u1031\u1000\u102c\u1039\u101c\u1036\u1011\u1032 \u1000\u1030\u1038\u1011\u100a\u1039\u1037\u1010\u101a\u1039 \u1006\u102d\u102f\u107e\u1000\u1015\u102b\u1005\u102d\u102f\u1094\u104b<\/span><\/div>\n
\n\n\n\n\n<\/colgroup>\n\n\n\n\n
\n
A<\/span><\/div>\n<\/td>\n
\n
B<\/span><\/div>\n<\/td>\n
\n
C<\/span><\/div>\n<\/td>\n<\/tr>\n
\n
1<\/span><\/div>\n<\/td>\n
\n
2<\/span><\/div>\n<\/td>\n
\n
=A1+B1<\/span><\/div>\n<\/td>\n<\/tr>\n
\n
3<\/span><\/div>\n<\/td>\n
\n
4<\/span><\/div>\n<\/td>\n
\n
=A2+B2<\/span><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

 <\/p>\n

C1 \u1019\u103d\u102c \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1000\u102d\u102f =A1+B1 \u101c\u102d\u102f\u1094 \u101b\u102d\u102f\u1000\u1039\u1011\u100a\u1039\u1037\u103b\u1015\u102e\u1038 C2 \u1006\u102e\u1000\u102d\u102f C1 \u1000 \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038\u1000\u102d\u102f \u1031\u1000\u102c\u1039\u1015\u102e\u1031\u1015\u1037\u1005\u1039 \u101c\u102f\u1015\u1039\u101c\u102d\u102f\u1000\u1039\u101b\u1004\u1039 \u1021\u101c\u102d\u102f\u1021\u1031\u101c\u103a\u102c\u1000\u1039 C2 = A2+B2 \u1031\u103b\u1015\u102c\u1004\u1039\u1038\u101e\u103c\u102c\u1038\u1010\u102c \u1031\u1010\u103c\u1094\u101b\u1015\u102b\u1010\u101a\u1039\u104b \u1012\u102b\u1000 \u1006\u1032\u101c\u1039\u1011\u1032\u1000 \u1021\u100a\u108a\u1014\u1039\u1038\u101f\u102c \u1006\u102d\u102f\u1004\u1039\u101b\u102c\u1021\u101c\u102d\u102f\u1000\u1039\u1031\u103b\u1015\u102c\u1004\u1039\u1038\u108f\u102d\u102f\u1004\u1039\u1010\u1032\u1037 \u101c\u102d\u1015\u1039\u1005\u102c – relatvie reference \u1031\u1010\u103c \u103b\u1016\u1005\u1039\u1031\u1014\u101c\u102d\u102f\u1094\u1015\u102b\u1015\u1032\u104b Sheet \u1005\u102c\u101b\u1004\u1039\u1038\u1031\u1010\u103c\u1019\u103d\u102c \u1012\u102e\u101c\u102d\u102f\u1019\u103a\u1033\u102d\u1038 \u1021\u101e\u102f\u1036\u1038\u1019\u103a\u102c\u1038\u1010\u1032\u1037\u1021\u1010\u103c\u1000\u1039 relatvie cell \u1031\u1010\u103c\u1014\u1032\u1094 \u100a\u108a\u1014\u1039\u1038\u103b\u1015\u102e\u1038 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1031\u1010\u103c \u1011\u100a\u1039\u1037\u107e\u1000\u1031\u101c\u1037\u101b\u103d\u102d\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n

 <\/p>\n

To create and copy a formula using relative references:<\/span><\/h4>\n

 <\/p>\n

\u1031\u1021\u102c\u1000\u1039\u1000 \u1031\u1005\u103a\u1038\u1031\u101b\u102c\u1004\u1039\u1038\u1005\u102c\u101b\u1004\u1039\u1038\u1019\u103d\u102c \u1031\u1005\u103a\u1038\u108f\u1088\u1014\u1039\u1038\u104a \u1021\u1031\u101b\u1021\u1010\u103c\u1000\u1039\u104a \u1010\u1019\u103a\u1033\u102d\u1038\u1001\u103a\u1004\u1039\u1038 \u1000\u103a\u101e\u1004\u1039\u1037\u1031\u1004\u103c (Unit Price, Quantity, Line Total) \u1000\u102d\u102f \u1005\u102c\u101b\u1004\u1039\u1038\u101c\u102f\u1015\u1039\u1011\u102c\u1038\u1015\u102b\u1010\u101a\u1039\u104b Line Total \u1031\u1000\u102c\u1039\u101c\u1036\u1019\u103d\u102c \u1015\u1005\u1065\u100a\u1039\u1038\u1010\u1001\u102f\u1001\u103a\u1004\u1039\u1038\u1005\u102e \u1000\u103a\u101e\u1004\u1039\u1037\u1031\u1004\u103c \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1000\u102d\u102f \u1011\u100a\u1039\u1037\u101b\u1015\u102b\u1010\u101a\u1039\u104b \u1015\u1011\u1019\u1015\u1005\u1065\u100a\u1039\u1038\u1000\u102d\u102f \u1010\u103c\u1000\u1039\u103b\u1015\u102e\u1038\u1010\u102c\u1014\u1032\u1094 \u1021\u1032\u101e\u100a\u1039\u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038\u1021\u1010\u102d\u102f\u1004\u1039\u1038 \u1000\u103a\u1014\u1039\u1010\u1032\u1037\u1015\u1005\u1065\u100a\u1039\u1038\u1031\u1010\u103c\u1000\u102d\u102f\u101c\u100a\u1039\u1038 \u1010\u103c\u1000\u1039\u101c\u102d\u102f\u1094 \u101b\u1010\u102c\u1019\u102d\u102f\u1094 ( line total = unit price X quantity) D4 \u1019\u103d\u102c relatvie refrence \u1014\u1032\u1094 cell \u1000\u102d\u102f \u100a\u108a\u1014\u1039\u1038\u103b\u1015\u102e\u1038 \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1000\u102d\u102f \u1011\u100a\u1039\u1037\u1015\u102b\u1019\u101a\u1039\u104b<\/span><\/div>\n

 <\/p>\n

    \n
  1. \n
    cell<\/span> D4<\/span> \u1000\u102d\u102f \u1031\u101b\u103c\u1038\u1015\u102b\u104b<\/span><\/div>\n<\/li>\n
  2. \n
    \"Selecting<\/span><\/div>\n<\/li>\n
  3. \n
    Enter the <\/span>formula<\/span> =B4*C4<\/span>. \u1006\u102d\u102f\u103b\u1015\u102e\u1038 \u101b\u102d\u102f\u1000\u1039\u1011\u100a\u1039\u1037\u1015\u102b\u104b<\/span><\/div>\n<\/li>\n
  4. \n
    \"Entering<\/span><\/div>\n<\/li>\n
  5. \n
    Press<\/span> Enter<\/span> \u101c\u102f\u1015\u1039\u101c\u102d\u102f\u1000\u1039\u101b\u1004\u1039 \u1000\u103a\u1004\u1039\u1037\u101e\u1004\u1039\u1037\u1031\u1004\u103c\u1000\u102d\u102f \u1031\u1010\u103c\u1094\u101b\u1015\u102b\u1019\u101a\u1039\u104b<\/span><\/div>\n<\/li>\n
  6. \n
    Select cell <\/span>D4<\/span>. \u1000\u102d\u102f \u1031\u1019\u102c\u1000\u1039\u1005\u1039\u1014\u1032\u1094 \u1000\u101c\u1005\u1039\u1015\u102b\u104b <\/span>fill handle<\/span> ( + sign) \u1031\u1015\u105a\u101c\u102c\u1031\u1021\u102c\u1004\u1039 \u1031\u101b\u103c\u1094\u1015\u102b\u104b <\/span><\/div>\n<\/li>\n
  7. \n
    \"The<\/span><\/div>\n<\/li>\n
  8. \n
    Click and drag the <\/span>fill handle<\/span> \u104b \u1021\u1032\u101e\u100a\u1039\u1019\u103d\u102c \u1031\u1019\u102c\u1000\u1039\u1005\u1039\u1000\u102d\u102f \u1016\u102d\u1006\u103c\u1032\u103b\u1015\u102e\u1038 D4 \u1000\u102d\u102f D5:D13 \u1031\u1010\u103c\u1021\u1011\u102d \u1031\u1000\u102c\u1039\u1015\u102e \u1031\u1015\u1037\u1005\u1039 \u103b\u1016\u100a\u1039\u1037\u101c\u102d\u102f\u1000\u1039\u1015\u102b\u104b<\/span><\/div>\n<\/li>\n
  9. \n
    cells <\/span>D5:D13<\/span>.<\/span>\"Dragging<\/span><\/div>\n<\/li>\n
  10. \n
    Release the mouse. \u1031\u1019\u102c\u1000\u1039\u1005\u1039\u1000\u102d\u102f \u101c\u108a\u1010\u1039\u101c\u102d\u102f\u1000\u1039\u1015\u102b\u104b D4 \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038\u1000 D5 \u1000\u1031\u1014 D13 \u103b\u1016\u100a\u1039\u1037\u1031\u1015\u1038\u1010\u1032\u1037\u1021\u103b\u1015\u1004\u1039 <\/span>relative references<\/span> \u1021\u103b\u1016\u1005\u1039 \u101e\u1000\u1039\u1006\u102d\u102f\u1004\u1039\u101b\u102c B X C \u1006\u1032\u101c\u1039 \u1010\u1014\u1039\u1016\u102d\u102f\u1038\u1031\u1010\u103c\u1000\u102d\u102f \u1031\u103b\u1019\u103d\u102c\u1000\u1039\u1031\u1015\u1038\u1015\u102b\u101c\u102d\u1019\u1039\u1037\u1019\u101a\u1039\u104b<\/span><\/div>\n<\/li>\n
  11. \n
    \"Viewing<\/span><\/div>\n<\/li>\n<\/ol>\n
    \u1019\u101a\u102f\u1036\u101b\u1004\u1039 D8 \u1000\u102d\u102f double click \u101c\u102f\u1015\u1039\u107e\u1000\u100a\u1039\u1037\u1015\u102b\u104b \u00a0D8 = B8*C8 \u1021\u103b\u1016\u1005\u1039 \u101e\u1000\u1039\u1006\u102d\u102f\u1004\u1039\u101b\u102c\u1021\u100a\u108a\u1014\u1039\u1038\u1021\u1010\u102d\u102f\u1004\u1039\u1038 \u1031\u103b\u1015\u102c\u1004\u1039\u1038\u103b\u1015\u102e\u1038 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c \u1010\u103c\u1000\u1039\u1011\u102c\u1038\u1010\u102c\u1000\u102d\u102f \u1031\u1010\u103c\u1094\u101b\u1015\u102b\u101c\u102d\u1019\u1039\u1037\u1019\u101a\u1039\u104b <\/span><\/div>\n
    \"Double-clicking<\/span><\/div>\n

    Absolute references<\/span><\/h3>\n
    \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038<\/span><\/div>\n

     <\/p>\n

    \u1021\u1001\u103a\u1033\u102d\u1094\u1000\u102d\u1005\u1065\u101b\u1015\u1039\u1031\u1010\u103c\u1019\u103d\u102c\u1031\u1010\u102c\u1037 cell \u1010\u1001\u102f\u1000\u102d\u102f \u100a\u108a\u1014\u1039\u1038\u1006\u102d\u102f\u101b\u102c\u1019\u103d\u102c \u101c\u102d\u1015\u1039\u1005\u102c\u1000\u102d\u102f \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1011\u102c\u1038\u103b\u1015\u102e\u1038 \u100a\u108a\u1014\u1039\u1038\u101b\u1010\u102c\u1031\u1010\u103c \u101b\u103d\u102d\u1015\u102b\u1010\u101a\u1039\u104b \u101e\u1030\u1094\u1000\u102d\u102f \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1011\u1032 \u1011\u100a\u1039\u1037\u101c\u102d\u102f\u1000\u1039\u1010\u1032\u1037\u1021\u1001\u102b \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1011\u100a\u1039\u1037\u1011\u102c\u1038\u1010\u1032\u1037 cell \u1031\u103b\u1015\u102c\u1004\u1039\u1038\u101e\u103c\u102c\u1038\u1010\u102c\u104a \u1031\u1000\u102c\u1039\u1015\u102e\u1000\u1030\u1038\u103b\u1015\u102e\u1038 \u1031\u1014\u101b\u102c\u1031\u101b\u108a\u1094\u101e\u103c\u102c\u1038\u1010\u102c \u101b\u103d\u102d\u1031\u1015\u1019\u101a\u1039\u1037 \u1021\u1032\u101e\u100a\u1039 \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038\u1000\u1031\u1010\u102c\u1037 \u101c\u102d\u102f\u1000\u1039\u1031\u103b\u1015\u102c\u1004\u1039\u1038\u101c\u102d\u102f\u1094 \u1019\u103b\u1016\u1005\u1039\u1010\u102c \u101b\u103d\u102d\u1015\u102b\u1010\u101a\u1039\u104b \u1021\u1032\u101e\u100a\u1039\u1000\u103a\u101b\u1004\u1039 absolute reference \u1000\u102d\u102f \u1006\u1032\u101c\u1039\u101c\u102d\u1015\u1039\u1005\u102c\u1019\u103d\u102c dollar sign $ \u1031\u101b\u103d\u1094\u1000 \u1010\u1010\u1039\u103b\u1015\u102e\u1038 \u100a\u108a\u1014\u1039\u1038\u101b\u1015\u102b\u1010\u101a\u1039\u104b \u1031\u1000\u102c\u1039\u101c\u1036\u1021\u101c\u102d\u102f\u1000\u1039\u104a \u1021\u1010\u1014\u1039\u1038\u1021\u101c\u102d\u102f\u1000\u1039\u104a \u1031\u1000\u102c\u1039\u101c\u1036\u1014\u1032\u1094\u1010\u1014\u1039\u1038 \u1006\u102f\u1036\u101b\u102c \u1006\u1032\u101c\u1039\u1010\u1001\u102f\u1001\u103a\u1004\u1039\u1038\u1021\u101c\u102d\u102f\u1000\u1039\u1000\u102d\u102f \u1021\u1031\u101e\u100a\u108a\u1014\u1039\u1038\u1010\u102c\u1019\u103d\u102c \u101e\u102f\u1036\u1038\u1015\u102b\u1010\u101a\u1039\u104b \u1031\u1021\u102c\u1000\u1039\u1000 \u100a\u108a\u1014\u1039\u1038\u1006\u102d\u102f\u1015\u102f\u1036\u1000\u102d\u102f \u107e\u1000\u100a\u1039\u1037\u1015\u102b\u104b<\/span><\/div>\n

     <\/p>\n

    \"The<\/span><\/div>\n
    \n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
    <\/td>\n\n
    A<\/span><\/div>\n<\/td>\n
    		\n
    B<\/span><\/div>\n<\/td>\n
    		\n
    C<\/span><\/div>\n<\/td>\n<\/tr>\n
    \n
    1<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
    \n
    2<\/span><\/div>\n<\/td>\n
    		\n
    $A$2<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/td>\n<\/tr>\n
    \n
    3<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
    \u1006\u1032\u1010\u1001\u102f\u1010\u100a\u1039\u1038 \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038<\/span><\/div>\n
    \n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
    <\/td>\n\n
    A<\/span><\/div>\n<\/td>\n
    		\n
    B<\/span><\/div>\n<\/td>\n<\/tr>\n
    \n
    1<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/td>\n<\/tr>\n
    \n
    2<\/span><\/div>\n<\/td>\n
    		\n
    A$2<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/tr>\n
    \n
    3<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
    \u1021\u1010\u1014\u1039\u1038 \u1010\u1001\u102f\u1010\u100a\u1039\u1038 \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038<\/span><\/div>\n
    \n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
    <\/td>\n\n
    A<\/span><\/div>\n<\/td>\n
    		\n
    B<\/span><\/div>\n<\/td>\n<\/tr>\n
    \n
    1<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/td>\n<\/tr>\n
    \n
    2<\/span><\/div>\n<\/td>\n
    		\n
    $A2<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/tr>\n
    \n
    3<\/span><\/div>\n<\/td>\n
    		<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
    \u1031\u1000\u102c\u1039\u101c \u1010\u1001\u102f\u1010\u100a\u1039\u1038 \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038<\/span><\/div>\n

     <\/p>\n

    \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1010\u1001\u102f\u1010\u100a\u1039\u1038\u1000\u102d\u102f \u1031\u101a\u1018\u1030\u101a\u103a\u1021\u102c\u1038\u103b\u1016\u1004\u1039\u1037 \u100a\u108a\u1014\u1039\u1038\u107e\u1000\u1031\u101c\u1037\u101b\u103d\u102d\u1010\u102c\u1019\u102d\u102f\u1094 \u1021\u101e\u102f\u1036\u1038\u1019\u103a\u102c\u1038\u1010\u102c\u1000\u1031\u1010\u102c\u1037 $A$2 \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n

    To create and copy a formula using absolute references:<\/span><\/h4>\n
    \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038\u103b\u1016\u1004\u1039\u1037 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1000\u102d\u102f CELL \u1019\u103a\u102c\u1038\u1010\u103c\u1004\u1039 \u1031\u1000\u102c\u1039\u1015\u102e\u1015\u103c\u102c\u1038\u103b\u1001\u1004\u1039\u1038<\/span><\/div>\n

     <\/p>\n

    \u1031\u1021\u102c\u1000\u1039\u1031\u1016\u102c\u1039\u103b\u1015\u1015\u102b \u1025\u1015\u1019\u102c\u1019\u103d\u102c E2 \u1019\u103d\u102c \u1011\u100a\u1039\u1037\u1011\u102c\u1038\u1010\u1032\u1037 (tax rate) \u1021\u1001\u103c\u1014\u1039\u108f\u1088\u1014\u1039\u1038 7.5% \u1000\u102d\u102f \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038 absolute reference \u1011\u102c\u1038\u1015\u102b\u1019\u101a\u1039\u104b \u1000\u102f\u1014\u1039\u1015\u1005\u1065\u100a\u1039\u1038\u1010\u1001\u102f\u1001\u103a\u1004\u1039\u1038\u1005\u102e\u101b\u1032\u1037 \u1021\u1031\u101b\u102c\u1004\u1039\u1038\u1019\u103d\u102c \u1000\u103a\u101e\u1004\u1039\u1037\u1031\u1004\u103c\u1021\u101c\u102d\u102f\u1000\u1039 \u1021\u1001\u103c\u1014\u1039\u1010\u103c\u1000\u1039\u101b\u102c\u1019\u103d\u102c \u1021\u1001\u103c\u1014\u1039\u108f\u1088\u1014\u1039\u1038 7.5% \u1000\u102d\u102f \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038\u1021\u1031\u1014\u1014\u1032\u1094 \u1031\u103b\u1019\u103d\u102c\u1000\u1039\u1031\u1016\u102c\u1039\u1000\u102d\u1014\u1039\u1038\u101c\u102f\u1015\u1039 \u1010\u103c\u1000\u1039\u101b\u1019\u103d\u102c \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b Sale tax \u1000\u102d\u102f \u1010\u103c\u1000\u1039\u101b\u102c\u1019\u103d\u102c – sale tax = unit price X quanitity X tax rate \u1010\u103c\u1000\u1039\u101b\u102c\u1019\u103d\u102c unti price \u1014\u1032\u1094 quanitity \u1031\u1014\u101b\u102c\u1031\u1010\u103c \u1010\u1014\u1039\u1016\u102d\u102f\u1038\u1031\u1010\u103c \u1031\u103b\u1015\u102c\u1004\u1039\u1038\u101e\u103c\u102c\u1038\u1031\u101e\u102c\u1039\u101c\u100a\u1039\u1038 \u00a0tax rate \u1000 e2 \u1021\u1010\u102d\u102f\u1004\u1039\u1038 \u1000\u102d\u1014\u1039\u1038\u1031\u101e\u1021\u100a\u108a\u1014\u1039\u1038 \u103b\u1016\u1005\u1039\u101b\u1019\u103d\u102c \u1019\u102d\u102f\u1094 \u101e\u1030\u1094\u1000\u102d\u102f e2 \u101c\u102d\u102f\u1094 \u1019\u1031\u103b\u1015\u102c\u1018\u1032 $E$2 \u101c\u102d\u102f\u1094 absolute reference \u101c\u102f\u1015\u1039\u101b\u1019\u103d\u102c \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n

     <\/p>\n

      \n
    1. \n
      D4 \u1019\u103d\u102c tax rate \u1031\u103b\u1019\u102c\u1000\u1039\u1031\u1016\u102c\u1039\u1000\u102d\u1014\u1039\u1038\u101e\u102f\u1036\u1038\u103b\u1015\u102e\u1038 \u1000\u103a\u101e\u1004\u1039\u1037\u1010\u1032\u1037 \u101e\u1000\u1039\u1006\u102d\u102f\u1004\u1039\u101b\u102c sales tax \u1000\u102d\u102f \u1010\u103c\u1000\u1039\u107e\u1000\u101b\u1031\u1021\u102c\u1004\u1039\u104b<\/span><\/div>\n<\/li>\n
    2. \n
      \"Selecing<\/span><\/div>\n<\/li>\n
    3. \n
      Enter the <\/span>formula D4 <\/span>= <\/span>(B4*C4)*$E$2<\/span>, <\/span>$E$2<\/span> \u1000 absolute reference \u1021\u103b\u1016\u1005\u1039\u1011\u102c\u1038\u1015\u102b\u104b<\/span><\/div>\n<\/li>\n
    4. \n
      \"Entering<\/span><\/div>\n<\/li>\n
    5. \n
      Press <\/span>Enter <\/span>\u101c\u102d\u102f\u1000\u1039\u101b\u1004\u1039 \u1000\u103a\u101e\u1004\u1039\u1037\u1010\u1032\u1037 \u1021\u1001\u103c\u1014\u1039\u108f\u1088\u1014\u1039\u1038 \u1011\u103c\u1000\u1039\u101c\u102c\u1015\u102b\u103b\u1015\u102e\u104b<\/span><\/div>\n<\/li>\n
    6. \n
      Cell <\/span>D4<\/span> \u1000\u102d\u102f \u00a0<\/span>fill handle<\/span> \u1031\u1015\u105a\u1031\u1021\u102c\u1004\u1039\u101c\u102f\u1015\u1039\u103b\u1015\u102e\u1038 \u1031\u1021\u102c\u1000\u1039\u1000\u102d\u102f \u1006\u103c\u1032\u1001\u103a \u1031\u1000\u102c\u1039\u1015\u102e \u101c\u102f\u1015\u1039\u1015\u102b\u104b \u1031\u1021\u102c\u1000\u1039\u1000 \u1000\u102f\u1014\u1039\u1015\u1005\u1065\u100a\u1039\u1038\u1010\u1001\u102f\u1001\u103a\u1004\u1039\u1038\u1021\u101c\u102d\u102f\u1000\u1039 \u101e\u1000\u1039\u1006\u102d\u102f\u1004\u1039\u101b\u102c sale tax \u1000\u102d\u102f \u1010\u103c\u1000\u1039\u1001\u102d\u102f\u1004\u1039\u1038\u107e\u1000\u100a\u1039\u1037\u101b\u1019\u101a\u1039\u104b <\/span><\/div>\n<\/li>\n
    7. \n
      \"Locating<\/span><\/div>\n<\/li>\n
    8. \n
      (cells <\/span>D5:D13<\/span>) \u1000\u102d\u102f D4 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c \u103b\u1016\u100a\u1039\u1037\u101c\u102d\u102f\u1000\u1039\u1015\u102b\u103b\u1015\u102e\u104b<\/span><\/div>\n<\/li>\n
    9. \n
      \"Dragging<\/span><\/div>\n<\/li>\n
    10. \n
      \u1031\u1019\u102c\u1000\u1039\u1005\u1039\u1000\u102d\u102f \u101c\u108a\u1010\u1039\u101c\u102d\u102f\u1000\u1039\u1015\u102b\u104a \u1000\u102f\u1014\u1039\u1015\u1005\u1065\u100a\u1039\u1038\u1010\u1001\u102f\u1001\u103a\u1004\u1039\u1038\u1021\u101c\u102d\u102f\u1000\u1039 \u1000\u103a\u101e\u1004\u1039\u1037\u1010\u1032\u1037 tax rate \u1031\u103b\u1019\u103d\u102c\u1000\u1039\u1031\u1016\u102c\u1039\u1000\u102d\u1014\u1039\u1038\u1014\u1032\u1094 \u1010\u103c\u1000\u1039\u1031\u1015\u1038\u1011\u102c\u1038\u1010\u102c\u1000\u102d\u102f \u1031\u1010\u103c\u1094\u101b\u1019\u101a\u1039\u104b <\/span><\/div>\n<\/li>\n<\/ol>\n

       <\/p>\n

        \n
      1. \n
        \"Viewing<\/span><\/div>\n<\/li>\n<\/ol>\n
        \u103b\u1015\u1014\u1039\u1005\u1005\u1039\u107e\u1000\u100a\u1039\u1037\u1001\u103a\u1004\u1039\u101b\u1004\u1039\u1031\u1010\u102c\u1037 D8 \u1000\u102d\u102f \u1000\u101c\u1005\u1039\u101c\u102f\u1015\u1039\u107e\u1000\u100a\u1039\u1037\u1015\u102b\u104b D8 = (B8*C8)*$E$2 \u101c\u102d\u102f\u1094 \u1031\u1010\u103c\u1094\u101b\u1019\u101a\u1039\u104b tax rate \u1000 \u1021\u103b\u1019\u1032\u1010\u1014\u1039\u1038 absolute reference \u103b\u1016\u1005\u1039\u1031\u1014\u1010\u102c \u103b\u1019\u1004\u1039\u101b\u1019\u101a\u1039\u104b <\/span>\"Double-clicking<\/span><\/div>\n

         <\/p>\n

        \u1019\u101a\u102f\u1036\u101b\u1004\u1039 D4 = (B4*C4)Be sure to include the <\/span>dollar sign ($)<\/span> \u1000\u102d\u102f\u103b\u1016\u1033\u1010\u1039\u103b\u1015\u102e\u1038 \u1005\u1019\u1039\u1038\u107e\u1000\u100a\u1039\u1037\u1031\u1005\u101c\u102d\u102f\u1015\u102b\u1010\u101a\u1039\u104b<\/span><\/div>\n
        #Value \u1006\u102d\u102f\u103b\u1015\u102e\u1038 \u1031\u1015\u105a\u101c\u102c\u101b\u1004\u1039 \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c \u1019\u103d\u102c\u1038\u101c\u102d\u102f\u1094 \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b <\/span><\/div>\n
        \"Absolute<\/span><\/div>\n

        Challenge! \u1021\u102d\u1019\u1039\u1005\u102c<\/span><\/h3>\n
          \n
        1. \n
          \u1031\u1021\u102c\u1000\u1039\u1015\u102b\u1021\u1010\u102d\u102f\u1004\u1039\u1038 \u1031\u1005\u103a\u1038\u1005\u102c\u101b\u1004\u1039\u1038\u1000\u102d\u102f \u1031\u1016\u102c\u1039\u103b\u1019\u1034\u101c\u102c\u1011\u100a\u1039\u1037\u1015\u102b\u104b \u1021\u1013\u102d\u1000 absolute reference \u1000\u1031\u1010\u102c\u1037 Discount rate \u1000\u102d\u102f \u1041\u1045% \u1031\u1015\u1038\u1010\u102c \u103b\u1016\u1005\u1039\u1015\u102b\u1010\u101a\u1039\u104b discount \u1031\u1015\u1038\u103b\u1015\u102e\u1038\u1031\u1010\u102c\u1037\u1019\u103d line total \u1000\u102d\u102f \u1010\u1001\u102f\u1001\u103a\u1004\u1039\u1038\u1005\u102e\u1021\u1010\u103c\u1000\u1039 \u1010\u103c\u1000\u1039\u1014\u100a\u1039\u1038\u1000\u102d\u102f \u1011\u100a\u1039\u1037\u101b\u1015\u102b\u1019\u101a\u1039\u104b <\/span><\/div>\n<\/li>\n
        2. \n
          \"cell<\/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 (30) \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   \u1006\u1032\u101c\u1039\u1019\u103a\u102c\u1038\u1000\u102d\u102f \u100a\u108a\u1014\u1039\u1038\u1006\u102d\u102f\u103b\u1001\u1004\u1039\u1038 \u1006\u1032\u101c\u1039\u1019\u103a\u102c\u1038\u1000\u102d\u102f \u100a\u108a\u1014\u1039\u1038\u1006\u102d\u102f\u101b\u102c\u1019\u103d\u102c \u101c\u102d\u1015\u1039\u1005\u102c A1… <\/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-60846","post","type-post","status-publish","format-standard","hentry","category-961","category-856"],"_links":{"self":[{"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/posts\/60846"}],"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=60846"}],"version-history":[{"count":0,"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/posts\/60846\/revisions"}],"wp:attachment":[{"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/media?parent=60846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/categories?post=60846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/moemaka.net\/wpmmk\/wp-json\/wp\/v2\/tags?post=60846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}