Absolute Beginners Guide to Quattro Pro X3

13. Analyzing Data

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. Then, we'll combine values in different cells and create an outline in a spreadsheet.