RAND / RANDBETWEEN (see note below)INT --> ROUND / ROUNDUP / ROUNDDOWN (see note)COUNT & COUNTBLANKSUMAVERAGEMIN & MAXMODE & MEDIANQUARTILESTDEVRANKTOPIC NOTES: The RAND() & RANDBETWEEN() functions will be used very often in class and are intended for you to use in your own practice outside of class, but you will not use these functions to compose any solution to any problem on the assessments you will complete in this course.We will use the INT() function in a demonstration to derive the ROUND() family of functions. Thereafter, you should use the ROUND/UP/DOWN functions to mathematically round values to specified numbers of decimal places, avoiding the complexity of using the INT() function to do those things.TOPIC NOTES:Do not use the LARGE() or SMALL() functions in place of the MAX() or MIN() functions, respectively. Though they are functionally equivalent, they are not computationally equivalent.For this course, you will always be safe using the legacy versions of functions when there are more evolved options available. For instance, just use the STDEV() function instead of STDEV.S(), etc.Do not use the DAYS() function to calculate the number of days between two dates. All this is, is simple subtraction.text-related functions: Concatenation (adding text strings together using the "&" operator)LENTRIMSEARCH / FINDSUBSTITUTELEFT / RIGHT / MIDUPPER / LOWERUse the SUM() function for adding a bunch of values; do not use it for adding just two or three values. (Using the "+" sign is less typing anyway!)

Without Critical Thinking Assignments this week, this is your opportunity (and a requirement) to work on your Portfolio Project. Obtain the supporting information from your Portfolio Project option. You will also use the Schedule A template included under that same option.Show all calculations within the cells of the template. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well; no hard coding of solutions. Submit a single MS Excel file for grading.Review the Portfolio Project Milestone Rubric in the Module 5 Materials folder to understand how you will be graded on the project. You must address instructor feedback when submitting your complete Portfolio Project during week 8.The deliverable is as follows:The completed Form 1040-Schedule A template.

Why is corporate social responsibility an important and sometimes controversial construct? When and why should social responsibility be an organizational value? When is it not appropriate for social responsibility to be an organizational value? Why? How can social responsibility create value for an organization? How can it create a liability for an organization?