Gnumeric Features
Choose a category below to find a practical feature tutorial. This reference covers the accepted guides listed here, not every feature supported by this program.
Names and references
Create and Maintain Named Ranges in GnumericDefine workbook and sheet names in Gnumeric, audit their scope, extend a named range and check a reversible rate change.Copy Formulas with A1 and R1C1 References in GnumericUse relative, absolute and mixed references in Gnumeric, switch a sheet to R1C1, and check copied formulas with a downloadable price matrix.Reference Another Workbook Safely in GnumericLearn Gnumeric external-reference syntax, local file paths, recalculation limits and a changed-input check before trusting a linked report.
Charts and visualization
Build and Update a Column or Line Chart in GnumericBuild a Gnumeric column or line chart from four monthly counts, assign category and value ranges, then test edits and added rows.Annotate a Report with Images and Drawings in GnumericInsert an original practice PNG, add an arrow beside a report total, and distinguish floating objects from worksheet cells and exported report output.
Freeze panes and navigation
Cell formatting and layout
Number, date and currency formatting
Comments and navigation
Getting started
Data entry and filling
Fill Sequences and Copy a Model Safely in GnumericGenerate bounded numeric and weekly date sequences in Gnumeric, fill a calculation column, and distinguish generated values from live formulas.Control AutoCorrect Initial Capitals in GnumericTest Gnumeric's two-initial-capitals correction, add a deliberate exception, and restore preferences without changing existing data.Enter Data Through a Selected Region in GnumericUse Enter to work down columns or Tab to work across rows inside a selected Gnumeric rectangle, with explicit direction and boundary checks.Generate a Random-Integer Table in GnumericUse Gnumeric's Random Number Generation dialog for a fixed 20-cell integer table. Check its size, bounds and values without expecting a repeatable sequence.
Paste special
Find and replace
Workbook organization
Organize, Hide and Resize Worksheets in GnumericBuild a cross-sheet summary, hide and restore a source tab, and safely resize one Gnumeric worksheet without changing every sheet.Group Detail Rows with Expandable Outlines in GnumericCreate two row outline groups, leave subtotals visible, and check that collapsing detail changes presentation rather than the underlying totals.Review Workbook Properties Before Handoff in GnumericGive a synthetic workbook a clear document title and description, distinguish properties from cell comments, and verify a revised copy without claiming complete sanitization.Set Reversible Workspace Defaults in GnumericTest Gnumeric's new-workbook sheet count and zoom defaults without confusing them with existing workbook contents, then recover a hidden toolbar and restore your settings.
Templates
Import and export
Formula troubleshooting
Analysis and modeling
Check normality before choosing a statistical testRun a documented normality test with a probability plot, check sample count, and interpret an outlier without treating a p-value as proof.Compare saved what-if scenariosSave named input sets, preview them in Scenario Manager, and keep a scenario report without accidentally canceling it.Run and check a Monte Carlo simulationRun a bounded uniform Monte Carlo model, compare simulated statistics with theory, and retain reports without expecting identical random results.Run two-factor ANOVA with and without replicationSet rows per sample correctly for two-factor ANOVA, reconcile sums of squares, and avoid claiming an interaction test without replication.Consolidate Regional Tables by Label in GnumericUse Gnumeric's Consolidate tool to match row and column labels across reordered tables, check the combined figures and distinguish values from formula output.Control Model Inputs with Checkboxes and Sliders in GnumericLink a checkbox and an integer slider to a small cost model, check both states and endpoints, and keep formulas separate from widget-controlled inputs.Check Selected Values with Status Calculations in GnumericUse Gnumeric's running calculation to check a selected range, distinguish numeric Count from row count, and avoid mistaking a temporary display for a saved formula.Build a Covariance Table in GnumericUse Gnumeric's Covariance analysis tool with aligned observations, correct labels and grouping, and a checked population-covariance example.Test a Hypothesized Median with Gnumeric's Sign TestRun Gnumeric's one-sample Sign Test, count ties correctly, and interpret its binomial probabilities without confusing it with Wilcoxon.Compare Two Variances with Gnumeric's F-Test ToolUse Claims About Two Variances in Gnumeric, set labeled sample ranges, and interpret its F ratio, directional probabilities and two-sided cutoffs.Test a Contingency Table for Independence in GnumericRun Gnumeric's chi-squared independence analysis with numeric counts, correct labels, expected-count checks and an independently checked example.Compare Independent Sample Means in GnumericChoose Gnumeric's unpaired equal-variance t, Welch t or known-variance z tool and check one original example without confusing independent and paired data.Use Gnumeric's One-Sample Wilcoxon Signed Rank TestCheck signed ranks, zero differences and Gnumeric 1.12.62's normal-approximation limits with a twelve-observation Wilcoxon example.
Workbook workflows
Solve an integer-constrained planning modelSolve a small mixed-integer-capable planning model and prove why rounding the continuous relaxation is not an acceptable substitute.Shuffle Complete Records with Integrity Checks in GnumericRearrange synthetic records using Gnumeric's Rows shuffle mode, preserve the original, and detect broken ID/item/quantity relationships.Set Up Auto Save Safely in GnumericConfigure Gnumeric Auto Save, keep an independent checkpoint, and verify saved changes without mistaking timed saves for crash recovery or version history.