[ Pobierz całość w formacie PDF ]
.com - Internet: http://www.cctglobal.com/ Security and Proofing within Excel 79Excel 2000 Advanced ©1995-2000 - Cheltenham Computer TrainingExcel 2000 Auditing Tools" The audit feature allows you to detect problemswhich may occur in your worksheet formulas" The toolbar can be displayed by selectingToolbars from the View menu to display theToolbars menu and then selecting Customize" Click on the Toolbars tab and select the checkbox next to Auditing in the Toolbars list box andthen select Close© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.46Excel 2000 Auditing ToolsNew Comment Will display the Cell Note dialog box to enable you to attach text oraudio comments.Remove All Will delete all arrows from an active worksheet.ArrowsSAMPLE ONLYRemove Will delete dependent tracer arrows from an active worksheet.Dependent ArrowsRemove NOT TO BEWill delete the precedent tracer arrows from an active worksheet.Precedent ArrowsTrace Dependants Arrows are drawn from the active cells to cells containing formulaswhich use the values in the active cell (dependants).USED FORTrace Error Will draw an arrow from cells which may have caused an error to anerror value in an active cell.TRAININGTrace Precedents Arrows are drawn from all cells which supply values directly to theformula in the active cell (precedents).SAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ 80 Security and Proofing within Excel1995-2000 - Cheltenham Computer Training© Excel 2000 AdvancedAuditing Worksheets" You can use tracers to find precedents,dependents, and errors in any cell in a worksheet" Precedents Cells which are referred to by a formula" Dependents Cells which contain formulas which refer to other cells" You must ensure that the Hide All option buttonis not selected before using tracers© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.47Auditing WorksheetsTo use tracers to You can use tracers to find precedents, dependants and errors in any cell in aaudit a worksheet worksheet." Precedents - Cells which are referred to by a formula." Dependants - Cells which contain formulas which refer to other cells.SAMPLE ONLY" You must ensure that the Hide All option button is not selected before usingtracers.From the Tools menu, choose Options and click on the View tab.The Hide All option button in the Objects area should be white (notselected)." Choose OK to exit.NOT TO BETo trace the " Highlight a cell which contains the formula you wish to trace.precedents of a" From the Tools menu, choose Auditing Trace Precedents or click on thecellTrace Precedents icon on the Auditing toolbar.Tracer arrows will bedisplayed.Solid or blue arrows indicate direct precedents of a selectedformula; dotted or red arrows indicate a formula which refers to error values;USED FORdashed arrows with a spreadsheet icon refer to external worksheets." Whilst working with tracers you can click on the Remove All Arrows icon toremove all the tracers, or click the Remove Precedent Arrows icon on theAuditing toolbar to remove one level of precedents at a time.To trace the " Highlight the cell (which should be referenced in a formula) you wish to trace.TRAININGdependants of a" From the Tools menu, select Auditing Trace Dependants or click on thecellTrace Dependants button on the Auditing toolbar.Tracer arrows will bedisplayed, with blue or solid arrows indicating dependants of the selectedformula." Whilst working with tracers you can click on the Remove All Arrows button toremove all the tracers, or click the Remove Dependent Arrows button on theAuditing toolbar to remove one level of dependants at a time.SAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ Security and Proofing within Excel 81Excel 2000 Advanced ©1995-2000 - Cheltenham Computer TrainingTo trace errors in " Highlight a cell which contains an error value: #DIV /0!, #N/A, #NAME?,a cell #NULL!, #NUM!, #REF!, #VALUE!." From the Tools menu, choose Auditing Trace Error, or click on the TraceError button on the Auditing toolbar.Tracer arrows will be displayed,pointing to the cells.Dotted or red arrows - indicate that the first precedent formula contains an error.Solid or blue arrows - indicate that precedents of the first formula are producingan error." On the Auditing toolbar, click the Remove All Arrows button, or selectAuditing Remove All Arrows from the Tools menu.SAMPLE ONLYNOT TO BEUSED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ 82 Security and Proofing within Excel1995-2000 - Cheltenham Computer Training© Excel 2000 AdvancedCell Notes and Documentation" A useful means of documenting the spreadsheet© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.48Cell CommentsBackground It is vitally important that complex worksheets are properly documented.This meansthat you will still be able to understand what you have done a month from now, andother people will easily understand any clever bits you have devised.One of thechanges made within Excel 2000 is that cell notes now pop-up when you hold themouse over cells that contain them.SAMPLE ONLYTo add a " Select the cell to which you want to add the comment.comment" From the Insert menu, choose Comment to display the Cell Note dialog box." Enter the text in the Text Note box." Click outside the box when finished.NOT TO BEUSED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal
[ Pobierz całość w formacie PDF ]
