Question

1. which boolean operator would you use if you wanted to search for \sea birds\ or \cats\?

and, +
not, -
or, |

1. how would you change the date format?

select the cells to be formatted, click on the insert tab and choose table.
select the cells to be formatted, right click and choose format cells.
select the cells to be formatted, click on the view tab and choose page layout.
select the cells to be formatted, click on the data tab and choose filter.

Explanation:

• For question 19: The Boolean operator "OR" is used when we want to search for either of the terms. For example, if we use "sea birds OR cats" in a search, it will return results that have either "sea birds" or "cats".
• For question 20: To change the date format in spreadsheet software (like Excel), we select the cells, right - click and choose "Format cells" where we can then select the date format option.

Answer:

1. OR, |
2. Select the cells to be formatted, right click and choose Format cells.