Microsoft Excel is a powerful spreadsheet program used for calculating, data analysis, graphing etc.
CELLS AND RANGE
A cell is where a data is entered while a range is a selection of multiple cells.
FORMULAS
It is used to perform calculations with basic arithmetic operations. FUNCTIONS: e.g.SUMSum (Number 1,Numberb 2). It adds value in the range.
Average (Number 1, Number 2) It calculates the average.
IF: If (condition value (if true), value (if false) to create conditional logic e.g. (if (logical text {200} >= any value {300}, (good) (poor)).
NESTED IFIt is a duplicate of (if) in a spread sheet. E.g. (if {number>= {value}, if {number>= {value})) etc.
| NAMES | SCORE | SCHOOL |
|---|---|---|
| Ayo | 120 | Repeated |
| Bola | 200 | College |
| Dave | 300 | Polytechnic |
| Fave | 100 | Repeated |
| Sylvia | 150 | College |
| Justice | 400 | University |
Length: it is used to count letters on a sheet.
Left: used to count letters from the left side of a text.
Right: used to count letters from the right side of a text.Concatenate: it is used to join two or more text together.eg =concatenate (text1, text
2)Substitute: it is used to replace text.eg= sub (text, old text, new text)
SHORTCUT KEYS COMBINATION
CTRL C/ CTRL V: Copy and paste.
CTRL S: Save.
