Martha works as an Office Executive for Tech Profile Inc. She uses Microsoft Excel 2010 to create
office reports. She often needs to fill names of all employees in each department of the company in
her reports. Which of the following steps should she take to ease her task?
A.
Create custom lists of employees department-wise in Excel.
Use the Fill handle to fill the cell with the names of employees.
B.
Fill different columns with names of employees department-wise, in an Excel worksheet. Save the
sheet and use it as a template.
C.
Fill different columns with names of employees department-wise, in an Excel worksheet. Save the
sheet as a template file. Use this template for creating reports.
D.
Fill different columns with names of employees department-wise, in an Excel worksheet. Copy
and paste the columns from the worksheet into a new sheet whenever required.
Explanation:
Martha should take the following steps to accomplish the task:
Create custom lists of employees department-wise in Excel.
Use the Fill handle to fill the cell with the names of employees.
Microsoft Excel 2010 provides a feature to create a custom list to fill series through Fill handle.
Answer B, C, and D are incorrect. There is no need to take these steps. By using the custom list,
Martha can easily accomplish the task.