TechKnowSurge
CompTIA Tech+ 3.3
TechKnowSurge Catalog Interactives Spreadsheet Formulas
InteractiveComputeFree

Spreadsheet Formulas

Name the cell, start the formula, work out what =A1+A2, SUM and AVERAGE show, and what a sort puts first.

⚑ Complete this interactive to capture a CTF flag worth 5 points.

About this interactive

A spreadsheet is a grid. Columns run down the sheet and are lettered A, B, C; rows run across and are numbered 1, 2, 3. Each box is a cell, named by its column and then its row: A1 is column A, row 1. A formula starts with an equal sign. =A1+A2 adds whatever is in A1 and A2, and it is dynamic: change A1 and the result changes by itself. SUM adds every number in a range of cells, and AVERAGE adds them and divides by how many there are. Sorting a column in descending order puts the largest value first. Type the missing value in each line. Capitals do not matter; type numbers as digits.

What you'll learn

Aligned to

CompTIA Tech+
3.3 Explain the purpose and proper use of software.

Key terms

Spreadsheet
A software application used to store, organize, compute, and analyze data arranged in rows and columns.
Cell
The basic unit of a spreadsheet, identified by a column letter and row number (e.g., A1), where data or formulas are entered.
Formula
An expression entered into a cell, beginning with an equal sign, that performs calculations using values or cell references.

Topics

Spreadsheet Cell Formula Interactive Fill In

About TechKnowSurge

TechKnowSurge builds IT and cybersecurity professionals through hands-on, concept-first training built around real understanding — not memorization. Free interactive tools, structured programs, and 25+ years of real-world experience, all in one place.

Explore free tools and programs →