⭐️ Beginner Archives - Page 27 of 41

Alternate Letter Casing

Challenge No. 241: Convert the English letters into small and capital alternately.
Solved using: Excel VBA.

Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.

Challenge No. 237: Prepare the result table from Problem table.
Solved using: Power Query.

Challenge No. 235: Populate the Groups (from table 2) on the basis of words appearing in Text column.
Solved using: Power Query.

Challenge No. 234: Find the numbers which are divisible by their individual digits.
Solved using: Python in Excel.

Challenge No. 231: List Yes if a Number is Pandigital number in a given base else No.
Solved using: Power Query.

Challenge No. 230: This challenge is contributed by Mehmet Çiçek.
Solved using: Excel VBA.

Challenge No. 233: List all valid names from A2:A11
The criteria for valid names are –
1.
Solved using: Power Query.

Challenge No. 229: Find all double base Palindrome Numbers.
Solved using: Python in Excel.

Challenge No. 232: Affine Cipher
This is a kind of Caesar’s Cipher.
Solved using: Excel VBA.