Pengolah Angka atau spreadsheet merupakan suatu tabel nilai-nilai yang disusun dalam baris dan kolom. Microsoft Excel atau Microsoft Office Excel adalah sebuah program aplikasi lembar kerja spreadsheet yang dibuat dan didistribusikan oleh Microsoft Corporation untuk sistem operasi Microsoft Windows dan Mac. Adalah aplikasi. Diperlukan registrasi untuk mengunduh aplikasi Digsby ini di komputer, dan. Perangkat Lunak Pengolah Angka – Perangkat aplikasi pengolah angka ialah. Memiliki 95% fungsi-fungsi yang terdapat pada Microsoft Excel.
-->Summary
This article describes how to create and to use two-input tables in Microsoft Excel. These tables allow you to test how changes in two variables affect one formula.
More Information
When you create a two-input table, you specify input cells in the Row Input Cell and Column Input Cell boxes in the Table dialog box.
Note
In Microsoft Office Excel 2007, the Table dialog box is called the Data Table dialog box.
To create a simple two-input table, follow these steps:
- Create a new workbook.
- In cells B15:B19, type the following data:
Cell Value B15 1 B16 2 B17 3 B18 4 B19 5 - In cells C14:G14, type the following data:
Cell Value C14 6 D14 7 E14 8 F14 9 G14 10 - In cell B14, type the following formula:=A14*2+A15NoteA14 is the column input cell (which substitutes values 1, 2, 3, 4, and 5), and A15 is the row input cell (which substitutes values 6, 7, 8, 9, and 10). These input cells must be located outside the table; they may or may not contain data. Because this table is set up in cells B14:G19, and because A14 and A15 are outside the table, they are valid column input and row input cells.
- Select B14:G19.
- On the Data menu, click Table.NoteIn Excel 2007, click the Data tab, click What-If Analysis, and then click Data Table.
- In the Row Input Cell box, type A15. In the Column Input Cell box, type A14.
- Click OK.
You see the following results:
Note
Take cell C15 as an example. The actual values that are used in the formula are from cells B15:B19 (the row input cells) and cells C15:G14 (the column input cells). The formula with the values in it would be 1*2+6 (for a total of 8). Excel internally substitutes the values in the row and column input cells into the formula in cell B14.
0 appears in cell B14, although the cell B14 is not a number format. To duplicate the blank value in cell B14, follow these steps:
- Right-click cell B14, and then click Format Cells.
- Click the Number tab.
- In the Category list, click Custom.
- In the Type box, type ' (two quotation marks).
- Click OK.
References
For more information about how to use data tables, view the following articles:
282852 An overview of data tables in Microsoft Excel
PowerShow.com is a leading presentation/slideshow sharing website. Whether your application is business, how-to, education, medicine, school, church, sales, marketing, online training or just for fun, PowerShow.com is a great resource.
And, best of all, most of its cool features are free and easy to use.You can use PowerShow.com to find and download example online PowerPoint ppt presentations on just about any topic you can imagine so you can learn how to improve your own slides andpresentations for free. Or use it to find and download high-quality how-to PowerPoint ppt presentations with illustrated or animated slides that will teach you how to do something new, also for free. Or use it to upload your own PowerPoint slides so you can share them with your teachers, class, students, bosses, employees, customers, potential investors or the world. Or use it to create really cool photo slideshows - with 2D and 3D transitions, animation, and your choice of music - that you can share with your Facebook friends or Google+ circles. That's all free as well!For a small fee you can get the industry's best online privacy or publicly promote your presentations and slide shows with top rankings. But aside from that it's free.
We'll even convert your presentations and slide shows into the universal Flash format with all their original multimedia glory, including animation, 2D and 3D transition effects, embedded music or other audio, or even video embedded in slides. All for free. Most of the presentations and slideshows on PowerShow.com are free to view, many are even free to download. (You can choose whether to allow people to download your original PowerPoint presentations and photo slideshows for a fee or free or not at all.) Check out PowerShow.com today - for FREE. There is truly something for everyone!
Presentations for free. Or use it to find and download high-quality how-to PowerPoint ppt presentations with illustrated or animated slides that will teach you how to do something new, also for free. Or use it to upload your own PowerPoint slides so you can share them with your teachers, class, students, bosses, employees, customers, potential investors or the world. Or use it to create really cool photo slideshows - with 2D and 3D transitions, animation, and your choice of music - that you can share with your Facebook friends or Google+ circles. That's all free as well!For a small fee you can get the industry's best online privacy or publicly promote your presentations and slide shows with top rankings.
But aside from that it's free. We'll even convert your presentations and slide shows into the universal Flash format with all their original multimedia glory, including animation, 2D and 3D transition effects, embedded music or other audio, or even video embedded in slides. All for free. Most of the presentations and slideshows on PowerShow.com are free to view, many are even free to download. (You can choose whether to allow people to download your original PowerPoint presentations and photo slideshows for a fee or free or not at all.) Check out PowerShow.com today - for FREE. There is truly something for everyone!