Question

Choose the correct option.
OPTIONS
7
A content manager is working on an excel sheet. She has 6 columns in the sheet- A,B,C,D,E and
F. She has to check that no two columns should have the same entry. She can check only2
columnns at a time. How many times will she have to repeat the comparing process to complete
the process for the whole file?
8
15
10​

Answer 1

Answer:

The correct answer is 15.

Step-by-step explanation:

Two columns can be selected in 6C2 ways.

Therefore, answer is 6C2 = 15

Answer 2

Answer:

She will have to repeat the comparing process 15 times to complete

the process for the whole file.

Step-by-step explanation:

Given:

6 columns

Columns are A, B, C, D, E, and F.

Also, specially mentioned that at a time only two columns have to be compared.

To find:

The number of times the comparison process has to be done by the content manager to finish the entire file.

Solution:

• Firstly, column A is compared with column B.(count 1)

• Then, column A is compared with column C. (count 2)

• Next, column A is compared with column D.(count 3)

• Then, column A is compared with column E.(count 4)

• Next, column A is compared with column F.(count 5)

• Next, column B is compared with column C.(count 6)

• Then, column B is compared with column D.(count 7)

• Next, column B is compared with column E.(count 8)

• Then, column B is compared with column F.(count 9)

• Next, column C is compared with column D. (count 10)

• Then, column C is compared with column E.(count 11)

• Next, column C is compared with column F.(count 12)

• Then, column D is compared with column E.(count 13)

• Next, column D is compared with column F.(count 14)

• Then, column E is compared with column F.(count 15)

Totally, 15 comparisons took place in this process.