Consider the following MS-Excel spreadsheet in which the population column represents the city's population in millions of people. Suppose the formula - IF ($B2=D$1,$A2, 0) is entered into cell D2 and then the cell D2 is copied and pasted to D2:F9. How many cells in the range D2:F9 contains 0 ?

Related MCQ's