What is Spreadsheet Software?
Definition
Definition: Spreadsheet software is a computer application that helps store large amounts of data and perform calculations on it.
Examples
- Microsoft Excel, LibreOffice Calc, Google Sheets.
Rows, Columns and Cells
- 1
Row: Runs horizontally (side by side).
- 2
Column: Runs vertically (up and down).
- 3
Cell: The box where a row and a column meet.
- 4
Cell address: Formed by the column name and row name - e.g. A1 is the active cell's address.
Workbook and Worksheet
- 1
Worksheet: A single page of the spreadsheet where data is stored.
- 2
Workbook: A collection of worksheets - a new workbook opens with three worksheets by default.
Inserting and Deleting Rows/Columns
Insert a column
- 1
Step 1: Select a cell in the worksheet.
- 2
Step 2: Select the Insert menu and click Column.
- 3
Step 3: A new column is inserted to the left of the selected cell.
- Insert a row the same way - a new row appears above the selected one.
- Deleting removes the entire row/column with its data.
- In the book's activity, planets were stored with a 'Distance' column - closest planet = 1, farthest = 8.
Basic Functions
- 1
sum: Adds all the values.
- 2
min / max: Smallest / largest value.
- 3
count: Counts the number of values.
- 4
average: The mean of the values.
