20+ Consultant 1 Interview Questions and Answers

Three ants on an equilateral triangle can move along any two sides. What is the probability of no collision?

• Each ant has two possible directions to move

• The probability of collision is 1/3

• The probability of no collision is 8/27

Calculate probability of an insect on a Rubik's cube returning to center block after 2 moves and falling on side face on 3rd move.

• The insect has 4 options for each move

• To return to center block, it must move in opposite direction of its first move

• Probability of returning to center block after 2 moves is 0.125

• Probability of falling on side face on 3rd move is 0.5

The bird travels the same distance as the sum of the distances covered by both trains.

• The bird starts with one train and reverses its direction when it reaches the other train.

• This process continues until the two trains collide.

• The distance traveled by the bird is equal to the sum of the distances covered by both trains.

Smallest number with remainders when divided by 2 to 9.

• Find the LCM of 2 to 9.

• Add 1 to the LCM until it satisfies the given remainders.

• The final number is the smallest number that satisfies all the remainders.

25 horses, 5 lanes, no stopwatch. Find fastest 3 horses. Minimum races required?

• Divide horses into 5 groups of 5 each

• Race each group, identify fastest horse from each group

• Race the 5 fastest horses, identify the fastest horse

• Repeat the process with the remaining 20 horses

• Total races required = 7

Visa, Mastercard, and AmEx are payment networks that process transactions made with credit cards.

• Visa, Mastercard, and AmEx are payment networks that facilitate transactions between merchants, banks, and cardholders.

• They provide the infrastructure for credit card transactions to occur, including authorization, clearing, and settlement.

• Visa and Mastercard are accepted at most merchants worldwide, while AmEx is more exclusive and typically accepted at higher-end establishments....read more

The number of rows in an airplane affects profits.

• The number of rows determines the seating capacity of the airplane.

• More rows can lead to higher profits if the demand for tickets is high.

• Fewer rows can lead to lower profits if the demand for tickets is low.

• The number of rows also affects the weight and fuel consumption of the airplane.

• Changing the number of rows may require adjustments in pricing and seating arrangements.

Analytics is used in various fields around me

• Marketing and advertising

• Finance and banking

• Healthcare and medicine

• Sports and fitness

• Transportation and logistics

The number of lines that can be constructed using 5 non-collinear points and 3 collinear points.

• The 3 collinear points will form 3 lines.

• Each of the 5 non-collinear points can be connected to the other 4 points to form 20 lines.

• However, any line passing through one of the collinear points will be redundant.

• Therefore, the total number of lines that can be constructed is 20 - 3 = 17.

The distance between Delhi and Beijing can be estimated using various methods.

• One can use the Haversine formula to calculate the distance based on the latitude and longitude of the two cities.

• Another method is to use online distance calculators that take into account the flight distance and driving distance.

• The distance can also be estimated by looking at the approximate time it takes to travel between the two cities by air or road.

• Factors such as the mode of transportation, ...read more

Estimating the number of Rs. 1000 notes in India before demonetization.

• The total currency in circulation before demonetization was around Rs. 17.77 lakh crore.

• Rs. 1000 notes constituted around 39% of the total currency in circulation.

• Therefore, the estimated number of Rs. 1000 notes in India before demonetization was around 6.92 billion.

• However, this is just an estimate and the actual number may vary.

Calculated fields in Microsoft Excel are formulas created by users to perform calculations on data in a table.

• Calculated fields are created using formulas

• They can perform calculations on data in a table

• Examples include summing up columns or calculating averages

• Calculated fields are dynamic and update automatically when the data changes

The estimated number of people who participated in the Delhi Marathon is...

• The number of registered participants can be used as a starting point

• Factors such as weather conditions, location, and popularity of the event can affect the turnout

• Previous years' participation numbers can also be used as a reference

• Media coverage and social media activity can provide insights into the event's popularity

• An official statement from the organizers can provide an accurate count

VLOOKUP is a function in Excel used to search for a specific value in a table and return a corresponding value.

• VLOOKUP stands for Vertical Lookup

• It is used to find a specific value in a table and return a corresponding value from the same row

• It requires a lookup value, table array, column index number, and range lookup

• Example: VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

• It is commonly used in financial analysis, data management, and reporting

Pandas provides multiple ways to reset the index of a DataFrame or Series.

• The reset_index() function resets the index to the default integer index.

• The set_index() function sets a column as the new index.

• The reindex() function can be used to change the order of the index or add missing values.

• The rename_axis() function can be used to rename the index or column labels.

A credit card allows you to borrow money from a bank or financial institution to make purchases.

• Credit card issuer gives you a line of credit based on your creditworthiness

• You can use the card to make purchases up to your credit limit

• You have to pay back the borrowed amount with interest

• If you don't pay the full amount, interest is charged on the remaining balance

• Late payments or exceeding credit limit can result in fees and damage to credit score

The number of zeros in 100! can be determined by counting the number of factors of 10.

• Count the number of factors of 10 in the prime factorization of 100!

• Each factor of 10 is made up of 2 and 5, so count the number of 2's and 5's separately

• There are more factors of 2 than 5, so count the number of factors of 5

• There are 24 factors of 5 in 100!, so there are 24 zeros at the end

R is a programming language commonly used for statistical computing and graphics.

• R has a wide range of built-in functions for data manipulation, statistical analysis, and visualization.

• Some commonly used functions in R include mean(), sum(), max(), min(), sd(), var(), and plot().

• R also allows users to create their own functions using the function() keyword.

• Functions in R can take arguments and return values.

• R functions can be called using the function name followed by parenth...read more