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: Error bars and Complex curves
Office quiz logo
Do you know how to add error bars to show the range of error for each data point on a chart? Or can you plot a complex curve? Take this quiz to test your scientific charting skills.

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

Download a free trial of Office 2007—and get access to training courses
See all Office quizzesE-mail this quiz
1. Why would you use error bars?
 
a.
b.
c.
d.
 
2. If you have a trendline that doesn't go through all the error bars, what should you do?
 
a.
b.
c.
d.
 
3. You can't add error bars to individual data points, you have to add them to a whole data series.
 
a.
b.
 
4. What is an advantage of using Excel to plot curves?
 
a.
b.
c.
 
5. You can plot 3–D coordinates in Excel to explore three-dimensional relationships.
 
a.
b.
 
advertisement