Essentials · Foundations

Formula Foundations

4 lessons and 56 marked steps, with a workbook to open in Excel alongside. Your first two lessons on LogicExcel are free with a free account; after that every lesson opens with the All-Access Pass.

1. 1. Writing your first formulasAll-Access Pass

   Build arithmetic formulas that reference cells, total a column with AutoSum, and choose the aggregate that answers the question actually asked.

   14 marked steps

2. 2. Order of operations and parenthesesAll-Access Pass

   Predict the result of a mixed-operator formula, use parentheses to force the order you meant, and correct a formula that returns a plausible wrong number.

   14 marked steps

3. 3. Relative references and copyingAll-Access Pass

   Copy a formula down a column and across a row, predict what happens to its references, and recognise the copy that keeps working while returning nonsense.

   14 marked steps

4. 4. Absolute and mixed referencesAll-Access Pass

   Use the dollar sign to hold a row, a column, or both still, and choose which of the three the situation actually needs.

   14 marked steps

Finished Foundations? Sit the Foundations exam for its certificate.