Brett assigns each client a rating of A$,$ B$,$ or C depending on the number of days an Involce Is overdue. Display this information using a nested IF function as follows:a$.$ In cell $16,$ insert a formula using an IF function to test whether the days overdue $($cell G$6)$ are less than $1$ and displays a rating of $"$A$"$ If the condition Is true.b$.$ The next condition uses another IF function to test whether the days overdue $($cellG$6)$ are less than $30$ and displays a rating of $"$B$"$ If the condition Is true.c$.$d$.$Display a rating of $"$C$"$ If the conditions are false.Use the Fill Handle to fill the range $17$:$115$ with the formula in cell $16,$ filling the