Absolute and Relative References in Excel

Описание к видео Absolute and Relative References in Excel

This video demonstrates how to use absolute and relative reference in Microsoft Excel. Relative references update as a user copies formulas and absolute references stay the same. This allows a user to easily refer to a constant in a range of several cells. A comparison of both types of reference is performed. Methods for copying formulas down rows and across columns are covered, including autofill and the “control + enter” method. The steps for changing relative references into absolute references, including using the F4 key, are reviewed.

Комментарии

Информация по комментариям в разработке

Похожие видео