3
AssignmentMultiple Choice

Cell and Range Names

Question 3 • GA-Business and Technology B Ammons 2025-2026

What does the @ symbol in a formula mean?

Answer
A
The structured references are modified per row.
B
The column headings are being replaced with alternative titles.
C
The data in the table need to include a totals column.
D
The formula is using a built-in function.

Explanation

In an Excel table formula, @ indicates an implicit intersection: the formula uses the value from the current row of the referenced column. That means the structured reference is adjusted to the row where the formula appears. It does not indicate alternative column titles, a totals column, or a built-in function.

AI-written and checked against the verified answer.