Solved

A Worksheet Has the Following Data in It: Cell Range

Question 5

True/False

A worksheet has the following data in it: Cell range A2 to A10 in column A lists the years from 2010 to 2019. Cell range B2 to B10 in column B lists the types of food items sold during each year: Tomatoes, Oranges, Pears, Pineapples, Potatoes, and Onions. Cell range C2 to C10 in column C lists the sale of each item in each year. If we insert the formula =COUNTIFS("=Onions","B2:B10") in cell A11, it will give us the count of the number of times "Onions" has been listed in the worksheet.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions