Question

What will happen if you enter XYZ1 in a cell and drag the fill handle down?
O It will fill XYZ1 in all the cells that are dragged through.
O It will fill the series with XYZ2, XYZ3, XYZ4 and so on, respectively.
O It will fill the series with XYZ2. ABC3, DEF4 and
se
on, respectively.
O
None of the above.​

Answer 1

Answer:

In Microsoft Excel 2016, which of the following options can be locked in a worksheet?

i) Ranges

ii) Formulas

a. Only option i).

b. Only option ii).

c. Both options i) and ii).

d. Neither option i) nor ii).

Answer: a. Only option i).

Question: 2

This question is based upon the figure shown below.