Subject: IT and Computer Science

#233

Which of the following is a type of Conditional Formatting rule?

A) Merge Cells Rules

B) Highlight Cells Rules

C) Protect Cells Rules

D) Rename Cells Rules

Answer:   B

---

#234

What is the benefit of converting a range of cells into an Excel Table using "Format as Table"?

A) It only changes the appearance with borders.

B) It provides built-in functionalities like filtering and sorting.

C) It automatically deletes duplicate data.

D) It prevents formula errors.

Answer:   B

---

#235

Which tab in Excel allows you to "Format as Table"?

A) Data tab

B) Review tab

C) Home tab

D) View tab

Answer:   C

---

#236

What do Cell Styles help to ensure?

A) Random formatting

B) Inconsistency across the sheet

C) Consistency and time-saving in formatting

D) Deletion of cell contents

Answer:   C

---

#237

Which tab contains the "Cell Styles" option?

A) Formulas tab

B) Home tab

C) Page Layout tab

D) View tab

Answer:   B

---

#238

What is the purpose of the "Sort" feature in Excel?

A) To hide unwanted data

B) To rearrange data in ascending or descending order

C) To find specific values

D) To combine cells

Answer:   B

---

#239

On which tab can you find the "Sort & Filter" group?

A) Home tab

B) Insert tab

C) Data tab

D) Formulas tab

Answer:   C

---

#240

What is the purpose of the "Filter" feature in Excel?

A) To rearrange rows randomly

B) To display only the rows that meet specific criteria

C) To apply colors to cells

D) To combine data from multiple sheets

Answer:   B

---

Page 30 of 36