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!

• 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