Subject: IT and Computer Science

#257

If you want to view only students who scored above 80, which feature would you use?

A) Sort

B) Merge Cells

C) Filter

D) Find

Answer:   C

---

#258

What is the keyboard shortcut for "Find" in Excel?

A) Ctrl + S

B) Ctrl + F

C) Ctrl + P

D) Ctrl + A

Answer:   B

---

#259

What does "automatic calculation" in Excel mean?

A) Formulas are manually updated.

B) Formulas update only when saved.

C) Formula results recalculate instantly when input values change.

D) Excel only calculates when printed.

Answer:   C

---

#260

Which function can be used to check a condition and return one value if true and another if false?

A) SUM()

B) AVERAGE()

C) IF()

D) MAX()

Answer:   C

---

#261

Which term describes raw, unorganized facts entered into a cell?

A) Formula

B) Function

C) Value

D) Macro

Answer:   C

---

#262

What is the typical purpose of using `VLOOKUP` for grading in a DMC?

A) To calculate total marks

B) To apply conditional formatting

C) To assign grades dynamically from a lookup table

D) To sort student names alphabetically

Answer:   C

---

#263

If cell A1 contains 5 and cell B1 contains 3, what will `=A1*B1` return?

A) 8

B) 15

C) 2

D) 1.66

Answer:   B

---

#264

To highlight all cells with values greater than a specific number, you would use:

A) Merge Cells

B) Cell Styles

C) Conditional Formatting

D) Sort and Filter

Answer:   C

---

Page 33 of 36