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

Question

Quizplus · Accepted Answer

Victor is using a nested function, which means he is placing one function inside another within the same formula to perform this analysis.

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