Question

This is a graded discussion: 100 points possible due- 1 Week 5 Discussion Board Excel can provide data analysis when you need to evaluate multiple conditions within one formula. One such example includes using nested statements. Someone might attempt to explain nested statements toa friend by giving the example of a Russian nesting doll, wherein different pieces of the function fit together to create one formula that yields a specific result. There is a learning principal that states that being able to explain a topic to someone using non technical terms or an analogy demonstrates a true understanding of that topic. With that being said, select a function in Excel that has been covered in the course to date and share with the class how you would explain that function to someone who is unfamiliar with Excel. Try not to explain how it works in Excel technically or how to perform the function, but relate it to something that can be easily understood, like the aforementioned Russian nesting doll analogy. Be creative and have fun! Search entries or author Unread Subscribe Reply Samantha Hardin 10:49am

Answer 1

The function that I have selected is “IF” function. The “IF” function determines whether a condition is met or not. This function allows the user to make logical comparisons between a value and between what is expected.

It is a logical function and determines if a condition is true or not. If function can be compared to a judge or a jury which determines if a condition is true then what should be the verdict. So for instance if the facts of the case points that a defendant is guilty then the court will announce a punishment for the defendant else the court will pronounce the defendant not guilty.