Question

Select the correct answer from each drop-down menu.

Answer 1

Answer#1

1. Conditional Formatting

Explanation:

we can follow these steps for conditional formatting

first of all Select those cells which needs formatting

after that  click on  Home tab then click on Conditional Formatting tab then click on New Rule button

after that a formatting rule dialog will be open just  click on Use a formula to determine which cells to format.

Under Format values where this formula is true, type the formula that  is to beedited

then finally Click on Format button

Answer#2

2. Nested IF

Explanation:

nested if is basically defined as a thing that is nested and is fully contained within something else of the same kind.