# 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.

Tags

#### You may also like

December 28, 2015

## What Function Helps You Determine Monthly Loan Payments – Excel Challenge

What Function Helps You Determine Monthly Loan Payments – Excel Challenge

November 22, 2015

## “Everyday” Random Shuffling with Formulas

“Everyday” Random Shuffling with Formulas

December 22, 2015

## Using Named Formulas In Excel – Like Yesterday()

Using Named Formulas In Excel – Like Yesterday()

June 25, 2015

## Convert Function In Excel – Video Tutorial

Convert Function In Excel – Video Tutorial

December 4, 2015

## VLookup To The Left With The Choose Function – Excel Tips

VLookup To The Left With The Choose Function – Excel Tips

May 7, 2019

## Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV

Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV