Have you answered the previous Excel challenge on Financial question in Excel? In this new Excel Challenge Excel MVP Jordan Goldmeier comes up with an idea to test you a bit more about Excel. Let us look in to that.
Last Week’s Challenge
Eager to know about the present episode’s Excel Challenge which tests your knowledge on Excel? But, have a break buddy! Before going to that, let us have a look at previous episode’s Excel Challenge.
It goes in this way, “What excel function helps you figure out the monthly loan payment?”. Have you answered this and want to know the correct answer?
Correct Answer From Last Week’s Excel Challenge
PMT() is the correct answer. As Jordan said, there are millions of responses and from the correct responses, Shaun O’Donnell was selected as the winner. Congratulation Bro! Do you know what he earned by being the winner? He receives the Jordan’s free eBook version of Dashboards for Excel. You are really lucky Shaun!
You wish you could be the winner and want to earn such cool prizes? Don’t worry at all. Try to be the winner for the current episode’s Excel Challenge.
Have You Ever Used Color Index Property?
Jordan specifies that Excel has an internal color palette retrieved using the ColorIndex property. So, here comes the present episode’s Excel Challenge on the same.
“The colors in Excel’s internal palette can be retrieved using the ColorIndex property. How many colors are available in total?” Do not how many have used the Colorindex property. Jordan is expecting the maximum number of colors or maximum color index as the answer.
Do You Know What Winner Of This Episode Wins?
Winner of this challenge wins the free course from Mynda Treacy at MyOnlineTrainingHub.com. Ah! Very lucky! You can be the one.
Be The Winner By Answering Correctly
Answer this challenge by commenting in this blog post or in Facebook Page. You can even tweet the correct answer to @ExcelTv. Hurry up for the free course!
- Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks - February 17, 2022
- Using the Immediate Window in VBA - April 4, 2017
- Intersection Operator with Named Ranges – Excel Tips and Tricks - October 3, 2016
Answer: 56 colors
8 named colors and a 56 color palette with 46 unique colors 🙂
http://wellsr.com/vba/2015/excel/vba-colorindex-color-infographic/
8 named colors, a 56 color palette with 46 unique colors 🙂 http://wellsr.com/vba/2015/excel/vba-colorindex-color-infographic/
56 colors
56 Colors are there in the Color Index Property in Excel
A 56 color palette with 46 unique colors. See them all in the ribbon using the free Excel Color Commander add-in:
http://www.spreadsheet1.com/excel-color-commander.html