Subject: IT and Computer Science

#265

Which tab would you go to for advanced sorting options (e.g., sorting by multiple columns)?

A) Home

B) Insert

C) Data

D) Formulas

Answer:   C

---

#266

When using the fill handle with dates, what does Excel usually do?

A) Repeats the same date.

B) Automatically increments the date.

C) Converts dates to numbers.

D) Generates random dates.

Answer:   B

---

#267

What is the advantage of saving an Excel file as a template (.xltx)?

A) It makes the file read-only.

B) It simplifies the process for new batches of students.

C) It converts it to a PDF.

D) It encrypts the data.

Answer:   B

---

#268

Which group on the Home tab contains the "Merge & Center" option?

A) Font

B) Number

C) Alignment

D) Styles

Answer:   C

---

#269

Which term refers to a single page within an Excel workbook?

A) Workbook

B) Worksheet

C) Document

D) Page

Answer:   B

---

#270

What is a key benefit of using Excel Tables over plain ranges?

A) They cannot be sorted.

B) They have dynamic ranges for formulas.

C) They only store text data.

D) They limit the number of rows.

Answer:   B

---

#271

If you want to replace specific text throughout your worksheet, which feature would you use?

A) Find only

B) Go To Special

C) Replace

D) Filter

Answer:   C

---

#272

In the context of DMCs, what does "Max Possible Marks" refer to?

A) The highest score achieved by any student.

B) The total possible points for all subjects combined.

C) The average marks of the class.

D) The lowest passing score.

Answer:   B

---

Page 34 of 36