NEW
Font size
WorksheetsQ2 - Lesson 2 - Data in Series
Total questions: 10
Worksheet time: 6mins
It is the collection of related data.
data
data series
cell
cell address
It is an Excel feature that allows you to automatically input a series of data and can be applied by dragging the fill handle.
Autofill
Fill right
Fill down
data series
It is a small box located at the lower-right corner of the cell pointer.
Autofill
Fill right
Fill down
fill handle
Arrange the steps in creating copies of data.
1. Click the cell.
2. Drag the fill handle.
3. Position the mouse pointer over the fill handle.
4. Release the mouse.
1,2,3,4
2,3,1,4
1,3,2,4
4,1,2,3
Arrange the steps in generating codes.
1. Release the mouse.
2. Click and drag fill handle.
3. Type the first data in the series, press Ctrl+Enter.
1,2,3
2,3,1
3,1,2
3,2,1
Arrange the steps in generating codes with specific interval.
1. Highlight the cells containing the 1st and 2nd data.
2. Type the 1st and 2nd data in the series.
3. Release the mouse.
4. Drag the fill handle.
1,2,3,4
2,1,4,3
3,2,1,4
4,3,1,2
Arrange the steps in creating predefined list.
1. Release the mouse.
2. Drag the fill handle.
3. Enter one of the data on the predefined list, press Ctrl+Enter.
1,2,3
2,1,3
3,1,2
3,2,1
Arrange the steps in creating copies of a number.
1. Type the number in a cell, and press Ctrl+Enter.
2. Drag the fill handle.
3. Release the mouse.
1,2,3
2,1,3
3,1,2
3,2,1
Arrange the steps in entering a series of dates.
1. Drag the fill handle.
2. Type the date in a cell, press Ctrl+Enter.
3. Release the mouse.
1,2,3
2,1,3
3,1,2
3,2,1
Arrange the steps in creating a series of time values.
1. Drag the fill handle.
2. Release the mouse.
3. Type a time value in a cell, press Ctrl+Enter.
1,2,3
2,1,3
3,1,2
2,3,1
