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 ________

This question was previously asked in
UGC NET Paper 1: Held on 28th Feb 2023 Shift 2
View all UGC NET Papers >
  1. 3, 6, 3
  2. 7, 8, 9
  3. 9, 12, 15
  4. 6, 6, 6

Answer (Detailed Solution Below)

Option 3 : 9, 12, 15
Free
UGC NET Paper 1: Held on 21st August 2024 Shift 1
10.8 K Users
50 Questions 100 Marks 60 Mins

Detailed Solution

Download Solution PDF

Important PointsIf you select cells B9 and B10 in MS-Excel, where B9 contains the value 3 and B10 contains the value 6, and then drag the fill handle down to B13, the contents of cells B11, B12, and B13 will be:

  • B11: 9
  • B12: 12
  • B13: 15

qImage644145cfef2bbb476b102c8b

  • This is because when you drag the fill handle down, Excel automatically fills the cells in a series based on the pattern it detects from the initial selection.
  • In this case, it detects the pattern of adding 3 to the previous cell's value, which results in the values shown above.
Latest UGC NET Updates

Last updated on Jun 12, 2025

-> The UGC NET June 2025 exam will be conducted from 25th to 29th June 2025.

-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.

-> The exam is conducted bi-annually - in June and December cycles.

-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions. 

-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.

More Types of Softwares Questions

Get Free Access Now
Hot Links: online teen patti teen patti boss teen patti master app