Question

State the specific action(s) or step(s) in Excel that will produce a list/display of those countries with 800 or more medals in total?

Answer 1

Answer:

hiffv vvvv vgv vvggggggthhffghh

Answer 2

1.Highlight the row F by clicking and selecting on F

2.Then go to toolbar at top under DATA click filter

3.There will an arrow next to F

4. click the drop down on the arrow and sort.

Explanation:

The Excel IF Statement tests a given condition and returns one value for a TRUE result.

Another value for a FALSE result.

The syntax is :

=IF(logical_test, value_if_true, value_if_false)

Logical_test (required argument) – This is the condition to test and  evaluate as either TRUE or FALSE.

   Value_if_true (optional argument) – The value  will be returned if the logical_test evaluates to TRUE.

   Value_if_false (optional argument) – The value will be returned if the logical_test evaluates to FALSE.