Challenge No. 171: Transpose given problem table into result table.
Solved using: Python.
⭐️⭐️ Easy
Slightly challenging problems for learners.
Reverse, Cipher and Shift Text
Challenge No. 407: Mirror Cipher with Caesar’s Shift – Reverse the words and then reverse the alphabets within the words.
Solved using: Python.
Find Sides of Right Triangle
Challenge No. 406: For a right angled triangle, Area and Hypotenuse are given.
Solved using: Python in Excel.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
List Prime-Surrounded Sandwich Numbers
Challenge No. 405: Sandwich numbers – A number is said to be a Sandwich number if the number prior to it and the number after it, both are primes.
Solved using: Excel VBA.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
Summarize by Five-Year Brackets
Challenge No. 403: Generate the Sum of Value and % of Value for year brackets of 5 years each.
Solved using: Python in Excel.
Form Pyramid from Text String
Challenge No. 401: Prepare the triangle from column A strings.
Solved using: Python.
Check Connectivity of Random Points
Challenge No. 400: Coordinates for points are given in x, y format.
Solved using: R.
Min and Max Dates by Group
Challenge No. 398: Generate the min and max dates for different year and month combinations.
Solved using: Python in Excel.