Solutions to the questions asked in MS Excel Session 8

1 If the total sum of sales for Nintendo for Genre-Shooter is greater than 2.5 lakhs then return "Target met" else return "Target not Met". #SPILL! Using IF and SUMPRODUCT Using IF and SUMIFS 2 Convert the belwo 4 criteria to formulas to return TRUE or FALSE. None of the 4 criteria is interconnected with others Criteria 1 Count of Nintendo is > 3 0 Criteria 2 Count of Shooter is > 5 Criteria 3 sum of total qty > 500 Criteria 4 average of total sales is >18 Lakhs Use the above TRUE/FALSE from G25:G28 in XOR and return the result. Explanation on why you got TRUE or FALSE