What is a relative range name?

Answer 1

This is a range name that uses the INDIRECT function.

Answer 2

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.

Answer 3

This is a range name that refers to another range name.

Answer 4

Don’t know

Answer 5

Highlight the table and use the keyboard shortcut F3

Answer 6

Highlight the table and use the keyboard shortcut CTRL + SHIFT + F3

Answer 7

Highlight the table and use the keyboard shortcut CTRL + F3

Answer 8

Don’t know

Answer 9

Current_Period_Sales

Answer 10

Last_Period_Row_Above

Answer 11

Both Current_Period_Sales and Last_Period_Row_Above

Answer 12

Don’t know

What is a relative range name?

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?

In the illustration, which range name(s) must be relative?