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
- Enter data, apply number, date and currency formats and adjust columns
- Write formulas using operators and the SUM, AVERAGE, MIN and MAX functions
- Copy formulas with relative, absolute and mixed references and predict the result
- Use the fill handle, freeze panes and keyboard shortcuts to work faster
- Reference cells across sheets in the same workbook
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