Solved

Liam Needs to Count the Cells in the Range B1:B20

Question 178

Multiple Choice

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text.Which of the following formulas should he use?

A) '=COUNT(B1:B20)
B) =COUNTA(B1:B20)
C) =SUM(B1:B20)
D) =CALCULATE(B1:B20)

Related Questions

Q57: To format a range so that all

Q173: Where calculated columns summarize data in each

Q174: When you want to know the position

Q175: ActiveX is a named set of instructions,

Q177: To edit placeholder text, such as in

Q179: Nathan wants a formula to return "Yes"

Q180: Filtering a PivotChart does not affect the

Q181: Loralie wants to protect her Excel spreadsheet

Q182: Ina wants to protect a worksheet with

Q183: A table formula can use a<u> table</u>