Please enable JavaScript.
Coggle requires JavaScript to display documents.
Unit 3: Final Revision - Coggle Diagram
Unit 3: Final Revision
-
Functions
-
-
-
-
=SUM(Cell,Cell) adds up both cells
=Lookup(What we match, range of match, Find new info)
=Vlookup(What we match, range of match, Find new info)
=Hlookup(What we match, range of match, Find new info)
Sumif: =Sumif(Range,"car",range of what you want to add)
-
-
-
Sorting, Filter on the right side of the hotbar. used for putting information in order (i.e alphabetical..)
-
Conditional formatting, Find in format: used for highlighting a group of information.
Charts and graphs
Extra vocab: title, gridlines
-
-
-
-
-
-