[go: up one dir, main page]
Scribd
Upload
7 views1 page

Calc Basics

Uploaded by

stefan.perovski20
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views1 page

Calc Basics

Uploaded by

stefan.perovski20
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

■ LibreOffice Calc Cheat Sheet (Condensed)

<b>Basics</b> <b>Shortcuts</b> <b>Formulas</b>


Workbook = file Ctrl+C / Ctrl+V = Copy/Paste =A1+B1 (Add)
Cell Reference = A1 Ctrl+Z / Ctrl+Y = Undo/Redo =A1-B1 (Subtract)
Ranges = A1:A10 Ctrl+Arrows = Jump =A1*B1 (Multiply)
Relative = A1 Ctrl+Shift+Arrows = Select =A1/B1 (Divide)
Absolute = $A$1 Ctrl+1 = Format =A1^B1 (Power)
=SUM(A1:A10)
=AVERAGE(A1:A10)
=MAX(A1:A10)
=MIN(A1:A10)
=COUNT(A1:A10)
<b>Logical</b> <b>Text</b> <b>Date & Time</b>
=IF(A1>10;"Yes";"No") =CONCATENATE(A1;" ";B1) =TODAY()
=AND(A1>0;B1<5) =LEFT(A1;3) =NOW()
=OR(A1=0;B1=0) =RIGHT(A1;2) =DAY(A1)
=NOT(A1=5) =LEN(A1) =MONTH(A1)
=LOWER(A1)/UPPER(A1) =YEAR(A1)
=TRIM(A1)
<b>Useful Features</b>
Sort: Data → Sort
Filter: Data → AutoFilter
Charts: Insert → Chart
Freeze: View → Freeze Cells
Conditional Formatting

You might also like