Here the formula that was applied is =B1:E1*B2: E2 and the range in which the result was shown is B3: E3. To multiply cells or ranges in excel we can use the PRODUCT function instead of using multiplication symbol. The product function is the fastest way of multiplication between ranges. To multiply values in cells A1 and B1 use this formula:
For More Information Please Refer: