Challenge No. 305: Print Sine Wave for Amplitudes given in B2
Example for Amplitudes 2, 3 and 4 are given.
Solved using: Python in Excel.
⭐️⭐️ Easy
Slightly challenging problems for learners.
Generate Output Table from Data
Challenge No. 113: Generate result table from problem table.
Solved using: Python in Excel.
Prime After Digit Removal
Challenge No. 303: Remove the digits in each position and list those numbers which are prime for all occurrences of removal.
Solved using: Python in Excel.
Table Transformation! Part 22
Challenge No. 181: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Alternate, List.Transform, Table.Group), Python in Excel, and R.
Creating a Recruitment Plan from Headcount
Challenge No. 50: Create a Recruitment plan from the Projected Headcount.
Solved using: Python.
Split words by half total alphabet score
Challenge No. 299: Consider a=1..
Solved using: Python in Excel.
Find Palindromic Numbers via 196
Challenge No. 296: 196-Algorithm – Take any positive integer of two digits or more, reverse the digits, and add to the original number.
Solved using: Python in Excel.
Table Transformation! Part 21
Challenge No. 177: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.ExpandTableColumn, Table.Group), Python, Python in Excel, and R.
Custom Grouping! Part 16
Challenge No. 176: Group every five rows of the question table and then provide some of quantity for each group.
Solved using:Excel (GROUPBY, HSTACK, LAMBDA), Google Sheets, Power Query (Table.Group, List.Transform, Table.AddIndexColumn), Python, Python in Excel, and R.
Identify Missing Brackets
Challenge No. 289: There are 3 types of Parentheses (brackets) – ( ), { }, [ ].
Solved using: Python in Excel.