Practise Calc formulas and charts
Editable workbooks for cell references, missing values, elapsed hours, selected summaries and chart choices.
Keep shared inputs fixed when copying Calc formulas
Copy one calculation down and a small matrix across without shifting the inputs they share.
Count blank inputs and empty formula results in Calc
Inspect cell types before choosing a completeness count.
Show totals beyond 24 hours in Calc
Keep accumulated durations numeric and display the full number of hours.
Switch a Calc summary with one team selector
Retrieve one team’s task count from an editable source table.
Choose grouped or stacked columns in Calc
Use the same inputs for two different reporting questions.
Keep uneven numeric spacing in a Calc scatter chart
Plot paired measurements on a numeric horizontal axis.
Count fixed histogram intervals in Calc
Use editable upper limits and keep boundary values in the intended bin.
Draw a task timeline from dates in Calc
Display an agreed calendar-day schedule with editable task bars.