In MS-EXCEL, Cell B9 contains the value 3, and B10 contains the value 6. You select both the cells and drag the fill handle down to B13. The contents of the cell B11, B12, and B13 will be ________
9, 12, 15
Understanding MS-EXCEL Fill Handle with Number Series
The question describes a common task in MS-EXCEL involving the fill handle. When you select two cells containing numerical values and drag the fill handle, Excel attempts to identify a pattern or series based on the difference between those two initial values.
Analyzing the MS-EXCEL Scenario
We are given the following setup:
- Cell B9 contains the value: 3
- Cell B10 contains the value: 6
These two cells (B9 and B10) are selected, and the fill handle is dragged down to cell B13. Excel will look at the relationship between the values in B9 and B10 to determine how to extend the series.
Calculating the Pattern in the MS-EXCEL Series
To find the pattern, Excel calculates the difference between the second selected cell (B10) and the first selected cell (B9).
Difference = Value in B10 - Value in B9
Difference = \(6 - 3 = 3\)
This difference of 3 indicates that Excel will create an arithmetic series, adding 3 to the previous value for each subsequent cell filled.
Determining Cell Contents Using MS-EXCEL Fill Handle
Now, let's determine the contents of cells B11, B12, and B13 by extending this series:
- Cell B11: This cell comes after B10. We add the difference (3) to the value in B10.
Value in B11 = Value in B10 + Difference
Value in B11 = \(6 + 3 = 9\) - Cell B12: This cell comes after B11. We add the difference (3) to the value in B11.
Value in B12 = Value in B11 + Difference
Value in B12 = \(9 + 3 = 12\) - Cell B13: This cell comes after B12. We add the difference (3) to the value in B12.
Value in B13 = Value in B12 + Difference
Value in B13 = \(12 + 3 = 15\)
Summary of MS-EXCEL Cell Values
After dragging the fill handle from B10 down to B13, the cells will contain the following values:
| Cell | Initial Value / Calculated Value |
|---|---|
| B9 | 3 |
| B10 | 6 |
| B11 | 9 |
| B12 | 12 |
| B13 | 15 |
Therefore, the contents of the cell B11, B12, and B13 will be 9, 12, and 15 respectively.
Revision Table: MS-EXCEL Fill Handle Concepts
| Feature | Description | Behavior with Numbers (2 cells selected) |
|---|---|---|
| Fill Handle | The small square at the bottom-right corner of a selected cell or range. | Recognizes arithmetic progression, extends series based on the difference between the two selected values. |
| AutoFill | The functionality triggered by dragging the fill handle. | Automatically fills cells with a series based on the detected pattern. |
| Arithmetic Series | A sequence where the difference between consecutive terms is constant. | This is the default pattern Excel identifies when two number cells are used with the fill handle. |
Additional Information: Exploring MS-EXCEL AutoFill
The MS-EXCEL fill handle is a powerful tool for automating data entry and creating series. Beyond arithmetic series from numbers, it can also:
- Extend simple lists (e.g., Day 1, Day 2, Day 3).
- Fill days of the week (Monday, Tuesday...).
- Fill months of the year (January, February...).
- Copy formulas while adjusting cell references (relative references).
- Copy formatting only or values only using the Auto Fill Options button that appears after dragging.
- Create custom lists that can be filled automatically.
Understanding how Excel interprets the initial selection is key to using the fill handle effectively. Two number cells define an arithmetic step, while one number cell or specific text patterns trigger different behaviors.
Important Questions from Types of Softwares
- Learning Management Systems (LMS) is a software application used for
Suppose that the class grade for a six-week period is based on three tests (T1, T2, T3), each of which counts for 15%, four quizzes (Q1, Q2, Q3, Q4), each of which counts for 10%. and a homework note book (HW), which counts for 15%. The grades are recorded in a spreadsheet similar to the one below.
A B C D E F G H I J 1 Name T1 T2 T3 Q1 Q2 Q3 Q4 HW AVG 2 Jatin 87 92 80 76 79 87 74 90 3 Amit 91 85 77 78 88 96 90 92 4 Anil 65 72 70 80 81 74 77 80 5 Anita 96 88 91 76 91 100 74 98 Which of the following formulae would NOT be a correct calculation of the six-week weighted average for Jatin?
Consider the following spreadsheet:
A B C 1 4 3 2 5 2 3 7 4 8 9 5 9 6 If the formula = $A3 + B2 in cell C4 is copied to cell C5, then what is the value in cell C5?
Given below are two statements:
Statement I: Shareware is a software that the users can try out for a trial period only. before being charged.
Statement II: Freeware is a software that the users can download free of charge. but they cannot modify the source code in any way.
In the light of the above statements. choose the correct answer from the options given below
Consider the following MS-Excel spreadsheet in which the population column represents the city's population in millions of people :
A B C D E F 1. City State Population Haryana MP UP 2. Patiala Panjab 8.34 3. Sonipat Haryana 3.86 4. Noida UP 2.71 5. Indore MP 2.16 6. Mandi HP 1.49 7. Sagar MP 1.38 8. Panipat Haryana 1.39 9. Gwalior MP 1.24 Suppose the formula - IF($B2 = D$1, $A2, 0) is entered into cell D2 and then the cell D2 is copied and pasted to D2 : F9. How many cells in the range D2 : F9 contains 0?
