Microsoft Office Tutorials and References
In Depth Information
Examining data by using the
Excel also provides the tools to determine the input values that would be required for a
formula to produce a specified result. For example, the chief operating officer of Consolidated
Messenger, Lori Penor, could find out to what level the revenues from three-day shipping
would need to rise for that category to account for 25 percent of total revenue.
In this chapter, you’ll examine data by using the Quick Analysis Lens, define alternative data
sets, and use different methods to determine the necessary inputs to make a calculation
produce a specific result.
PRACTICE FILES To complete the exercises in this chapter, you need the practice files
contained in the Chapter08 practice file folder. For more information, see “Download
the practice files” in this topic’s Introduction.
Examining data by using the
Quick Analysis Lens
One of the refinements in Excel 2013 is the addition of the Quick Analysis Lens, which
brings the most commonly used formatting, charting, and summary tools into one
convenient location. To examine data by using the Quick Analysis Lens tools, select the data you
want to summarize. When you select a range, Excel displays the Quick Analysis button in
the lower-right corner of the range. Clicking the Quick Analysis button displays the tools
you can use to analyze your data.
KEYBOARD SHORTCUT Press Ctrl+Q to display the Quick Analysis Lens tools. For a complete
list of keyboard shortcuts, see “Keyboard shortcuts” at the end of this topic.
Search JabSto ::

Custom Search