# Volatile Functions in Excel – Excel Challenges

Hello everyone! Hope you all are having a great day. MVP Jordan Goldmeier is still in a flow to test you in Excel functions. But, as you all know, let us look at previous week’s Excel challenge before getting in to this week’s challenge.

## Last Week’s Challenge

Last week’s challenge was “Which of the following functions can be used in a simple formula to determine how many weekdays there are in any calendar month?” We also have options for this. Hope you all answered this correct. Let us look at the correct answer and also the winner.

## Correct Answer For Last Week’s Challenge

Correct answer for last week’s challenge is NETWORKDAYS. Many of you got the answer correct and there are more winners. Jordan added that free ModelOFF registrations went out to several winners this week! So, you are requested to check out winners in Facebook page.

Which is the Volatile Excel function?

This week’s Excel challenge is “Which of these functions is a volatile function in Excel?” Here are the options,

1. MATCH
2. ROWS
3. AREAS
4. INDIRECT

So, send us the correct option as A, B, C or D. You can even specify the function name directly.

## Hurry Up To Answer

Go ahead and comment your answer in Excel TV blog post or Excel TV Challenges forum at VBAExpress.com or Facebook (facebook.com/ExcelTVSeries) or comment on the video. You can even tweet to @ExcelTV or leave a comment below.  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
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

## Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.