October 26

Volatile Functions in Excel – Excel Challenges

0  comments

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

51: Oz du Soleil & the Global Excel Summit 2021

51: Oz du Soleil & the Global Excel Summit 2021

Global Excel Summit 2021

Global Excel Summit 2021
{"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.

>