Introduction To Dataanalysisusingexcel Coursera Quiz Answers Github Repack Jun 2026
You have a sales table with columns: Region, Product, Units Sold, Revenue. You need to see total Revenue per Region, but only for products with Units Sold > 100. What should you do?
Creating conditional logic (e.g., IF(A1 > 100, "High", "Low") ). COUNTIF/SUMIF: Aggregating data based on specific criteria. 3. Data Visualization and Pivot Tables You have a sales table with columns: Region,