April 2024
Fundamental IT Engineer Examination
Quiz 1
Quiz 2
Quiz 3
Quiz 4
Quiz 5
Quiz 6
Quiz 7
Quiz 8
Quiz 9
Quiz 10
Quiz 11
Quiz 12
Quiz 13
Quiz 14
Quiz 15
Quiz 16
Quiz 17
Quiz 18
Quiz 19
Quiz 20
(မှတ်ချက်-- Gemini ရေးပြပုံအတိုင်း ကူးထည့်ထားသည်။)Based on the image and the logic provided, the correct expression to enter in cell C3 is
d) IF(C2 < AVERAGE($C2 : $E2) , 'X' , 'O').
Here is the breakdown of why this specific formula works:
1. The Logical Condition
The goal is to compare the sales amount to the monthly average.
Condition: If `Sales < Average`, display 'X'. Otherwise, display 'O'.
In cell C3, the sales amount is in C2.
The average range for the month of July is C2:E2.
Therefore, the base logic is: `IF(C2 < AVERAGE(...), 'X', 'O')`. This immediately rules out options a and c, which swap the 'X' and 'O'.
2. Absolute vs. Relative References (The $ Sign)
Because the formula will be copied to other cells (like D3, E3, and subsequent months), we need to use the dollar sign ($) correctly to "lock" specific parts of the formula.
C2 (The Branch Sales): This should be a relative reference. When you copy the formula from C3 to D3, you want the reference to change from C2 to D2 so it evaluates Branch B's sales.
$C2 : $E2 (The Average Range): We use absolute column references ($C and $E) but keep the row reference (2) relative.
The Column: When you copy the formula horizontally to Branch B (D3), you still want the average to be calculated across all three branches (C through E). Without the $, the range would shift to D2:F2, which is incorrect.
The Row: We leave the "2" relative so that when you copy the formula down to the August evaluation (cell C5), the formula automatically updates to look at the sales in row 4 (`$C4:$E4`).
Comparison Table
| Option | Formula | Logic Correct? | Copy-Paste Friendly? |
| a | `IF($C2 < ... , 'O' , 'X')` | No (Swapped X/O) | No ($ locks it to Branch A) |
| b | `IF($C2 < ... , 'X' , 'O')` | Yes | No ($ locks it to Branch A) |
| c | `IF(C2 < ... , 'O' , 'X')` | No (Swapped X/O) | Yes |
| d | `IF(C2 < AVERAGE($C2:$E2), 'X', 'O')` | Yes | Yes |
Quiz 21
Quiz 22
Quiz 23
Quiz 24
Quiz 25
Quiz 26
Quiz 27
Quiz 28
Quiz 29
Quiz 30
Quiz 31
Quiz 32
Quiz 33
Quiz 34
Quiz 35
Quiz 36
Quiz 37
Quiz 38
Quiz 39
Quiz 40
Quiz 41
Quiz 42
Quiz 43
Quiz 44
Quiz 45
Quiz 46
Quiz 47
Quiz 48
Quiz 49
Quiz 50
Quiz 51
Quiz 52
Quiz 53
Quiz 54
Quiz 55
Quiz 56
Quiz 57
Quiz 58
Quiz 59
Quiz 60
Quiz 61
Quiz 62
Quiz 63
Quiz 64
Quiz 65
Quiz 66
Quiz 67
Quiz 68
Quiz 69
Quiz 70
Quiz 71
Quiz 72
Quiz 73
Quiz 74
Quiz 75
Quiz 76
Quiz 77
Quiz 78
Quiz 79
Quiz 80
Quiz 81
Quiz 82
Quiz 83
Quiz 84
Quiz 85
Quiz 86
Quiz 87
Quiz 88
Quiz 89
Quiz 90
Quiz 91
Quiz 92
Quiz 93
Quiz 94
Quiz 95
Quiz 96
Quiz 97
Quiz 98
Quiz 99
Quiz 100
