Victor, a Population Analyst, Has the Following Data on an Excel

Multiple Choice

Victor, a population analyst, has the following data on an Excel sheet: month-wise population of a city in 2014 in column A and month-wise population of the same city in 2015 in columnB) He wants to calculate the change in population in 2015 compared to 2014 and check if the change is more or less than 2 million. Victor uses multiple functions, including the IF function, within a single formula for this analysis. In this scenario, Victor uses a _____.

A) loop function
B) nested function
C) Web function
D) Compatibility function