Question

If you would like the same label to appear in the first ten cells of column a, you should _____.

Answer 1

Answer:

Copy and paste by using special function (ALT+E+S+V)

Explanation:

It is easy to work on excel as it allows to increase efficiency by easing the completion of repetitive work.

In this case when same label is to be copied to ten different cell of a column, then one can do the following -

a) put the cursor on the label that is to be copied

b) Press ctrl + C to copy the label

c) Now select the columns in which the labels are to be copied

d) Press ALT + E+ S+V and select format if only format is to be pasted.

Answer 2

If you're talking about excel then you would select the cell with the label you want and click "Format Painter". Then, you click and drag it down the first 10 and it will automatically apply that same label to all the cells.