In this project, you will update a workbook to display bank transactions as a pivottable. you will filter the pivottable, format the values, display the values as calculations, and create a pivotchart using this data. additionally, you will sort and subtotal data, create data tables, and use goal seek and scenario manager. you will format grouped worksheets, set up validation rules, and create functions. you will also import a text file and xml data and manipulate the imported text. finally, you will modify the document properties, insert a comment, and mark the workbook as final.

1. start excel. open exploring_ecap_grader_c2_transactio ns. xlsx and save the workbook as exploring_ecap_grader_c2_transactio ns_lastfirst.

Assume that two parallel arrays have been declared and initialized: healthoption an array of type char that contains letter codes for different healthcare options and annual cost an array of type int. the i-th element of annual cost indicates the annual cost of the i-th element of healthoption. in addition, there is an char variable, best2.write the code necessary to assign to best2 the health option with the lower annual cost, considering only the first two healthcare options. thus, if the values of healthoption are 'b', 'q', 'w', 'z' and the values of annualcost are 8430, 9400, 7050, 6400 your code would assign 'b' to best2 because 8430 is less than 9400 and is associated with 'b' in the parallel array. (we ignore 'w' and 'z' because we are considering only the first two options.)