Challenge No. 542: Generate the given squares from the given strings.
Solved using: Excel VBA.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Find Triangle with Given Area
Challenge No. 540: Find the perpendicular and base for a right angled triangle where Hypotenuse and Area are given.
Solved using: Python in Excel.
List All Emirp Numbers
Challenge No. 538: An emirp (prime spelled backward = emirp) number is a prime number and its reversal is also a prime number but this is not a palindromic prime.
Solved using: Python in Excel.
Sum and Sort Student Marks
Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.
Find Min Product of Three
Challenge No. 537: Find the minimum product which results from multiplying any 3 numbers from N1 to N6.
Solved using: Python in Excel.
Fill 5×5 Grid with Index
Challenge No. 536: Put values in a 5×5 grid as per their rows and columns positions.
Solved using: R.
Reformat Item Entries
Challenge No. 242: Transform the problem table into result table as shown.
Solved using: Python.
Draw Symmetric Star in ASCII
Challenge No. 533: Draw ASCII star for given N which is an odd number for the purpose of symmetry.
Solved using: Python in Excel.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Remove Digit to Make Divisible
Challenge No. 531: List first 500 numbers starting with 101 which don’t end with 0 and are divisible at least once by removing one digit at a time from the number.
Solved using: R.