head 1.6; access; symbols; locks; strict; comment @# @; 1.6 date 2017.06.18.00.32.09; author root; state Exp; branches; next 1.5; 1.5 date 2017.06.17.13.32.51; author root; state Exp; branches; next 1.4; 1.4 date 2017.06.16.12.30.14; author root; state Exp; branches; next 1.3; 1.3 date 2017.06.16.11.49.01; author root; state Exp; branches; next 1.2; 1.2 date 2017.06.16.10.59.55; author root; state Exp; branches; next 1.1; 1.1 date 2017.03.11.08.10.46; author root; state Exp; branches; next ; desc @This document (Tabulating Bill: 3-Formula and Auto-complete) is re-created by black-flamingo-cc on 05 June 2016 @ 1.6 log @This document (Tabulating Bill: 3-Formula and Auto-complete) is lastly updated by administrator status:PUBLISHED on 18 June 2017 @ text @{ "_id": { "$oid": "58c3b106a6127d0161b3850d" }, "_type": "GSystem", "access_policy": "PUBLIC", "altnames": null, "annotations": [], "attribute_set": [], "author_set": [ 1 ], "collection_set": [], "comment_enabled": null, "content": "
Calculating \"Amount(Rs.)\" column values:
\r\n \r\n\r\n
Now that we have entered values for columns Sr. No., Particulars, Quantity and Rate(Rs.), we have to enter values in the \"Amount\" column.
\r\n\r\n
But we will not enter this values directly, instead we will use formula for computing this values.
\r\n\r\n
In this way, we will be able able to verify the bill amounts and additionally we will learn one new feature of spreadsheet.
\r\n\r\n
 
\r\n\r\n
So select the cell \"E2\" using mouse's left click or arrow keys.
\r\n\r\n
Write the formula as \"=C2*D2\" and press enter.
\r\n\r\n
We will get the rresult of the multiplication of two values from cell C2 and D2 i.e. 10*15 = 150.
\r\n
\r\n
\r\n 
\r\n\r\n
Now select the cell \"E3\" and write the formula as \"=C3*D3\".
\r\n\r\n
We will get answer as 240.
\r\n
\r\n
\r\n
\r\n\r\n
 
\r\n\r\n
Now we will not write this formula for every row, instead we will use auto-complete feature of spreadsheet.
\r\n\r\n
For doing that, go back to cell \"E3\" and select it.
\r\n\r\n
After cell getting selected, we can see a \"small tiny square\" at the right bottom corner of the cell E3.
\r\n
\r\n 
\r\n\r\n
\r\n\r\n
 
\r\n\r\n\r\n\r\n

\r\n
\r\n 
\r\n", "content_org": "None", "contributors": [ 1 ], "created_at": 1465151247262, "created_by": 1, "featured": null, "group_set": [ { "$oid": "58c3b08ba6127d0161b38321" } ], "if_file": { "mid": { "id": null, "relurl": null }, "mime_type": null, "original": { "id": null, "relurl": null }, "thumbnail": { "id": null, "relurl": null } }, "language": [ "en", "English" ], "last_update": 1497765729626, "legal": { "copyright": "CC-BY-SA 4.0 unported", "license": "HBCSE" }, "location": [], "login_required": null, "member_of": [ { "$oid": "5752ad552e01310a05dca4a1" } ], "modified_by": 1, "module_set": [], "name": "Tabulating Bill: 3-Formula and Auto-complete", "origin": [ { "fork_of": { "$oid": "575339af2e013103d72b1db2" } } ], "plural": null, "post_node": [], "prior_node": [], "property_order": [], "rating": [], "relation_set": [], "snapshot": { "5752b2ac2e01310424dcf43c": "1.39", "58c3b08ba6127d0161b38321": "1.3" }, "start_publication": null, "status": "PUBLISHED", "tags": [ "calc", "help", "spreadsheet", "data entry", "2-1-14" ], "type_of": [ { "$oid": "5752ad572e01310a05dca507" } ], "url": "page" }@ 1.5 log @This document (Tabulating Bill: 3-Formula and Auto-complete) is lastly updated by administrator status:PUBLISHED on 17 June 2017 @ text @d20 1 a20 1 "created_at": 1465131447262, d47 1 a47 1 "last_update": 1497726171630, @ 1.4 log @This document (Tabulating Bill: 3-Formula and Auto-complete) is lastly updated by administrator status:PUBLISHED on 16 June 2017 @ text @d47 1 a47 1 "last_update": 1497636014759, @ 1.3 log @This document (Tabulating Bill: 3-Formula and Auto-complete) is lastly updated by administrator status:PUBLISHED on 16 June 2017 @ text @d47 1 a47 1 "last_update": 1497633541059, d76 2 a77 1 "5752b2ac2e01310424dcf43c": "1.39" @ 1.2 log @This document (Tabulating Bill: 3-Formula and Auto-complete) is lastly updated by administrator status:PUBLISHED on 16 June 2017 @ text @d10 3 a12 1 "author_set": [], d20 1 a20 1 "created_at": 1465111647262, d47 1 a47 1 "last_update": 1497630595489, @ 1.1 log @Initial revision @ text @d16 1 a16 1 24 d18 2 a19 2 "created_at": 1465091847262, "created_by": 24, d45 5 a49 2 "last_update": 1489239646204, "license": "CC BY-SA", d57 1 a57 1 "modified_by": 24, @