Question

describe the following formula in table

Answer 1

Answer:

Copy the sample data in the table above, including the column headings, and paste it into cell A1 of a new Excel worksheet.

To create the table, select any cell within the data range, and press Ctrl+T.

Make sure the My table has headers box is checked, and click OK.

In cell E2, type an equal sign (=), and click cell C2.

In the formula bar, the structured reference [@[Sales Amount]] appears after the equal sign.

1. Type an asterisk (*) directly after the closing bracket, and click cell D2.

In the formula bar, the structured reference [@[% Commission]] appears after the asterisk.

Press Enter.

Excel automatically creates a calculated column and copies the formula down the entire column for you, adjusting it for each row.

Explanation:

make me brainliest