Let's colour cells (A1:E1) yellow, and (A2:E2) - green and enter random numbers ranging from 1 to 10 in them. In cell A3 let's display information the average (arithmetic mean) of which cells is greater. Let's do the task in 3 stages.

• Stage I – let's use the auxiliary cells F1 and F2 and calculate in them the arithmetic mean of the yellow and green cells using the AVERAGE functionfunctionfunction. Using the values of these cells, let's calculate in cell A3, with the use of the IF function which arithmetic mean is greater.

• Stage II – based on the formulas in cells F1, F2, A3, let's do the same task in cell B3 by nesting the IF functionIF functionIF function without using the auxiliary cells F1 and F2.

• Stage III – let's develop the so that it operates correctly also when the arithmetic means are equal.

In the documentation of the programme find the information on how many levels of functions you can nest in a formula.

If we want to test for N different conditions with the use the IF functionIF functionIF function, how many IF functions must we use?

In a new column, grade 5 students whose test scores are: 14, 43, 24,18 and 9, using the following scoring:

• very good – 50‑41 points,

• good – 40‑31 points,

• satisfactory – 30‑21 points,

• pass – 20‑11 points,

• fail – 10‑1 points.

How many conditions should be tested?
How many IF functions will you use?
Is the order of testing conditions relevant?

Before doing the task draw the operational chart of the nested IF functionIF functionIF function.

Enter the first names of 5 people in column A, and their surnames – in column B. Combine the first names and the surnames in column C, and in column D create the initials of the people in the form F.S.

Describe the operations in English.

On the Internet find the information on the tax scale applying in Poland for 2017. Based on the information, calculate the tax for 3 citizens: Kowalski, Nowak and Kot, who earned respectively: 1500 zł, 27 000 zł, 125 000 zł in 2017.