# Articles sur le thème : Cell reference

## 3D Function

Excel performs calculations in a spreadsheet but it is also possible to perform calculations across multiple worksheets, this is called 3-dimensional (3D) functions. What is the problem? Say you have a workbook that contains one sheet per month. You want to create a worksheet that will synthesize all these month in a worksheet “Year”. You …

## Basic calculation

Excel allows you to do all kinds of calculations and respect mathematical rules. We will see how to perform simple calculations (addition, subtraction, multiplication, division) and also how to perform operations that use several different operators without making any mistakes 😉 The = sign In Excel, all the calculations or formulas start with the = …

## Absolute Relative References

The cell reference is the code that identify a cell: A1, B3, C15, … BJ375. But in Excel, it’s not just reference, we have absolute, relative and mixed references (but what-is-this-stuff 😲🤔🤨) It is very important to understand this concept because very often in a spreadsheet, you have important data that must be used in your formulas: …