1. In the professional world of accounting, working with Excel workbooks will be an integral aspect of your day to day duties. Unfortunately, you will eventually open a workbook to find everything hard-coded and not know where any of the numbers came from! Imagine being told to finish a tax return or audit workbook; however, upon opening the file all the numbers are directly typed into the fields without any indication of where the date was gathered from.

With this aforementioned scenario laid out, please discuss the advantages/disadvantages of hard-coding values (the situation explained above) into Excel vs linking cells to dependent cells in Excel.