write:The Formula Auditing group enables you to check the worksheet for errors and accuracy. It also enables you to display the actual formula in the cells instead of the formula result.

THE VIEW TAB & WORKBOOK SECURITYModule Four : Spreadsheets (MS Excel 2016)THE FORMuLAS TABIn the previous session
you learnt about the Function Library group of the Formulas tab. In the following section
you will learn about the Formula Auditing group of the Formulas tab.FORMuLA AuDITING GROuPWhen Excel 2016 cannot properly evaluate a formula or a function
it displays an Error. The Formula Auditing group enables you to check the worksheet for errors and accuracy. It also enables you to display the actual formula in the cells instead of the formula result.SHOW FORMuLASFormula results are shown in the worksheet cells
while the formulas are visible in the formula bar. The Show Formulas command is used to display the actual formula or function applied to a cell instead of the resulting value. Showing formulas in the cells makes it easy to find the cells that contain formulas or to check for errors.To Show Formulas in the cells
1 Click on the Show Formulas command in the Formula Auditing group.A Formulas are displayed in the cells instead of the results.You can use the keyboard shortcut Ctrl + ~ (grave accent key-above the Tab key) to quicklyswitch between formulas view and their results.TIPLEARNING1A