D E F 1 A B H The webmaster is planning for the next quarter. Table 4 has the estimate of the visitors, and table 5 has the estimated conversion rates. In table 6, he would like to compute the estimated number of visitors who will purchase. The mathematical formula to compute the number of visitors is. Estimated paying visitors = "Estimated visitors"* "conversion rate" (a) Enter a Formula in Cell C50 to compute the estimated number of paying visitors using cell 040 and C46. Copy the formula written in cell C50 to range C50:652. (b) Write formula in cell C54 to compute the total number of estimated paying visitors across the months. Copy the formula in cell C54 to the range D54:54. (c) Write formula in cell C55 to compute the average number of estimated paying visitors across the months. Copy the formula in cell 055 to the range D55:655. 36 37 38 Table 4: Estimated visitors from various sources Display Email Organic Search Paid Search Social 39 40 Sources () Months (1) Apr, 2020 May, 2020 June, 2020 1462 14851 1525 1655 1688 41 4480 4580 4650 1700 1732 1771 799 820 840 42 1700 43 44 Display 45 46 Table 5: Estimated conversion rate of various sources Email Organic Search Paid Search Social 10% 5% 6% 3% 5% 47 48 Table 6: Estimated No. of paying visitors Display Email Organic Search Paid Search Social 49 50 Sources (>) Months (1) Apr, 2020 May, 2020 June, 2020 51 52 53 54 Total Average 55 56