HOW TO
FIND DIFFERENCE, PRODUCT AND DIVISION OF DATA [SCORES] IN EXCEL
Procedures and concepts to
consider:
- Have a data into cells [that are to be processed] Example 13,25,14, . . .
- Identify the column name and row name
- Identify the range of data into cells [that are to be added]
Example
B3 to D3 (B3:D3)
DIFFERENCE
[ – ]
[Between
Cell B3
and Cell C3
; OR Test II Scores minus
Test I Scores]
- Syntax: '' = (C3-B3) ''
PRODUCT [ * ]
[Multiply
Cell D3
by 2
; OR Multiply
Test III Scores by two(2)]
- Syntax: '' = (D3*2) ''
DIVISION [ / ]
[Divide
Cell B3
by 2
; OR Divide
Test I Scores by two (2)]
- Syntax: '' = (B3/2) ''
NOTE:
In writing formula, use semi-colon [;] if you use OpenOffice
otherwise use comma only [,] if you use Microsoft office
OTHER EXCEL FUNCTIONS [SYNTANX]
No comments:
Post a Comment