Fonts That Make Bars Look Filled & Complete – Excel Challenges

Hey folks! Welcome. Excel TV wishes you a very happy new year. Excel Author Jordan Goldmeier is ready with the first Excel challenge in 2016, but as usual before looking at this episode’s challenge, let us have a look at answer to previous episode’s challenge.

Last Week’s Challenge

Correct Answer from last week’s Challenge

If you remember, last episode’s challenge was on Excel Colors. Jordan asked how the value of RGB (R,G,B) is calculated? So, here is the answer.

If you remember converting numbers from one number system to another number system in school, then this would help you to answer this challenge. Here you need to consider the base as 256.

So, RGB (R,G,B) is calculated as R*256^0 + R * 256^1 + R*256^2

Here, RGB (130, 210, 11) = 774786 is calculated in the same way.

Hope you got it! Interesting right?

Last episode’s winner is “Ryan Tretter”. Congratulations!

What are the Fonts That Make Bars Look Filled & Complete

Now, Jordan comes up with this week’s Excel challenge and here it goes,

You can create in-cell Sparklines using the REPT formula and the “pipe” | symbol. There are two commonly used fonts in this trick that will make the bar look filled in and complete. Name one of those fonts.

Hurry up to Answer

You know the answer? Then what are you waiting for? Comment your answer below this post or answer us through Facebook. You can even tweet answer @ExcelTv. Hurry Up!

• Author
• Recent Posts

Sridhar Belide

Sridhar Belide is a skilled software engineer with over a decade of experience in the industry. Currently working at Wells Fargo since December 2018, he focuses on developing UI frameworks for front-end applications using React. Before joining Wells Fargo, Sridhar spent five years and four months at Tata Consultancy Services, where he held the position of IT Analyst. He also has experience as a Community Manager for Impact SoftTech Pvt. Ltd. EALP and as a Software Research and Development Engineer at NSN - Nokia Solutions and Networks. Sridhar holds a Bachelor of Technology (B.Tech.) in Computer Science from JNTUH, demonstrating his strong foundation in the field.

Latest posts by Sridhar Belide (see all)

• 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