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

question 17

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

---

Definitions:

Delete

A command or action that removes data, files, or elements from an application or system.

Append Query

A query in database management that adds the results of a query to an existing table, rather than displaying them.

Query Design View

A feature within database management software that offers a graphical representation for creating or adjusting queries, facilitating easier manipulation of data retrieval parameters.

Excel Workbook

A file in Microsoft Excel that contains one or more worksheets to organize, calculate, analyze, and visualize data.