Advanced Excel Interview Questions Set - 4 Released
Intermediate Level How would you use the INDEX and MATCH functions together to perform a two-way lookup in Excel? • Perform a lookup based on both row and column values, more versatile than VLOOKUP. • INDEX(range, row_num, column_num): Returns the value at the intersection of...
Advanced Excel Interview Questions Set - 3 Released
Intermediate Level Run down the process of creating a drop-down list in Excel? To create a drop-down list in Excel: 1. Enter the list of items you want in the drop-down list in a column (e.g., A1:A5). 2. Select the cell where you want the...
Advanced Excel Interview Questions Set - 2 Released
Intermediate Level What is a hyperlink, and how do you add a hyperlink? A hyperlink in Excel is a link that directs you to another location, such as a web page, a different worksheet, or a specific cell within the same worksheet. Example: To add...
Advanced Excel Interview Questions Set - 1 Released
Intermediate Level What is the difference between a range and a named range? A range in Excel refers to a selection of two or more cells. For example, “A1:A10” refers to a range of cells from A1 to A10. Ranges are often used in formulas,...
Python Interview Questions Set - 17 Released
Intermediate Level How to merge two DataFrames on a common column? df1 = pd.DataFrame({"A":[1,2,3], "B":[11,12,13]}) df2 = pd.DataFrame({"A":[1,2,4], "B":[21,22,23]}) new_df = pd.merge(df1, df2, how='inner', on='A') new_df A B_x B_y 0 1 11 21 1 2 12 22 How to apply a function to each element...
Python Interview Questions Set - 16 Released
Intermediate Level How to merge two DataFrames on a common column? df1 = pd.DataFrame({"A":[1,2,3], "B":[11,12,13]}) df2 = pd.DataFrame({"A":[1,2,4], "B":[21,22,23]}) new_df = pd.merge(df1, df2, how='inner', on='A') new_df A B_x B_y 0 1 11 21 1 2 12 22 How to apply a function to each element...
Python Interview Questions Set - 15 Released
Intermediate Level How to create a NumPy array of evenly spaced values between a given range? arr = np.arange(10,100,5) arr How to create a DataFrame from a list of lists or list of tuples? data = [ [1,'Alice',88], [2, 'Bob',90], [3, 'Charlie',92] ] df =...
Python Interview Questions Set - 14 Released
Intermediate Level Print First 10 natural numbers using while loop cnt = 0 while (cnt := cnt + 1)
Python Interview Questions Set - 13 Released
Intermediate Level Display numbers divisible by 5 from a list lst_ = list(np.random.randint(10,99,100)) def isDivByFive(num): return (num%5==0) for n in lst_: if isDivByFive(n): print(n, end=",") Create the dictionary with number and its square which is leas then or equal to given number. ur_input = int(input("Enter...
Python Interview Questions Set - 12 Released
Intermediate Level Calculate the multiplication and sum of two numbers a, b = map(int, input("Enter Two Numbers: ").split()) def printSumMulti(num1, num2): print(f"Sum is: {num1 + num2}") print(f"Multiplication is {num1*num2}") printSumMulti(a,b) Print the sum of the current number and the previous number in range ur_input =...
Python Interview Questions Set - 11 Released
Intermediate Level Write the python program to print the numbers in the range without using loops ur_input = int(input("Enter Some Number: ")) def printNums(num): if num > 0: printNums(num-1) print(num) printNums(ur_input) Write the python program to print the numbers in range in descening order without...
Python Interview Questions Set - 10 Released
Intermediate Level Write the python program to Check the occurrence of given character in string ur_input = input("Enter Some String: ") chr_to_check = input("Enter Some Character: ") res = ur_input.count(chr_to_check) Write the python program to print the multiplication table ur_input = int(input("Enter Some Number: "))...