Question

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?

Answer 1

Answer:

Formula Auto-Complete

Explanation:

To minimize typing and syntax errors, you can create and edit formulas with Formula Auto-Complete.

After you type an = (equal sign) and begin typing to start a formula, Excel displays a dynamic drop-down list of valid functions, arguments, defined names, table names, special item specifiers—including [ (open bracket),, (comma), : (colon)—and text string that match the letters you type. An argument is the cell references or values in a formula that contribute to the result. Each function uses function-specific arguments, which may include numeric values, text values, cell references, ranges of cells, and so on