Asynchronous Activity 25-08-2025
Sunay Antonio Kakollu
2540887
1) Explain how logical functions in Excel (AND, OR, XOR, NOT) can be applied for
eligibility checks, data filtering, data validation, and comparisons, with suitable
examples.
Ans) AND Function returns TRUE if all conditions given are TRUE, otherwise FALSE.
It can be used for eligibility checks
Can be used to check if a student qualifies a scholarship
Formula used: AND(B2>70, C2>70) Where column B and C are Math marks and English
Marks respectively. If only both the conditions are met only then will the student be eligible
for scholarship. Hence, it can be used for eligibility checks
OR Function returns TRUE if at least one condition is TRUE, otherwise FALSE.
It can be used for data filtering
Can be used to check if some students need help and helps in filtering them out
XOR Function returns TRUE if only one condition is TRUE, but FALSE if both are TRUE or
both FALSE.
Can be used to check if the student has passed only one subject, none or both
NOT Function returns the opposite of a logical value
Can be used for validation as shown above, as if form is submitted then it will return FALSE
2) Explain how conditional functions in Excel (IF, IFERROR, IFS, SWITCH) can be applied
in grading, categorizing, error handling, mapping codes to labels, and decision-making, with
suitable examples.
Ans) The IF Function returns one value if the condition is TRUE, another if FALSE
The best example to be used it for grading as shown below
The IFERROR Function returns a custom result if a formula causes an error, otherwise shows
the result of the formula.
IFS Function Checks multiple conditions and returns a value for the first TRUE condition.
Again, it can be used for grading students with raw marks
IFS(Condition, value 1, condition 2, value 2)
SWITCH Function Compares a value against a list and returns the corresponding result
It is used to switch convert one text or value to another for example “Fin” can be converted to
“Finance” easily using this function
Definition: Missing values are blank or NA entries in data which can break or distort graphs.
1)Ignore Missing Data - Chart skips blank cells (shows gaps).
2)Show as Zero - Convert missing cells into 0 for plotting.
3)Fill Trend - Estimate missing value using average of neighbours.