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