My online activity at Economic Informatics
I had a review over:- Operators used in formulas(^,*,/,+,-,&,=,<,>);- Entering a formula (form worksheet, manually, by pointing, using formula AutoComplete);- Summing Formulas (Ex: =SUM(DATA) ; =SUM(A1:A9, C1:C9); =SUM(A:A) ; =SUM(SHEET1!1:10485) ; =SUM(B1,5,"6", "SQRT(4), A1:A5, TRUE) );- Using the reference;- Text formulas (LEFT, RIGHT, MID, TRIM, LEN, FIND, SEARCH, REPT, CONCATENATE, REPLACE, VALUE, UPPER, LOWER, CHAR);
I had a review over:
ReplyDelete- Operators used in formulas(^,*,/,+,-,&,=,<,>);
- Entering a formula (form worksheet, manually, by pointing, using formula AutoComplete);
- Summing Formulas (Ex: =SUM(DATA) ; =SUM(A1:A9, C1:C9); =SUM(A:A) ; =SUM(SHEET1!1:10485) ; =SUM(B1,5,"6", "SQRT(4), A1:A5, TRUE) );
- Using the reference;
- Text formulas (LEFT, RIGHT, MID, TRIM, LEN, FIND, SEARCH, REPT, CONCATENATE, REPLACE, VALUE, UPPER, LOWER, CHAR);