You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2010 to create different
reports for your company. Drag and drop the appropriate methods for efficient data entry in front of their descriptions.
Explanation:
Excel provides multiple methods for fast data entry into a worksheet. These data entry
techniques help users to quickly enter data wherever required. The following methods help users in
speeding-up their data entry work:
AutoFill: The AutoFill feature recognizes the series a user wants to enter and fills the series when the
fill handle is dragged.
FillSeries: In FillSeries method, a user enters the first two values in a series and then by selecting
both the cells and dragging the selected cells through the fill handle, extends the series.
AutoComplete: The AutoComplete feature provides users a facility to enter few words in a cell. If this
entry matches with any of the entries done before in other cells, it suggests users for the same. The
user can press the Enter key to get the same entry in the cell. Pick from Drop-down List: The Pick
from Drop-down List option displays the unique entries from the column of a cell. A user can choose
an entry from the list to quickly fill the entry.Ctrl + Enter: Ctrl + Enter key combination is used to quickly fill a range of cells with the same entry.
For this, select a range of cells to contain the same data, type the data in the active cell, and press
Ctrl + Enter keys.