Subject: IT and Computer Science

#241

Which feature is used to quickly locate specific text, numbers, or formulas within a worksheet?

A) Sort

B) Filter

C) Find and Select

D) Merge Cells

Answer:   C

---

#242

What happens when you change an input value in a cell that is referenced by an Excel formula?

A) The formula result remains unchanged.

B) The formula result is deleted.

C) Excel automatically recalculates the formula result.

D) You must manually re-enter the formula.

Answer:   C

---

#243

What is the small square at the bottom-right corner of a selected cell/range, used for series generation, called?

A) Sort handle

B) Filter button

C) Fill handle

D) Merge handle

Answer:   C

---

#244

If you select cells A1 and A2 containing "Jan" and "Feb" respectively, and drag the fill handle down, what will happen?

A) Only "Jan" will be repeated.

B) Only "Feb" will be repeated.

C) It will automatically generate "Mar", "Apr", etc.

D) It will produce an error.

Answer:   C

---

#245

When creating a Detailed Mark Certificate (DMC), which Excel function is commonly used to calculate Total Marks?

A) AVERAGE()

B) COUNT()

C) SUM()

D) MAX()

Answer:   C

---

#246

Which Excel feature can be used to assign grades based on percentage ranges (e.g., A+, A, B)?

A) Conditional Formatting

B) Merge Cells

C) IF Function (nested)

D) Filter

Answer:   C

---

#247

To create a Merit List, by which column would you typically sort the data?

A) Student Name (Ascending)

B) Roll Number (Ascending)

C) Percentage (Descending)

D) Remarks (Ascending)

Answer:   C

---

#248

What is the primary purpose of "Data Validation" when creating DMCs?

A) To highlight top scores

B) To ensure correct data entry (e.g., marks between 0-100)

C) To merge student names

D) To automatically calculate percentages

Answer:   B

---

Page 31 of 36