Back to lesson
1. What is a relative range name?
This is a range name which does not use absolute cell references (i.e. there are no $ signs). This means as the formula containing the range name is copied the corresponding range moves too.
This is a range name that uses the INDIRECT function.
This is a range name that refers to another range name.
2. Using the data table pictured, how can I create the range names Apples, Oranges, Lemons, Spring, Summer, Fall and Winter very quickly, where each range name relates to a particular row or column of the data table?
Highlight the table and use the keyboard shortcut F3
Highlight the table and use the keyboard shortcut CTRL + F3
Highlight the table and use the keyboard shortcut CTRL + SHIFT + F3
3. In the illustration, which range name(s) must be relative?
Both Current_Period_Sales and Last_Period_Row_Above
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement