question 8 of 10 david needs to create a new spreadsheet that will help him determine the payroll deductions…

question 8 of 10 david needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. which function would he use when he wants the spreadsheet to decide a deduction based on making more than $10,000, but less than $20,000? a. lookup table b. cell protection c. invoice d. nested if statement

question 8 of 10 david needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. which function would he use when he wants the spreadsheet to decide a deduction based on making more than $10,000, but less than $20,000? a. lookup table b. cell protection c. invoice d. nested if statement

Answer

Brief Explanations:

A nested IF statement can be used to set conditions for payroll deductions based on salary ranges. A lookup table is for finding values, cell protection is for security, and an invoice is for billing, none of which suit this conditional - based deduction task.

Answer:

D. Nested IF statement