Question

Select the correct answer from each drop-down menu.

Maria buys around 90 books of six different genres for her library and stores the purchase data in a spreadsheet. She wants to categorize the books under each genre and highlight the books under the Fiction genre. Which spreadsheet feature should she use to categorize and highlight records?
She should use the feature_____ to group the books under each genre and the feature____ to highlight the books under the Fiction genre.

For each space pick one of the following:
Subtotal
Nested IF
Conditional Formatting

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.