Tạo một bảng dữ liệu Nếu bạn quan tâm đến việc học tập hiệu quả một loạt các giá trị đã vào công thức, bạn có thể thiết lập một bảng dữ liệu. Đây là một bảng bao gồm các công thức mà bạn đang sử dụng, và các giá trị đầu vào cho nhiều công thức | Create a Data Table If you are interested in studying the effect a range of values has on the formula you can set up a data table. This is a table that consists of the formula you are using and multiple input values for that formula. Excel automatically creates a solution to the formula for each different input value. Do not confuse data tables with the Excel tables that you learned about in Convert a Range to a Table. A data table is a special range that Excel uses to calculate multiple solutions to a formula. Create a Data Table .__ 1 Type the input values To enter the values in a column start the column one cell down and one cell to the left of the cell containing the formula as shown here. To enter the values in a row start the row one cell up and one cell to the right of the cell containing the formula. 2 Select the range that includes the input values and the formula. 3 Click the Data tab. 4 Click What-If Analysis . 5 Click Data Table. Analyzing Excel Data CHAPTER 10 The Data Table dialog box appears. 0 Specify the formula cell you want to use as the data table s input cell If the input values are in a column enter the input cell s address in the Column input cell text box. If you entered the input values in a row enter the input cell s address in the Row input cell text box. 7 Click OK. Excel displays the results. The technique called what-if analysis is perhaps the most basic method for analyzing worksheet data. With what-if analysis you first calculate a formula D based on the input from variables A B and C. You then say What happens to the result if I change the value of variable A What happens if I change B or C and so on. When I try to delete part of the data table I get an error. Why The data table results are created as an array formula which is a special formula that Excel treats as a unit. This means that you cannot move or delete part of the results. If you need to work with the data table results you must first select the entire results range.
