Question

You type a complex formula in cell A20. You would like to make the same calculation in cells B20 through H20. To be efficient, you should _____.



a. type the formula in B20 through H20


d. use the COUNT function


c. use autofill


d. use the ABS function

Answer 1

Answer:

Use autofill

Explanation:

In excel "autofill" is used to fill data in cells, which follows the pattern or logic applied in other cells. To apply same calculation of A20 in B20 to H20, we use autofill technique. Instead of copy pasting, or manually entering the complex formula this method is more suitable.