Assignments
Auto Filling In MSExcel
Assignment 1: Filling Numbers in Sequence
Goal: Use Autofill to create a sequence of numbers in
a column.
Steps
- Start
the Sequence:
- Click
on cell A2.
- Type
1 and press Enter.
- Select
the Starting Cell:
- Click
on cell A2 again to select it.
- Use
Autofill to Extend the Sequence:
- Move
your mouse to the bottom-right corner of cell A2 until you see the
small plus sign (+) (fill handle).
- Click
and hold the fill handle, then drag down to cell A10.
- Release:
- Let
go of the mouse button.
Result:
- Cells
A2 to A11 now contain the numbers 1, 2, 3, ... 10 in sequence.
Assignment 2: Creating a Series of Days
Goal: Use Autofill to list the days of the week in a
column.
Steps
- Enter
the First Day:
- Click
on cell B2 and type Monday.
- Press
Enter.
- Select
and Extend the Series:
- Click
on cell B2 again to select it.
- Hover
over the bottom-right corner until the fill handle appears.
- Drag
the fill handle down to cell B8.
- Release:
- Release
the mouse button.
Result:
- Cells
B2 to B8 now display the days of the week: Monday, Tuesday,
Wednesday, ... Sunday.
Assignment 3: Multiplying by a Fixed Number
Goal: Calculate a total cost by multiplying
quantities by a fixed price using Autofill.
Example Data:
|
A |
B |
C |
|
Item |
Quantity |
Total Cost |
|
Item 1 |
5 |
|
|
Item 2 |
10 |
|
|
Item 3 |
8 |
|
|
Item 4 |
7 |
Steps
- Enter
the Formula:
- In
cell C2, type =B2 * 2 and press Enter. This formula
calculates the total cost for Item 1 by multiplying its quantity by 2.
- Use
Autofill to Apply the Formula:
- Click
on cell C2 again.
- Drag
the fill handle down to cell C5.
Result:
- Cells
C2 to C5 now display 10, 20, 16, 14, representing the total cost
for each item.
Assignment 4: Repeating Text with Autofill
Goal: Use Autofill to repeat a name across multiple
cells.
Steps
- Enter
the Text:
- Click
on cell D2 and type John.
- Press
Enter.
- Use
Autofill to Repeat the Text:
- Select
cell D2 again.
- Drag
the fill handle down to cell D6.
Result:
- Cells
D2 to D6 now all display John.
Assignment 5: Creating a Pattern of Odd Numbers
Goal: Use Autofill to generate a series of odd
numbers.
Steps
- Enter
the First Two Odd Numbers:
- In
cell A2, type 1.
- In
cell A3, type 3.
- Select
both cells A2 and A3.
- Extend
the Series:
- With
both cells A2 and A3 selected, drag the fill handle down to cell
A10.
Result:
- Cells
E2 to E10 display odd numbers: 1, 3, 5, 7, 9, 11, 13, 15, 17.
Assignment 6: Fill Dates by Month
Goal: Create a series of months using Autofill.
Steps
- Enter
the Starting Month:
- Click
on cell A2 and type January.
- Press
Enter.
- Use
Autofill to Continue the Month Series:
- Click
on cell A2 again.
- Drag
the fill handle down to cell A12.
Result:
- Cells
A2 to A12 now display each month from January to December.
Assignment 7: Copying Formulas Across Rows
Goal: Use Autofill to calculate double the values in
a row.
Example Data:
|
A |
B |
C |
D |
E |
|
Qty |
5 |
10 |
15 |
20 |
|
Double |
Steps
- Enter
Formula to Double the Value:
- In
cell B2, type =A2 * 2 and press Enter. This formula doubles
the value in A2.
- Use
Autofill Across the Row:
- Select
cell B2.
- Drag
the fill handle to the right until cell E2.
Result:
- Cells
B2 to E2 display 10, 20, 30, 40, each cell showing the value
doubled from the corresponding cell in row 1.
Assignment 8: Filling Percentages
Goal: Use Autofill to create a sequence of
percentages.
Steps
- Type
the Starting Percentage:
- Click
on cell G2 and type 10%.
- Press
Enter.
- Extend
the Percentage Series:
- Select
cell G2.
- Drag
the fill handle down to cell G6.
Result:
- Cells
G2 to G6 now display 10%, 20%, 30%, 40%, and 50%.
Example 1: Creating a Multiplication Table with Autofill
Goal: Use Autofill to generate a 10x10 multiplication
table.
Steps
- Set
Up Row and Column Headers:
- In
cell A2, type 1.
- Use
Autofill to drag down from A2 to A11 to fill numbers 1 through 10.
- In
cell B1, type 1, and drag the fill handle to the right from B1
to K1 to fill numbers 1 through 10.
- Create
the Multiplication Formula:
- In
cell B2, type the formula =A2*B$1 and press Enter. This
formula multiplies the row header by the column header.
- Autofill
the Formula Across the Table:
- Select
cell B2 and drag the fill handle across to cell K2. This
fills the entire row for 1 x 1 through 1 x 10.
- Then
select cells B2 to K2, and drag the fill handle down to row 11
(B11
).
Result:
- You
now have a complete multiplication table from 1x1 to 10x10.
Example 2: Filling a Date Series for Every Monday
Goal: Autofill to create a series that only includes
Mondays.
Steps
- Enter
the Starting Date:
- In
cell A2, type the date of a Monday, such as 10/07/2024 (October 7,
2024).
- Press
Enter.
- Use
Autofill to Create Weekly Intervals:
- Select
cell A2.
- Drag
the fill handle down to cell A10.
- A
small Auto Fill Options icon will appear. Click on it, and select Fill
Weekdays.
Result:
- Cells
A2 to A10 will display dates of consecutive Mondays.
Example 3: Autofilling a Custom List (Quarterly Periods)
Goal: Use Autofill to create a list of quarterly
periods (e.g., Q1 2024, Q2 2024, etc.)
Steps
- Enter
the First Quarter:
- In
cell B2, type Q1 2024.
- Press
Enter.
- Use
Autofill to Continue the Series:
- Select
cell B2.
- Drag
the fill handle down to cell B10.
- Excel
recognizes the pattern and fills in Q2 2024, Q3 2024, Q4 2024, and
continues into Q1 2025, etc.
Result:
- Cells
B2 to B10 display Q1 2024, Q2 2024, Q3 2024, Q4 2024, Q1 2025, and
so on.
Example 4: Filling Formulas with Absolute References
Goal: Calculate the sales tax (e.g., 10%) on each
product's price using an absolute reference for the tax rate.
Example Data:
|
A |
B |
C |
|
Product |
Price |
Tax (10%) |
|
Product 1 |
50 |
|
|
Product 2 |
80 |
|
|
Product 3 |
100 |
|
|
Product 4 |
120 |
Steps
- Enter
the Tax Rate in a Cell:
- In
cell E1, type 0.10 to represent 10%.
- Enter
the Formula for Tax Calculation:
- In
cell C2, type =B2*$E$1 and press Enter.
- This
formula uses an absolute reference ($E$1) for the tax rate, ensuring it
doesn’t change as we Autofill.
- Use
Autofill to Apply the Formula:
- Select
cell C2.
- Drag
the fill handle down to cell C5.
Result:
- Cells
C2 to C5 will calculate the 10% tax for each product (5, 8, 10, 12).
Example 5: Creating a Series of Time Intervals (Every 15
Minutes)
Goal: Use Autofill to create a series of time
intervals, with each cell 15 minutes apart.
Steps
- Enter
the Starting Time:
- In
cell D2, type 08:00 AM.
- Press
Enter.
- Add
the Next Time Interval Manually:
- In
cell D3, type 08:15 AM.
- Select
Both Cells to Establish the Pattern:
- Select
cells D2 and D3.
- Drag
the fill handle down to D10.
Result:
- Cells
D2 to D10 will display times incremented by 15 minutes: 08:00 AM, 08:15
AM, 08:30 AM, etc.
Example 6: Filling a Series with Linear Growth (Add 5
Each Time)
Goal: Use Autofill to create a series that increases
by a specific amount (e.g., adding 5).
Steps
- Enter
the First Two Values to Set the Pattern:
- In
cell E2, type 5.
- In
cell E3, type 10.
- Select
both cells E2 and E3.
- Use
Autofill to Continue the Series:
- Drag
the fill handle down to E10.
Result:
- Cells
E2 to E10 display numbers increasing by 5: 5, 10, 15, 20, 25, and
so on.
Example 7: Using Autofill for Text with a Pattern
(Customer 1, Customer 2…)
Goal: Use Autofill to create a list with text that
has a sequential number (e.g., Customer 1, Customer 2).
Steps
- Enter
the First Item:
- In
cell F2, type Customer 1.
- Press
Enter.
- Use
Autofill to Extend the Text Series:
- Select
cell F2.
- Drag
the fill handle down to F10.
Result:
- Cells
F2 to F10 will contain Customer 1, Customer 2, Customer 3, and so
on.
Example 8: Autofill Dates by Month and Year
Goal: Create a series of dates that increments by one
month.
Steps
- Enter
the Starting Date:
- In
cell G2, type 01/01/2024 (January 1, 2024).
- Press
Enter.
- Extend
the Date Series by Month:
- Select
cell G2.
- Drag
the fill handle down to G12.
- Click
the Auto Fill Options icon that appears, and select Fill Months.
Result:
- Cells
G2 to G12 will display the first day of each month from January 1,
2024 to December 1, 2024.
These examples provide varied Autofill applications to help
beginners practice both numerical and text patterns, date intervals, and
formulas in Excel. The assignments give a broad sense of how Autofill can
simplify repetitive tasks while ensuring accuracy in Excel spreadsheets.
