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,
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!
- 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