_______________ is a function that counts blank cells within a range of cells.

Get ready for the GMetrix Data Modeling Test. Enhance your skills with flashcards and multiple choice questions, complete with hints and explanations. Prepare effectively for success!

Multiple Choice

_______________ is a function that counts blank cells within a range of cells.

Explanation:
COUNTBLANK is the function used to count how many cells in a range are empty. It examines the specified range and returns the number of cells that contain nothing at all. A nuance to keep in mind: a cell that contains a formula that returns an empty string "" isn’t considered blank by COUNTBLANK, so it won’t be counted. If you need to count cells that appear empty (including those with formulas resulting in ""), you’d use a different approach like COUNTIF(range,""). The other options listed aren’t actual Excel functions for counting blank cells.

COUNTBLANK is the function used to count how many cells in a range are empty. It examines the specified range and returns the number of cells that contain nothing at all. A nuance to keep in mind: a cell that contains a formula that returns an empty string "" isn’t considered blank by COUNTBLANK, so it won’t be counted. If you need to count cells that appear empty (including those with formulas resulting in ""), you’d use a different approach like COUNTIF(range,""). The other options listed aren’t actual Excel functions for counting blank cells.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy