Challenge No. 404: Generate US ASCII flag.
Solved using: Python.
MAKEARRAY
Creates an array of values using a function in Excel.
Generate Axis for Four Quadrants
Challenge No. 389: Generate X and Y axes of all 4 quadrants for value given in A1.
Solved using: R.
Draw Square With X Pattern
Challenge No. 380: Draw an N x N square where sides and diagonals are filled with x.
Solved using: Python.
Matrix Calculation! Part 1
Challenge No. 188: Create a formula that, for any given value of ‘n’, generates an ‘n x n’ identity matrix where all values are 0, except for the diagonal (primary) values, which should be 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, and Python in Excel.
Power!
Challenge No. 121: Create the given table for the continuous values of power and bases.
Solved using:Excel (LAMBDA, MAKEARRAY, ROW), Office Script, Power Query (List.Transform), and Python in Excel.
Character-Based Rhombus
Challenge No. 77: Create a formula to receive a number n as input and generate a rhombus with a diameter equal to n using “*” characters.
Solved using:Excel (DROP, IF, LAMBDA), Power Query (List.Transform), Python, R, and VBA.