Summary
In this chapter, you learned how to create and use data tables, which can display the results of multiple formula calculations in an easy-to-use lookup table format. You also learned how to organize worksheet cell values to make it easy to create data tables by using the Table dialog box to specify a data table’s row and column input cells. You practiced creating data tables by working through three Try It exercises. Finally, you learned about some common problems that may arise when you create data tables and how to fix them.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2006 Paul Cornell
About this chapter
Cite this chapter
(2006). Data Tables. In: Beginning Excel What-If Data Analysis Tools. Apress. https://doi.org/10.1007/978-1-4302-0098-7_2
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0098-7_2
Publisher Name: Apress
Print ISBN: 978-1-59059-591-6
Online ISBN: 978-1-4302-0098-7
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)