Functions and Charts in Calc
Functions in Calc
Text Functions
Syntax
Mathematical Functions
Round()
GCD()
LCM()
UPPER()
LEN()
LOWER()
Date & Time functions
Date()
Time()
Today()
Logical Functions
IF()
Charts
Errors
#######
#Name?
#REF!
#Value! error
#Div/0! error
Cell Referencing
Relative Reference
Absolute Reference
Mixed Reference
Line Chart
Bar Chart
Column Chart
Pie Chart
Sort, Filter and Highlight data
Sorting
Filtering
Conditional Formating