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
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
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: Excel formulas
Office quiz logo
How well do you know formulas and functions in Microsoft Excel 2002? Answer these 10 questions to rate your Excel skills — and to improve them.
Download a free trial of Office 2007—and get access to training courses
Office Online Training logo
See all Office quizzesE-mail this quiz
1. Got functions? No? You need the Insert Function dialog box. How do you get it?
 
a.
b.
c.
 
2. Which function converts miles to kilometers, kilograms to pounds, and so on?
 
a.
b.
c.
 
3. To save $60,000 in 18 years, which function could calculate how much to save each month to end up with that amount?
 
a.
b.
c.
 
4. What does the SUMIF function do?
 
a.
b.
c.
 
5. You can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?
 
a.
b.
c.
 
6. Which function calculates depreciation at the same amount each year over an asset's useful life?
 
a.
b.
c.
 
7. What does the VLOOKUP function do?
 
a.
b.
c.
 
8. Which function calculates your monthly mortgage payment?
 
a.
b.
c.
 
9. The LEN function does what?
 
a.
b.
c.
 
10. Which function will calculate the number of workdays between 6/9/2004 and 8/21/2004?
 
a.
b.
c.
 
advertisement