Subject: IT and Computer Science

BSN


Page 32 of 36

#249

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

A) .xlsx

B) .xlsm

C) .xltx

D) .csv

Answer:   C
Explanation Photo

Register or Login for comments

Comments:


#250

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

A) Cell

B) Row

C) Paragraph

D) Sheet

Answer:   C
Explanation Photo

Register or Login for comments

Comments:


#251

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

A) Number

B) Date

C) Text

D) Formula

Answer:   C
Explanation Photo

Register or Login for comments

Comments:


#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
Explanation Photo

Register or Login for comments

Comments:


#253

Which operator performs multiplication in Excel formulas?

A) + (plus)

B) - (minus)

C) * (asterisk)

D) / (slash)

Answer:   C
Explanation Photo

Register or Login for comments

Comments:


#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
Explanation Photo

Register or Login for comments

Comments:


#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
Explanation Photo

Register or Login for comments

Comments:


#256

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

A) Font

B) Alignment

C) Styles

D) Number

Answer:   C
Explanation Photo

Register or Login for comments

Comments:



Page 32 of 36