Subject: IT and Computer Science

#225

What is the purpose of formulas in Excel?

A) To only store text

B) To automate calculations

C) To create images

D) To play games

Answer:   B

---

#226

What will the formula =A1+B1 do in Excel?

A) Concatenate the text in A1 and B1

B) Add the values in cell A1 and B1

C) Subtract the values in A1 and B1

D) Multiply the values in A1 and B1

Answer:   B

---

#227

Which Excel function calculates the sum of values in a range?

A) AVERAGE()

B) COUNT()

C) SUM()

D) MAX()

Answer:   C

---

#228

What is the purpose of merging cells in Excel?

A) To increase cell size for calculations

B) To combine two or more adjacent cells into a single larger cell

C) To hide data in cells

D) To change the cell color

Answer:   B

---

#229

Which tab in Excel contains the "Merge & Center" button?

A) Data tab

B) Insert tab

C) Home tab

D) Formulas tab

Answer:   C

---

#230

When merging cells, what happens to the data in the cells being combined?

A) All data from all cells is preserved.

B) Only data from the top-leftmost cell is preserved.

C) Data from the bottom-rightmost cell is preserved.

D) All data is deleted.

Answer:   B

---

#231

What is the purpose of Conditional Formatting in Excel?

A) To permanently change cell colors

B) To apply specific formatting to cells based on their content

C) To protect cells from editing

D) To merge cells automatically

Answer:   B

---

#232

On which tab can you find the Conditional Formatting option?

A) Insert tab

B) Data tab

C) Home tab

D) Review tab

Answer:   C

---

Page 29 of 36