Values

10
20
30
40
50

Tasks solution
Task 1 Calculate the sum of all values. 150
Task 2 Sum the first three values. 60
Task 3 Sum values greater than 20. 120
Task 4 Sum values less than or equal to 40. 100
Scores
88
76
92
85
79

Tasks solution
Task 1 Calculate the average of all scores. 84
Task 2 Find the average score of scores greater than 80. 88.33333
Task 3 Calculate the average of the first four scores. 85.25
Task 4 Find the average of scores below 90. 82
Quantities
2
3
4
5
6

Tasks solution
Task 1 Calculate the product of all quantities. 720
Task 2 Find the product of the first three quantities. 24
Task 3 Multiply quantities greater than 3. 120
Task 4 Multiply the last two quantities. 30
Value1 Value2 solution 1 Solution 2 solution 3
50 10 40 40 40
60 20 40 40 40
70 30 40 40 40
80 40 40 40
90 50 40 40

Tasks solution 1
Task 1 Subtract Value2 from Value1 for all rows.
Task 2 Calculate the difference for the first three rows.
Task 3 Find the difference for rows where Value1 > Value2.
Task 4 Subtract Value2 from Value1 where Value1 is even.
solution 4
40
40
40
40
40
Scores task 1 task 2 task 3 task 4
55 Pass Low odd Needs Improvement
78 Pass Low even Good
45 Fail Low odd Needs Improvement
89 Pass High odd Excellent
66 Pass Low even Good

Tasks
Task 1 Return 'Pass' if Score is 50 or above, else 'Fail'.
Task 2 Return 'High' if Score is 80 or above, else 'Low'.
Task 3 Check if Scores are odd or even.
Task 4 Return 'Excellent' for scores above 85, 'Good' for 60-85, 'Needs Improvement' for below 60.
Scores task 1 task 2 task 3 task 4
90 A Excellent High Yes
75 B Good Mid Yes
60 C Average Mid No
45 D Poor Low No
30 D Poor Low No

Tasks
Task 1 Return 'A' if Score >= 85, 'B' if 70<=Score<85, 'C' if 50<=Score<70, 'D' if Score < 50.
Task 2 Classify Scores into 'Excellent', 'Good', 'Average', and 'Poor'.
Task 3 Set performance to 'High' for >=80, 'Mid' for 60-79, 'Low' below 60.
Task 4 Return 'Yes' if Score > 70 and divisible by 5, else 'No'.
Category Values task 1 task 2 task 3 task 4
A 10 25 50 75 75
B 20
A 15
C 25
B 30

Tasks
Task 1 Sum Values where Category is 'A'.
Task 2 Calculate sum of Values for Category 'B'.
Task 3 Find total for Values greater than 15.
Task 4 Sum Values for Category not equal to 'A'.
Category Type Values task 1 task 2 task 3 task 4
A X 10 30 35 10 30
B Y 20
A Y 30
C X 25
B Y 15

Tasks
Task 1 Sum Values where Category is 'A' and Type is 'Y'.
Task 2 Calculate sum of Values for Category 'B' and Type 'Y'.
Task 3 Find sum of Values for Type 'X' where Category is not 'C'.
Task 4 Sum Values for Category 'A' and Values greater than 10.
Category Scores task 1 task 2 task 3 task 4
X 85 80 85 80 78.33333
Y 90
X 75
Y 80
Z 70

Tasks
Task 1 Find average of Scores where Category is 'X'.
Task 2 Calculate the average score for Category 'Y'.
Task 3 Find average score for Categories not equal to 'X'.
Task 4 Calculate average of Scores greater than 75.
Category Type Scores task 1 task 2 task 3 task 4
A X 60 72.5 72.5 87.5 72.5
B Y 75
A X 85
C X 90
B Y 70

Tasks
Task 1 Find average of Scores for Category 'A' and Type 'X'.
Task 2 Calculate average score for Category 'B' and Type 'Y'.
Task 3 Find average score for Type 'X' where Score is above 70.
Task 4 Average of Scores for Category 'A' and scores less than 90.
Values task 1 task 2 task 3 task 4
1 4 4 2 4
2

4
5

Tasks
Task 1 Count the number of numeric values.
Task 2 Count values greater than 2.
Task 3 Count the first three values.
Task 4 Count values that are not empty.
Values task 1 task 2 task 3 task 4
Apple 3 3 3 3

Banana
Orange

Tasks
Task 1 Count the number of non-empty values.
Task 2 Count values that contain text.
Task 3 Exclude empty cells and count the rest.
Task 4 Count all cells except blank ones.
Items task 1 task 2 task 3 task 4
Apple 2 4 0 2
Banana
Orange
Apple
Grapes

Tasks
Task 1 Count the number of 'Apple' entries.
Task 2 Count entries that are not 'Banana'.
Task 3 Count unique entries.
Task 4 Count entries starting with 'A'.
Category Price task 1 task 2 task 3 task 4
Fruit 5 2 1 1 2
Fruit 3
Vegetable 4
Fruit 5
Vegetable 6

Tasks
Task 1 Count items that are 'Fruit' and price is 5.
Task 2 Count entries where Category is 'Vegetable' and price > 4.
Task 3 Count items where Category is 'Fruit' and Price < 5.
Task 4 Count entries for 'Vegetable' with Price between 4 and 6.