Challenge No. 407: Mirror Cipher with Caesar’s Shift – Reverse the words and then reverse the alphabets within the words.
Solved using: Python.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
Find Sides of Right Triangle
Challenge No. 406: For a right angled triangle, Area and Hypotenuse are given.
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.
Render ASCII US Flag
Challenge No. 404: Generate US ASCII flag.
Solved using: Python.
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.
Validate Vehicle Registration Numbers
Challenge No. 163: Extract the valid vehicle registration numbers from given data table T2.
Solved using: R.
Encrypt Using Vigenere Cipher
Challenge No. 402: Vignere Cipher – Write the plain text (p) and keyword (k) beneath that.
Solved using: Python in Excel.
Form Pyramid from Text String
Challenge No. 401: Prepare the triangle from column A strings.
Solved using: Python.