Answer :
The output is attached below
Explanation:
The following formula needs to be entered into cell N5:
=IF($M5>=4,"Lead","Associate")
Answer:
performs calculations
Explanation:
The SUBTOTAL function in Excel allows users to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX, etc. Thus, the SUBTOTAL function in Excel helps in analyzing the data provided.