Digital skills
Functions and Cell References
Updated Oct 28, 2026
Functions perform common calculations. SUM adds a range, and AVERAGE calculates its mean. Relative references change when a formula is copied; dollar signs can fix a row or column in an absolute refer
What you’ll learn
Understand and practise functions and cell references.
Explanation
Functions perform common calculations. SUM adds a range, and AVERAGE calculates its mean. Relative references change when a formula is copied; dollar signs can fix a row or column in an absolute reference such as $B$1. Check formulas after copying them.
Functions ជួយគណនាដូចជា SUM បូកជួរ និង AVERAGE រកមធ្យម។ Relative reference ប្រែពេលចម្លង formula; $B$1 ជាអាសយដ្ឋានថេរ។
Example
With 2, 3, and 5 in B2:B4, =SUM(B2:B4) returns 10.
Practice
Why use $B$1 for a fixed tax rate when copying a formula?
Answer and explanation
Show answer / បង្ហាញចម្លើយ
The absolute reference keeps the formula pointing to B1 as it is copied.
Quick recap
Functions perform common calculations.