Excel Mastery Certification Portal

Look at Sheet "Day 2 - Cleanup & VLOOKUP". What is the VLOOKUP calculated Total Amount in cell G15 for the first Order ID (TX1001)? (Round to the nearest integer)

First, highlight the transaction table and perform deduplication (Remove Duplicates). Correct the trailing space traps in the Catalog table Product IDs. What is the SUM of all Total Amounts in cell G25 (the cell directly below your final cleaned table)? (Round to nearest integer)

Look at Sheet "Day 3 - Logic Gates". What is the Commission Earned by the first agent (cell G13)? Formula: Sales Amount * Commission Rate. Rule: Use IF and AND to grant the bonus commission rate if qualified. (Round to nearest integer)

What is the total sum of commissions in cell G21? (Round to nearest integer)

How many total agents qualified for the higher bonus commission rate (e.g. showing 8%/10%/12% instead of the default lower rate)?

Look at Sheet "Day 4 - COUNTIFS". In the Summary Grid on the right, write a COUNTIFS formula to calculate the count for Metric 1 (cell J13). What is the result?

What is the COUNTIFS calculated value for Metric 2 (cell J14)?

What is the COUNTIFS calculated value for Metric 3 (cell J15)?

Look at Sheet "Day 5 - What-If". Run Goal Seek on Cell C18 (Net Profit) to set it to your version's target profit, by changing Cell C15 (Units Sold). What is the calculated value in cell C15? (Round to 2 decimal places)