1. Make a backup of your workbook.
2. Open your workbook and ALT+F11
3. Locate your Workbook name in Project Explorer Window
4. Right click on your workbook name > Insert > Module
1. Make a backup of your workbook.
Below is a possible solution to the challenge Challenge 52 - Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5...
Put following formula and drag down
This time challenge before you is to write a formula which can be dragged down and leaves so many blank cells - 1 before that alphabet's position in English Language. Hence, the sequence will start with A, will leave 1 blank cell, then B, then 2 blank cells, then C, then 3 blank cells, then D, then 4 blank cells, then E, then 5 blank cells, then F....................................................................then 24 blank cells, then Y and finally 25 blank cells and then Z.
< The template can be downloaded from Template 08 - Thermometer Chart >
Thermometer Chart is used to show the progress towards a goal. It is generally used to reflect on the percentage achievement.
The template here gives many different type of Thermometer charts. You can create many more and / or format existing ones to meet your requirements.
By eforexcel|2017-06-08T17:50:32+00:00Saturday, October 15th, 2016|Categories: Tips and Tricks, VBA|Tags: CTRL+SHIFT+ESC, Excel.exe, Program Files, Program Files(86), Task Bar, Task Manager|4 Comments
Generally Excel.Exe will be located in C:\Program Files (x86)\Microsoft Office\Office15 in case of Excel 2013 / Windows 7. During installation, if another path is chosen, Excel.Exe's location changes. Default Path is also dependent upon Office and Windows combinations. Sometimes, it may not be locatable at all.
To find the location of Excel.Exe -
1. Start Excel
2. Right click on Windows Task Bar > Start Task Manager > Processes tab (Task Manager can also be opened by pressing CTRL+SHIFT+ESC)
Below is a possible solution to the Challenge 51 - Another Word Challenge - Whether Given Words are Anagram or not
Use following formula -
Excel Quiz 46
0 of 10 questions completed
A general quiz on Excel.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
0 of 10 questions answered correctly
Time has elapsed
You have reached 0 of 0 points, (0)
- Not categorized 0%
Question 1 of 10
Question 2 of 10
Question 3 of 10
The shortcut for Insert Function dialog box isCorrect
Question 4 of 10
How many maximum records can be shown in a filtered list?Correct
Question 5 of 10
Calculate Sheet can be invoked through following shortcutCorrect
Question 6 of 10
Question 7 of 10
Mail Merge is a functionality of ExcelCorrect
Question 8 of 10
The syntax for Custom Format in Excel isCorrect
Question 9 of 10
What is the answer for following
Question 10 of 10
By eforexcel|2016-08-24T16:44:53+00:00Saturday, October 08th, 2016|Categories: Challenges|Tags: Casesar, Cipher, Code, Crypt, Cryptography, Decrypt, Decryption, Encrypt, Encryption, Julian, SHIFT, Substitution|2 Comments
We published a cryptography challenge Challenge 39 - Cryptography Challenge 1 - Caesar's Shift Cipher. The purpose of the challenge was to create an Excel based Encrypter.
This time, we need to create the de-crypter for the same. The Excel file related to this challenge can be downloaded from Challenge 53 - Decryption - Caesar's Shift Cipher