Exponential =EXP(num)
Logarithm =LOG(num;base)
Round =ROUNDDOWN(num;decimal digit)
0 = solo numero intero, 1 = una cifra decimale
=ROUNDUP(num;decimal digit)
Absolute reference = to fix a cell $A$1
Relative reference To fix the column $D1
To fix the row D$1
Sum =SUM(A1:A5)
Rand =RAND() from 0 to 1
=RAND()*100 from 0 to 100
Cross-sheet reference Sheet1!cell (use $ to fix cells)
Conditional formatting: highlight all the cells
containing …
- Select the column
- Click the Conditional Formatting button
- Choose Highlight Cells Rules: Equal to
- Type …
Apply a color scale from light green to dark green to the Column
“Weekly Allowance”
•Put a red circle when the value is ≥ 20, yellow when ≥ 10 or green
otherwise
-formattazione condizionale
-Manage rules (gestisci regole)
-Set di icone
-Inverti ordine icone (tipo: numero)
Conditional Formatting: apply a colour scale -Select the column
-Click the Conditional Formatting button
-Choose scale of colours
Conditional Formatting: put a red circle when
the value is < , yellow when it is >
-Select the column
-Click the Conditional Formatting button
-Choose Manage Rules
-Format Style: set of icons
Inverti orgine icone
Tipo: numero
