In This Chapter
• Sorting list information
• Filtering list information
• Transposing row and column information
• Asking “What If?”
• Combining data in a spreadsheet
As you learned in Chapter 12, “Setting Up a Database in Quattro Pro,” a database is a collection of similar information like your local telephone book. In this chapter, you’ll learn how to sort and filter the information in a Quattro Pro database, and then we’ll touch on some of the other analysis tools available in Quattro Pro that are not necessarily related to a spreadsheet database. I’ll show you how to transpose information in rows and columns and then we’ll explore using the What-If Expert to see what happens if you substitute different values into a formula. ...