IT 206 Week 3 Dq 2 - 7755

Solution Posted by
3number
Solution Detail
Price: $2.00
  • From: ,
  • Posted on: Fri 13 Apr, 2012
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

The versatility of Microsoft Excel allows for a user to be able to change data at any given moment as well as to be able to track changes if the changes that are made effect other cells of information.  This versatility allows for an enhanced amount of application support because there is so many different ways to accomplish the same task.  If a user wishes to calculate the different values inside a row of cells, they can assign a cell to auto-calculate the cells that are needed.  Or the user can have Excel do the mathematics that are needed and then apply the correct answer themselves if they wish the cell's answer to remain static.

This versatility can also be a burden when it comes to troubleshooting a problem.  There are so many elements that are involved in creating a successful formula that there are many different different possible solutions to every problem.  The answer to a particular problem can be in the raw data that is entered, the problem could also be in the formula that was used to arrive at the answer, it could also be in the placement of the information inside the worksheet.  When a user is compiling large amounts of data, it is important to go slowly and double check all information, as well as ensure proper placement.  This will also help with any troubleshooting that may occur.

Solution Description

The versatility of Microsoft Excel allows for a user to be able to change data at any given moment as well as to be able to track changes if the changes that are made effect other cells of information.  This versatility allows