tailieunhanh - beginning excel what if data analysis tools phần 2

Dữ liệu bảng: bảng dữ liệu là một bộ sưu tập của các tế bào đó sẽ hiển thị như thế nào thay đổi giá trị nhất định trong công thức bảng tính ảnh hưởng đến kết quả của những công thức áp dụng. Các bảng dữ liệu cung cấp một phím tắt cho tính toán nhiều phiên bản trong | xx INTRODUCTION Data tables A data table is a collection of cells that display how changing certain values in worksheet formulas affects the result of those applied formulas. Data tables provide a shortcut for calculating multiple versions in one operation and a way to view and compare the results of all of the different variations together on your worksheet. Using the bicycle example again you could create a table that summarizes the number of miles traveled at different speeds and different elapsed minutes traveled. Scenarios. Excel can save a set of values and substitute them automatically in a worksheet to allow you to forecast the outcome of a worksheet model. You can create and save different scenarios on a worksheet and then switch to any of these scenarios to view different results. For the bicycle example you could switch between two or more different number of miles traveled using combinations of different speeds and elapsed minutes traveled. Solver Using Solver you can find an optimal value for a formula in a target worksheet cell. Solver works with a group of cells related to a target cell s formula. Solver changes the values of adjustable cells to produce the desired result you specify in the target cell formula. You can also apply upper lower and exact constraints to restrict the values Solver can choose from to adjust the cells. Using the bicycle example again you could determine the least and greatest possible number of miles traveled at a given speed and distance. Here s a summary of when you would use each of these tools Use Goal Seek when you want to find the correct single input value to achieve the desired single output value. Use data tables when you want to display the effect of one or two variables on one or more formulas in table format. Use scenarios when you want to create change and save a number of different sets of values and formulas that each produces different results. Use Solver to find the best solution to problems that revolve .