1. Open Excel20 10, enter data in the worksheet and format it, as shown.

2. Enter the formula =B5 in the cell E2 where two sets of replacement values intersect.

3. Select the cell range E2:I7 containing formulas and variation parameters, then select the Data tab in the menu and click the Analog Operation Table command.

4. Open the dialog box of the simulation operation table, position the cursor in the cell reference editing of the input lead-in line, and select the cell B4 to be changed by the line change parameter.

5. Position the cursor in the cell reference edit box of the input import column, and select the cell B3 where the parameter to be replaced by the column change parameter is located.

6. Click OK, and the result is shown in the figure.