Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Icon: Flag: (c) Microsoft
Get up to speed
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Quiz: Scientific charts in Excel 2003: Trendlines
Office quiz logoAfter you get your data plotted on a chart, you can use a trendline to see if there is some underlying relationship or trend to be found in your data.

Content in this quiz was excerpted from Training on Microsoft Office Online.

Extend yourself with self-paced training for the 2007 Microsoft Office system
Office Online Training logo
See all Office quizzesE-mail this quiz
1. When would need need a trendline?
 
a.
b.
c.
d.
 
2. You can only add linear trendlines in Excel charts.
 
a.
b.
 
3. You want to plot a chart of Pressure against Volume. Which sort of chart should you use?
 
a.
b.
c.
d.
 
4. To investigate what happens to your trendline beyond your data range you can use:
 
a.
b.
c.
 
5. What is R²?
 
a.
b.
c.
d.
 
advertisement