Sam wants to count the number of cells between b1 and b20 that contain numbers in them. The formula that should be used is COUNT(B1:B20). The correct option is a.
The grid-like boxes in an Excel spreadsheet like this one are called cells. On a worksheet, each cell is identifiable by its reference, the column letter, and the row number that crosses the cell's position.
This cell is cell D5 because it is in column D and row 5. In a cell reference, the column is always referenced first. Click the column header only. The number of rows will be displayed in the status bar in the Excel window's lower right corner.
Therefore, the correct option is a, =COUNT(B1:B20).
To learn more about cells in Excel, refer to the link:
https://brainly.com/question/1380185
#SPJ1
The question is incomplete. Your most probably complete question is given below:
=COUNT(B1:B20)
=ROUND(A5,2)
=DATE(1998,1,12)
=DATEVALUE("01/01/2017")
