Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc – Scenarios, Goal Seek, and Macros (Vocabulary)

Vocabulary flashcards covering key concepts in LibreOffice Calc, including data analysis tools, scenarios, and macros.

LibreOffice Calc

The spreadsheet component of LibreOffice used for entering, manipulating, and analyzing data.

Spreadsheet

A grid of rows and columns used to organize data and perform calculations.

Calc file extension (.ods)

The default file extension for LibreOffice Calc spreadsheets.

Page layout

A formatting feature not used for data analysis in spreadsheets.

What-if analysis

A planning tool to explore how changing input values affects outputs.

What-if scenario

A named set of input values used within calculations to compare outcomes.

Scenario

A named collection of input values used in What-if analysis to test variations.

Goal Seek

A tool that finds the input value needed to achieve a specified result in a formula.

Consolidate function

A tool to combine data from multiple sheets into one for summarizing and comparing.

Sum (default consolidate function)

The default aggregation function used when consolidating data.

Group by (Group and Outline)

A feature used to apply summary functions on grouped data (rows or columns) in Calc.

Absolute cell reference

A fixed cell address in a formula, shown with $ (e.g., $C$5) that does not change when copied.

Relative cell reference

A cell address that changes when the formula is copied (e.g., C5).

Hyperlink

A link from a cell or object to another location, file, or web page.

Relative hyperlink

A hyperlink that stores the path relative to the current file location.

Absolute hyperlink

A hyperlink that stores the complete path to the target.

Link to External Data

A method to retrieve data from an external file or workbook into Calc.

LibreOffice Base (.odb)

The database file extension used by LibreOffice Base.

Insert Sheet

Command to add a new worksheet to a Calc workbook.

Data consolidation steps

Open workbook, Data > Consolidate, choose function, add references, OK.

Subtotal

A tool to group data and apply a chosen summary function to each group.

What-if Scenarios

Creating scenarios under Data > Scenarios to explore alternatives.

Multiple Operations tool

Creates a formula array to display results for alternative values in a list.

Goal Seek steps

Tools > Goal Seek; Set cell; To value; By changing cell; OK.

Macro

A recorded sequence of commands used to automate repetitive tasks.

Macro Recorder

A tool to record actions for creating a macro.

LibreOffice Basic

The programming language used to write LibreOffice macros.

LibreOffice Macros Library

Library containing pre-recorded macros provided by LibreOffice.

My Macros

A user-created macro library that can be customized.

Standard Library

The default macro library loaded automatically (contains standard macros).

Macro1

A common default macro name used when creating a first macro.

Main

Default name of a macro saved in the Standard Library as Main.

Sub and End Sub

Macro blocks begin with ….. and end with...

Predefined function

Functions built into Calc (e.g., SUM, AVERAGE) that cannot be altered.

Macros as a function

User-defined functions created with Basic to perform calculations.

Macro naming rules

Must begin with a letter; no spaces; no special characters except underscore.

Advantages of macros

Automate repetitive tasks and perform complex operations with reusable code.

Tracking Changes

Feature to record and manage edits in a shared spreadsheet.

Share Spreadsheet

Feature to allow multiple users to access and edit the same workbook.

Comment

A note attached to a cell change explaining what was changed.

Merge vs Compare (in sharing)

Merge combines data from sheets; Compare highlights differences between two sheets.

Steps to share a worksheet

Open a spreadsheet, Tools > Share Spreadsheet, enable sharing, then save.

Linking sheets

Creating references to other sheets or external data to summarize across sources.

Two advantages of data analysis tools

Identify patterns/trends/relationships and predict outcomes to optimize decisions.

What is a spreadsheet?

A grid of rows and columns used to organize, analyze, and calculate data (examples: MS Excel, LibreOffice Calc, Google Sheets).

Two common data-analysis tools in Calc

Goal Seek and Scenarios (What-if analysis)