Module D (Office 2010 Version) - Decision analysis with spreadsheet software. This chapter define a list and a list definition table within the context of spreadsheet software and describe the importance of each, compare and contrast the Filter function and Custom Filter function in spreadsheet software, describe the purpose of using conditional formatting, define a pivot table and describe how you can use it to view summarized information by dimension, describe the purpose of using Goal Seek.