Question: 9. The embedded data includes an incorrect amount. In cell C26, edit the embedded data to use 25% as the co-payment amount for POS plans.

9. The embedded data includes an incorrect amount. In cell C26, edit the embedded data to use 25% as the co-payment amount for POS plans. 10. Ashanti also has a text file that lists the additional charges employees are required to pay for each type of plan. Import the Text/CSV file Support_EX365_2021_EOM7-2_Required.csv. Choose to load the data to a location in the worksheet. View the imported data as a table and insert the data in cell H5 of the existing worksheet. 11. Apply the Purple, Table Style Medium 6 table style to the imported table to coordinate with the rest of the worksheet contents, and then format the range I6:L7 in the Currency number format. 12. Ashanti originally inserted the HSA plan data as a link to another Excel workbook. She asks you to update the data and then remove the link. Display the links to external files, and then update the values from the workbook Support_EX365_2021_EOM7-2_HSA.xlsx. Break the link to the Support_EX365_2021_EOM7-2_HSA.xlsx file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!