In Excel there are numerous formatting options¬†available to customize the look and feel of your workbook. These formatting make your content easier to understand. These formatting include number format, cell…