Question

when cell a4 containing the formula =$b$5/$c$6 is copied to cell f6, the formula in
=$b$5/$c$6
=$g$5:$h$6
=$g$7/$h$8
=b5/c6
question 31
if you want to see how many cells in a specified range contain numbers, you would use th
sum
subtotal
count
average

Explanation:

• SUM: Adds up all the numbers in a range.
• SUBTOTAL: Calculates a subtotal for a range, considering hidden rows (if applicable).
• COUNT: Counts the number of cells in a range that contain numbers.
• AVERAGE: Calculates the average of the numbers in a range.

Since the task is to count the number of cells with numbers, the COUNT function is appropriate.

Answer:

COUNT