Please enable JavaScript.
Coggle requires JavaScript to display documents.
SPREADSHEETS - Coggle Diagram
SPREADSHEETS
THINK MORE ON FORMULA VS FUNCTION
HOW CAN SOMETHING BE BOTH ?
FUNCTION ONLY TAKES INPUTS AND GIVES OUTPUT
THEY ARE ALL PREDEFINED IN THE SPREADSHEET
ROUGLY WE MAY SAY THAT FUNCTIONS ARE THE FORMULAS FOR SPECIFIC TASKS THAT ARE PROVIDED AUTOMATICALLY WITH THE SPREADSHEET PROGRAM
FORMULA COSNISTS OF A EXPRESSION/STATEMENT INVOLVING FUNCTION OPERATORS AND VARIABLES/VALUES THAT EVALUATES TO SOMETHING
THEY ARE CREATED BY USERS
FORMULAS
ALWAYS BEGIN WITH AN EQUAL SIGN
FOLLOWED BY AN MATEMATICAL EXPRESSION
EXPRESSION INVOLVES
OPERATORS , NUMBERS , CELL REFERENCES
CELL REFERENCES BASICALLY ARE ALIASES THAT ARE USED TO REFER TO THE CELL VALUES INSIDE THE SPREADSHEETS AND CAN BE USED IN FORMULAS
FOR EXAMPLE FOR THE VALUE IN COLUMN C and row 8 can be referneced as C8
sometimes we want a range of cells then we can use for example C1:C9
THESE ARE TWO TYPES
ABSOLUTE
RELATIVE
TIPS
YOU CAN COPY FORMUALS!
FUNCTION
doubt
CAN WE DEFINE OUR OWN NEW FUNCTIONS ??
PROBABLY NO
basically this is one of key difference between function and formula
TIP
YOU CAN ALSO COPY FUNCTIONS!!!
TOOLS
PIVOT TABLES
DOUBTS
WHAT HAPPENS WHEN WE CHOOSE FROM SUMMARIZE BY CUSTOM
TIPS
WHEN TO USE SINGLE QUOTES