Skip to main content

Foundations for Excels

Excel foundations are the basics of working in a workbook: sheets, cells, number and date formatting, and formulas that start with an equals sign. Cell references can be relative, such as A1, or absolute, such as $A$1, and the difference controls what happens when a formula is copied.

Stage: Spreadsheet Basics · Part of the Excel roadmap · Last reviewed 19 November 2026

What to learn in Foundations

Foundations interview questions

What is the difference between A1 and $A$1?

A1 is a relative reference that shifts when the formula is copied to another cell. $A$1 is absolute, with both column and row locked by dollar signs, so it always points at the same cell. Mixed references like $A1 lock only one part.

Why does a cell sometimes show ##### instead of a value?

The column is too narrow to display the number or date, or a negative date or time is present. Widening the column fixes the first case. It does not mean the underlying value is lost.

Where Foundations fits in the Excel roadmap

Foundations belongs to the Spreadsheet Basics stage (beginner level). Cells and formulas.

Back to the full Excel roadmap