Spreadsheet tools offer powerful logical, conditional, and financial functions that help marketers analyze data effectively. How do these functions support decision-making in marketing?Discuss how logical functions like IF, AND, OR, and Nested IFs can help marketers filter and categorize data.Financial functions like NPV, FV, PV and PMT are used in business planning. Can you think of a scenario where they would be useful in a marketing campaign?Charts play a crucial role in visualizing data. What type of chart (e.g., bar chart, line chart, pie chart) do you find most effective for marketing data, and why?