Set explicit report identity, sheet-name and page fields in Apache OpenOffice Calc headers and footers, then inspect output for unwanted file paths.
Styles and templates · Intermediate
Unclassified: check guide
Add a linear fit and explicit measurement-error bars to an XY chart, then test the distinction between trend and uncertainty.
Charts and visualization · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Create document hyperlinks to two local sheets and verify destinations, edits and link removal independently of calculations.
Workbook organization · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice desktop exercise based on historical OpenOffice.org 3 Calc manual; current UI unverified
Subtract full start and end datetimes, deduct breaks, reject invalid intervals and display a total greater than 24 hours.
Practical projects · Intermediate
Unclassified: check guide
Compare an untracked revision with its original and merge tracked copies without confusing the direction of review.
Workbook workflows · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Choose a numeric X axis for uneven measurements, then build a column-and-line comparison with clearly labeled scales.
Charts and visualization · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Create a Calc-only shortcut and document toolbar, then verify keyboard navigation without replacing familiar system shortcuts.
Automation and productivity · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Consolidate differently ordered department tables by row and column labels, compare linked results, and verify range growth.
Data analysis · Intermediate
Unclassified: check guide
Separate stale calculation from circular references, test hard recalculation and use iteration only for a deliberate convergent model; inspect date origin separately with a fixed numeric serial.
References and calculation · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Transfer a custom cell style to another Calc workbook, verify its use, and replace old assignments before deleting an unwanted definition.
Styles and templates · Intermediate
Unclassified: check guide
Check copied filter results against row IDs and totals, and distinguish filtering from manually hiding rows before sharing an extract.
Sorting and filtering · Intermediate
Unclassified: check guide
Create a monthly record count in Apache OpenOffice Calc, group dates by years and months, refresh the source and verify a sales-summary benchmark.
Pivot tables and analysis · Intermediate
Unclassified: check guide
Store a Basic worksheet function in an ODS document, handle scalar and range inputs, and diagnose library-loading problems after reopening.
Formulas and analysis · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice 4.1 desktop Calc Guide; English menu labels; no installed-build or operating-system certification
Use an Apache OpenOffice Calc criteria range for AND and OR filters, copy matching records safely and rerun without stale rows.
Data management · Intermediate
Unclassified: check guide
Create positive, negative and zero number-format sections while preserving the underlying values for calculations.
Formatting and layout · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Create regional subtotals, expand and collapse outline groups, check totals, and rebuild from clean source records.
Data analysis · Intermediate
Unclassified: check guide
Extract unique complete records with Standard Filter, preserve source rows, and verify copied results after edits and range growth.
Data management · Intermediate
Unclassified: check guide
Filter an OpenOffice pivot by region, drill into contributing records, reconcile sums, and refresh the source deliberately.
Pivot tables and analysis · Intermediate
Unclassified: check guide
Limit Find and Replace to selected cells in Apache OpenOffice Calc, audit exact matches and distinguish formula, value and regex searches.
Data entry and editing · Intermediate
Unclassified: check guide
Insert a linked worksheet and a named external range, then check which source edits reach each destination.
References and calculation · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Create a formula link between two ODS files, verify saved-source updates, and repair a moved source without trusting stale values.
References and calculation · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Insert a linked Calc OLE object into Writer, distinguish it from an embedded copy, and verify an edited source total.
References and calculation · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Define formula names and database ranges in Apache OpenOffice Calc, extend their boundaries, and check totals across sheets.
Ranges and names · Intermediate
Unclassified: check guide
Set up a bounded linear Solver model, verify its optimum independently, and reject results that violate constraints.
Analysis and modeling · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Rename, move and copy Apache OpenOffice Calc sheets, check formula dependencies, and navigate to a named range.
Workbook organization · Intermediate
Unclassified: check guide
Create an opening-password-protected ODS copy and verify that it requires the password without confusing encryption with edit protection.
Sharing, safety and accessibility · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Solve a one-variable profit model with Goal Seek, check the target independently, and reject impossible or impractical results.
What-if analysis · Intermediate
Unclassified: check guide
Record a harmless Paste Special macro inside an ODS document and replay it with explicit clipboard and selection prerequisites.
Formulas and analysis · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Add cell comments, record edits, accept one change and reject another in Apache OpenOffice Calc with a recoverable ODS workflow.
Collaboration and review · Intermediate
Unclassified: check guide
Mark matching records with case-sensitive helper formulas in Apache OpenOffice Calc, distinguish duplicate groups from later copies and preserve originals.
Data cleanup · Intermediate
Unclassified: check guide
Build one- and two-input sensitivity tables with Multiple Operations, keeping the row and column input cells straight.
Workbook workflows · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Store annotated versions inside an ODS file, inspect an older read-only version, and recover it without losing the original history.
Sharing, safety and accessibility · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Store named price-and-volume assumptions, switch scenarios safely, and avoid overwriting the baseline through Copy back.
What-if analysis · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Trace a wrong total to its actual input with Detective, correct the cause, and verify every dependent result.
Formula auditing · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Register a local spreadsheet through Base, select its records in Calc, and check an eight-row sales report without assuming automatic refresh.
External data · Intermediate
Unclassified: check guide
Enter and edit a fixed-size Calc array formula while protecting the full output range from partial changes.
References and calculation · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Anchor report graphics deliberately, test their response to inserted rows, and keep visual annotations separate from the data.
Workbook workflows · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested
Give an OpenOffice Calc summary and detail sheet different print layouts, avoid shared page-style changes and verify an exported report.
Styles and templates · Intermediate
Unclassified: check guide
Understand traditional shared Calc files, rehearse a save conflict, and verify the retained values before continuing.
Sharing, safety and accessibility · Intermediate
Unclassified: check guide
Guide’s version scope
Apache OpenOffice Calc 4.1 desktop; English menus; Windows/Linux keys where used; documentary exercise, not native-tested