You are creating a worksheet in Excel 2010. You have entered data value as shown in the image given below:
You want to copy formatting of first two rows to all the rows. Which of the following steps will you
take to accomplish the task?
Each correct answer represents a complete solution. Choose two.
A.
Select cells of the two rows > Select and drag the copy handler for other rows.
B.
Select first two rows > Use the Copy Format option from the Format ribbon of the Edit tab >
Select the remaining rows > Use Ctrl+V option to paste the formatting.
C.
Select cells of the two rows > Select and drag the copy handler for other rows > Select the Fill
formatting only option in the Autofill options list.
D.
Use the Format painter to copy formatting to other rows.
Explanation:
According to the question, you are required to format all the rows as the first two rows are
formatted. In order to accomplish the task, you will have to take either of these two steps:
Use the Format painter to copy formatting to other rows.Select cells of the two rows > Select and drag the copy handler for other rows > Select the Fill
formatting only option in the Auto fill options list.Answer A is incorrect. This action will copy data of row one and two to other rows as well.
Answer B is incorrect. No such options are available in Excel 2010.
