Subject: IT and Computer Science

#249

What is the file extension for saving an Excel file as a template?

A) .xlsx

B) .xlsm

C) .xltx

D) .csv

Answer:   C

---

#250

Which of the following is NOT a level of organization in Excel?

A) Cell

B) Row

C) Paragraph

D) Sheet

Answer:   C

---

#251

If a cell contains "John Doe", what type of data is it?

A) Number

B) Date

C) Text

D) Formula

Answer:   C

---

#252

What is the purpose of using cell references in a formula?

A) To make the formula static

B) To refer to specific cells for calculations

C) To hide the formula

D) To change cell formatting

Answer:   B

---

#253

Which operator performs multiplication in Excel formulas?

A) + (plus)

B) - (minus)

C) * (asterisk)

D) / (slash)

Answer:   C

---

#254

What is the key benefit of Conditional Formatting?

A) It makes the file smaller.

B) It makes data patterns and trends visually apparent.

C) It converts text to numbers.

D) It protects cells from unauthorized access.

Answer:   B

---

#255

When you "Format as Table," what is a key functionality gained?

A) Ability to embed videos

B) Automatic formula replication for new rows

C) Creating PowerPoint slides

D) Sending emails directly

Answer:   B

---

#256

Which style group is associated with "Cell Styles" on the Home tab?

A) Font

B) Alignment

C) Styles

D) Number

Answer:   C

---

Page 32 of 36