Excel Cell Links
Excel Cell Relationships
#excel #excelformulas
Full Excel course https://gog.su/Ar8E
Basic Formulas • Курс по Excel. Базовые формулы
Personal Work Assignments:
1. Watch the video
2. Download the file https://docs.google.com/spreadsheets/...
3. On the "Assignment 1" sheet, fill in the data as in the video
4. On the "Assignment 2" sheet, in the cell In B5, fill out a formula that will reference A1 and calculate a percentage of the number to the left. The formula must be written so that it works when you drag it down (hint: you need to use either an absolute reference or an absolute row reference). Drag the formula across 20 cells. Replace 10% with 20% in cell A1 and verify that the formula works correctly for all cells.
5. Attach the file as a completed assignment.
If you have any questions about absolute or relative cells, feel free to ask! This is an important topic.
P.S. Be careful. You may have disabled formula recalculation in the previous lesson. If formulas aren't recalculating, you may not have re-enabled it.