Subject: IT and Computer Science

BSN


Page 35 of 36

#273

What is the default behavior when you drag the fill handle with a single number (e.g., 1)?

A) It increments the number.

B) It repeats the same number.

C) It calculates the sum.

D) It generates random numbers.


Answer:   B

Explanation Photo


Register (if not registered) or Login for comments

Comments:



#274

To identify rows by numbers, you would look at which part of the Excel interface?

A) Top of the worksheet

B) Bottom tabs

C) Left side of the worksheet

D) Right side of the worksheet


Answer:   C

Explanation Photo


Register (if not registered) or Login for comments

Comments:



#275

The process of automatically filling a range of cells with a series of data is called:

A) Manual entry

B) Copy-pasting

C) Series Generation

D) Data validation


Answer:   C

Explanation Photo


Register (if not registered) or Login for comments

Comments:



#276

What does an Excel workbook consist of?

A) A single cell

B) Multiple worksheets

C) Only formulas

D) Only images


Answer:   B

Explanation Photo


Register (if not registered) or Login for comments

Comments:



#277

Which feature allows you to ensure that data entered into cells adheres to specific rules (e.g., numbers between 0-100)?

A) Conditional Formatting

B) Cell Styles

C) Data Validation

D) Merge Cells


Answer:   C

Explanation Photo


Register (if not registered) or Login for comments

Comments:



#278

If you type "9:30 AM" into a cell, what type of data is it?

A) Text

B) Number

C) Time

D) Date


Answer:   C

Explanation Photo


Register (if not registered) or Login for comments

Comments:



#279

What is the primary purpose of "Go To Special" in Excel?

A) To navigate to any cell quickly

B) To find cells with specific characteristics like formulas or blanks

C) To create a new worksheet

D) To print selected areas


Answer:   B

Explanation Photo


Register (if not registered) or Login for comments

Comments:



#280

Which group on the Home tab would you find the "Conditional Formatting" button?

A) Alignment

B) Number

C) Styles

D) Cells


Answer:   C

Explanation Photo


Register (if not registered) or Login for comments

Comments:



Page 35 of 36