graphs Goal Seek functionality is where you can provide the desired output

Graphs goal seek functionality is where you can

This preview shows page 2 - 6 out of 9 pages.

graphs)°°Goal Seekfunctionality is where you can provide the desired output value for a cell and also the input cell that may be varied to get the desired value°°When information is supported by evidence, the information is believable°°Information overloadis having more information than what you can effectively process°°In business, good quality information reduces uncertainty°°When evaluating Information:
Background image
UsefulBelievableRelevantAppropriatecurrentCredibleObjectiveSupportedComprehensive°°Consistent formatting and formulas can be maintained across multiple worksheets by using worksheet grouping
Background image
°°The excel function “if” will be required to compute bonus payout°°Collaborative consumptionand sharing economyare terms used to describe the appearance of new marketplaces where excess capacity in goods and services can be shared efficiently using information technology°°Questions related to online talk with Rachel Botsman:According to Rachel Botsman, collaborative consumption such as that provided by airbnb is possible due to trust enabled by technology°Rachel Botsman suggests that to allow for transactions between strangers there is need for technology to aggregate their reputation capital°°Four techniques to audit your worksheet for correctness:Identify direct and indirect precedent cells that are necessary for the data in the current celloCan identify the cells depended on by a certain cellIdentify direct and indirect dependent cells that depend on the data in the current celloCan help identify the cells that directly and indirectly depend on the dataShow all formulasoAbility to view all formulas in the sheet togetherEvaluate formulas (step-by-step) for correctnessoVerify the step-by-step computations in a given formula°°The cell containing March sales of beverageswould not be a precedent cell for computing the march sales for beverages
Background image
°°*Read lecture 9 scenario*°A website of a bank that allows account holders to view their current
Background image
Image of page 6

You've reached the end of your free preview.

Want to read all 9 pages?

  • Spring '16
  • World Wide Web

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes