Revision notes

Spreadsheets: Foundation

The key points, rules to remember, tables and diagrams from all 9 lessons, on one page for quick revision. To keep a copy, use your browser's Print and choose "Save as PDF".

Lesson 1

Workbooks, worksheets, rows, columns and cells

Data types
TypeExampleNote
Text (label)RohitLeft-aligned by default
Number (value)250Right-aligned by default
Date04-10-2026Stored as a number internally
Formula=B2+B3Always starts with =

Cell address = column letter + row number. A range uses a colon: B2:B6.

— Remember
  • Workbook contains worksheets; sheets contain a grid of cells.
  • Columns are letters; rows are numbers.
  • A formula starts with =.
Read the full lesson

Lesson 2

Formulas and operators

Operators
OperatorMeaning
+Add
-Subtract
*Multiply
/Divide
^Power (exponent)

Start with =. Use cell addresses so answers update. Brackets, power, multiply/divide, add/subtract.

— Remember
  • Formulas begin with = and use + - * / ^.
  • Order: brackets, power, * and /, then + and -.
  • Cell addresses keep results up to date.
Read the full lesson

Lesson 3

Common functions: SUM, AVERAGE, MAX, MIN and COUNT

Functions
FunctionDoesExample
SUMAdds the numbers=SUM(B2:B6)
AVERAGEMean of the numbers=AVERAGE(B2:B6)
MAXLargest number=MAX(B2:B6)
MINSmallest number=MIN(B2:B6)
COUNTHow many cells hold numbers=COUNT(B2:B6)
IFChooses between two results=IF(B2>=40,"Pass","Fail")

SUM adds, AVERAGE means, MAX largest, MIN smallest, COUNT counts numbers, IF decides.

— Remember
  • Functions work on ranges: =NAME(range).
  • COUNT counts numbers only; IF returns one of two results.
  • Check your answers by hand on small ranges.
Read the full lesson

Lesson 4

Cell references: relative, absolute and mixed

Reference types
WrittenTypeCopy B2 down 1 row
B2RelativeB3
$B$2Absolute$B$2
$B2Mixed (column fixed)$B3
B$2Mixed (row fixed)B$2

Relative moves, absolute (with $) stays put. The F4 key toggles the dollars in many programs.

— Remember
  • Relative references shift when copied; absolute references do not.
  • Use $ to lock a column, a row, or both.
Read the full lesson

Lesson 5

Sorting, filtering and charts

Choosing a chart
ChartBest for
Column / barComparing values between categories
LineShowing change over time
PieShowing parts of a whole
ScatterShowing how two measures relate

Sort = reorder, Filter = show matching rows only, Pie = parts of a whole, Line = trend over time.

— Remember
  • Sorting orders rows; filtering hides the rest.
  • Choose the chart by what you want to show.
  • Select the whole table before sorting.
Read the full lesson

Lesson 6

Entering data, AutoFill and number formats

What the fill handle produces
You enterDrag the handle and you get
MondayTuesday, Wednesday, Thursday and so on
JanFeb, Mar, Apr and so on
1 and 2 (both selected)3, 4, 5 and so on
5 and 10 (both selected)15, 20, 25 and so on
A single number such as 77, 7, 7 (copied) in most programs
A formulaThe formula, with relative references adjusted

A format changes the look, not the value. Two cells give a series; one cell gives a copy.

Key takeaways. Text goes left and numbers go right. The fill handle extends patterns, and two starting cells fix the step. Number formats such as percentage change only the display, and #### means the column is too narrow.

Read the full lesson

Lesson 7

Percentages and everyday formulas: share, discount, profit and change

Common percentage formulas
QuestionFormula ideaSpreadsheet form (values in cells)
What share is part of whole?part / whole=B2/B3 then percentage format
Discount amountprice x rate=B2*C2 with C2 = 15%
Price after discountprice - discount=B2-B2*C2
Profitselling price - cost price=C2-B2
Profit percentageprofit / cost price x 100=(C2-B2)/B2
Percentage change(new - old) / old=(C2-B2)/B2

Part divided by whole gives the share. Change divided by the old value gives the percentage change.

Key takeaways. Divide the part by the whole for a share, multiply the price by the rate for a discount, and divide the change by the old value for a percentage change. Use brackets and cell addresses, and ROUND when you need a tidy answer.

Read the full lesson

Lesson 8

Comparison operators and the IF function

The six comparison operators
OperatorMeaningExampleResult when A1 = 40
=Equal to=A1=40TRUE
<>Not equal to=A1<>40FALSE
>Greater than=A1>40FALSE
<Less than=A1<40FALSE
>=Greater than or equal to=A1>=40TRUE
<=Less than or equal to=A1<=40TRUE

IF asks a question: true gives the first answer, false gives the second.

Key takeaways. Comparisons return TRUE or FALSE. IF chooses between two results, and a nested IF chooses among more. Put text in quotation marks and read nested IFs from the outside in.

Read the full lesson

Lesson 9

Managing worksheets and moving around quickly

Useful spreadsheet shortcuts
KeysAction
Ctrl + HomeGo to cell A1
Ctrl + EndGo to the last used cell (bottom-right of the used area)
Ctrl + Arrow keyJump to the edge of the current block of data
F2Edit the contents of the active cell
Alt + EnterStart a new line inside the same cell
Ctrl + ;Enter today's date
Ctrl + ASelect the current block of data; press again for the whole sheet
Ctrl + SSave the workbook

Freeze keeps headings in view; protect keeps formulas safe; print area limits what prints.

Key takeaways. Rename sheets with clear names, freeze panes for long lists, protect sheets that hold formulas and learn Ctrl + Home, Ctrl + End and F2 for fast movement.

Read the full lesson

Privacy · Terms · Refunds · Delivery