Function IF, VLOOKUP, PIVOT TABLE, CHART, WEKA, Cluster Analysis, Data Mining, Microsoft Excel

Data Handling & Business
Intelligence

Definitions –
a) Function IF
In Excel, IF function is considered as one of the useful one, which allows users to make
logical comparisons among set of given value on the basis of expectations (Schmidt, Church and
Riley, 2020). This functions when a condition is given, checks whether it met or not. In case of
condition is met, then it returns true value otherwise another value in false situation. The syntax
for IF function in MS-Excel used as – IF(Condition, “True value”, “False value”.
For example – To underscore a number, whether it lies above a limit or below it as
“High” or “Low”, then IF Function can be used in following way –
As per this example, in row B, input the formula of IF as - =IF (A2>500, “High”, “Low”)
then in case, if value of A2 lies above given condition, then respective function gives value as
“High” otherwise “Low”. Therefore, IF function in Excel refers to a built-in function which is
categorized in terms of Logical Function. So, this function can be utilised as a worksheet
function, as part of a formula in worksheet’s cell.
b) Function VLOOKUP
The VLOOKUP function in excel, performs a vertical lookup through searching for a
value within first column of a table, then return the value in same row in terms of index_number
position (Anderson and et. al., 2020). It is a built-in function which is categorized in excel, as a
Lookup or Reference Function. In terms of worksheet function, VLOOKUP can be entered as a
formula in desired cell. The syntax for function VLOOKUP in MS-Excel used as – VLOOKUP
(value, table, index_number, [approximate_match]. Here, first parameter i.e. value indicates the
value to be searched for in Table’s first column. While, table depicts two or more columns of
1