Microsoft Office Tutorials and References
In Depth Information
Entering and revising data
In this exercise, you’ll enter data by using multiple methods and control how Excel formats
an extended data series.
SET UP You need the Series workbook located in the Chapter02 practice file folder to
complete this exercise. Start Excel, and open the workbook. Then follow the steps.
On the Monthly worksheet, select cell B3 , and then drag the ill handle down
through B7 to repeat the value Fabrikam in cells B4:B7 .
Select cell C3 , and while pressing the Ctrl key, drag the ill handle down through C7
to repeat the value January in cells C4:C7 .
Select cell B8 , and then enter the letter F , which causes Excel to display the characters
abrikam highlighted in gray.
Press Tab to accept the value Fabrikam for the cell.
In cell C8 , enter February .
Right-click cell D8 , and then click Pick From Drop-down List to display a list of values
in column D .