Skip to main content
  • 1613 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 44.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Rights and permissions

Reprints 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

Publish with us

Policies and ethics