# Excel Quick Access Toolbar – 003 VBAExpress Forums Challenge of the Week

Hello Excel TV Fans! Have you answered the previous week’s Excel Challenge? If you are good at Excel Quick Access Toolbar, then this week’s Excel Challenge is very interesting. But, before that let us look at the answer for last week’s challenge.

## Last Week’s Challenge

Excel MVP Jordan asked to list down 2 Excel functions such that by changing the smallest number of characters in one function would result in the second function.

## Correct Answer From Last Week’s Challenge

Correct answer is T() and N() are the two Excel functions which meets the condition mentioned in the Challenge.

T(value) – returns the text referred to by value.

N(value) – converts a value into a number.

This week’s winner is Heather Gray.

Congratulations Heather Gray! You won a cool looking mouse pad as said in the previous episode.

We know that, every icon on the Quick Access Toolbar has some functionality. We could know what it is, by just hovering the mouse on it. In such a way, you could see the snapshot of Jordan’s quick access toolbar in the video and you need to mention what each icon on that stands for.

Answer as many as you can and winner will be declared based on the most number of icons you have answered correctly.

## What is the Prize for the Winner?

Winner of this week’s Excel Challenge will get 12-month free subscription for Dashboard course of Mynda Treacy from www.MyOnlineTrainingHub.com

Then Hurry Up!

What are you waiting for? Go ahead and comment your answer in Excel TV blog post or Facebook or Excel Challenges forum of VBAExpress.com. You can even tweet to @ExcelTV. Come On!

Tags

#### You may also like

December 20, 2013

## 100+ Best Excel Resources And Websites

100+ Best Excel Resources And Websites

August 6, 2019

## How to Create a Relative File Path in Power Query

How to Create a Relative File Path in Power Query

December 20, 2013

## 100+ Best Excel Books – Learning Spreadsheets

100+ Best Excel Books – Learning Spreadsheets

April 9, 2011

## How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

September 17, 2012

## The Excel Rollover Mini FAQ

The Excel Rollover Mini FAQ

February 17, 2014

## It’s time to say “Goodbye,” to Hungarian Notation

It’s time to say “Goodbye,” to Hungarian Notation