We apply the formula shown in the succeeding image. To find this character, we use the escape character tilde (~). Asterisk denotes multiple characters, a question mark denotes a single character, and a tilde denotes the identification of a wild card character. The asterisk (*) is a wildcard character Wildcard Character In Excel, wildcards are the three special characters asterisk, question mark, and tilde. Working on example #3, we want to sum the sales of the products containing the asterisk. It calculates the sum of the “laptop,” the “desktop,” and the “laptop adapter.” #4–Wildcard Character The output appears as shown in the succeeding image. We apply the formula shown in the following image. We want to sum the sales of the products which contain the word “top.” It is determined as the ratio of Generated Profit Amount to the Generated Revenue Amount. The asterisk (*) indicates the items having high profit margins Profit Margins Profit Margin is a metric that the management, financial analysts, & investors use to measure the profitability of a business relative to its sales. The following table shows the product-wise sales of an organization. If “tablet” is selected, the tablet sales amount appears in cell G5. The value in cell F5 is selected from the drop-down list. With every change in the value of cell F5, the “total sales amount” updates automatically. Press the “Enter” key and the output appears (same as “step 2” of “example #1”).