To apply the Excel multiplication formula, follow these steps:
1. First open Excel, here casually entered two sets of data. As pictured. Now you want to compute the product of these two sets of data.
2. To calculate the data selected in the following figure, first calculate the product of the first set of data. Select this set of data and click on the function button above. As shown in the figure.
3. In the pop-up menu does not need to use the product formula, click on the other function this option.
4. In the page where the function is inserted, you cannot directly find the product function that you want to use. In the Search function blank box, enter the product two words, and then click Go to the button.
5. At this point, in the list of selection functions, a function of the product appears, at the bottom of the list is a description of the product of all the parameters. Select the Click OK button to exit the Insert Function page.
6. Start to compute the product of the first set of data. Use the mouse to select the set of data just selected, then the set of data will be surrounded by dotted lines, and then in the function parameter box will display this set of data, and at the bottom there will be a calculation results, such as figure.