1 / 12

IS-171 Computing With Spreadsheets

Learn about more formatting tools, auditing, and decision-making techniques in spreadsheet computing. Explore formula auditing, data validation, reviewing, and protection features.

menaa
Download Presentation

IS-171 Computing With Spreadsheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IS-171Computing With Spreadsheets Formula Auditing and Decision Making Tools Week 6

  2. Outline • More Formatting Tools • Auditing • Decision-Making Helps Carol Wilson and Fred Ferwerda

  3. More Formatting - Demo • Comments • Conditional Formatting • Rotating and Shading Text • Style Carol Wilson and Fred Ferwerda

  4. Auditing • Formula Auditing • Data Validation • Reviewers • Protection Carol Wilson and Fred Ferwerda

  5. Formula Auditing • The formula auditing toolbar allows the developer to determine both precedents and dependents of a cell. • Precedents are the cells that provide data to a formula in the current cell . • Dependents are the formula cells that use (reference) the current cell. • You may also Evaluate a formula Carol Wilson and Fred Ferwerda

  6. Data Validation • The Data Validation command allows the developer to restrict the values that may be entered in a cell. • For example, you can specify that a numeric value be between 0.0 and 1.0 (i.e. between 0% and 100%) Carol Wilson and Fred Ferwerda

  7. Reviewers • Have others review your spreadsheet. • Make use of Excel’s ability to create a shared workbook – one that is accessible to multiple users. • Shared workbooks may be modified via tools on the Reviewing toolbar or via the Track Changes command. Carol Wilson and Fred Ferwerda

  8. Protection • Protected worksheets allow users to modify only a limited number of cells • You must first specifically unlock those cells you want to allow the user to change • Then you must protect the worksheet. The unlock is ‘stronger’ than the protect – odd • You can later unprotect the worksheet if you’d like, and lock/unlock the cells Carol Wilson and Fred Ferwerda

  9. Demo • Formula Auditing – Precedents • Formula Auditing – Dependents • Evaluating a Formula • Tracking Changes • Unlocking Cells • Protecting a Worksheet Carol Wilson and Fred Ferwerda

  10. Decision-Making • Goal Seek (discussed in Chapter 3) • Consolidating Data (Chapter 7) • Solver add in (Appendix B) • Scenario Manager Carol Wilson and Fred Ferwerda

  11. Scenario Manager • Scenario Managerenables you to specify, and to view, multiple sets of assumptions (scenarios). • Scenario Summarycompares the effects of the different scenarios to one another by displaying result cells. Carol Wilson and Fred Ferwerda

  12. Demo • Naming Cells • Creating Scenarios Carol Wilson and Fred Ferwerda

More Related