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 basics
Office quiz logo
Are you up to speed on Microsoft Excel 2002? If you're an ace, here's your chance to show it. If you're still discovering how powerful it is, here's another way to get sharper. Take this quiz 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. Which do you press to enter the current date in a cell?
 
a.
b.
c.
 
2. A fast way to add up this column of numbers is to click in the cell below the numbers and then:

Column of numbers on a worksheet

 
a.
b.
c.
 
3. Suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

Worksheet column headings on two pages of printout

 
a.
b.
c.
 
4. How should you print a selected area of a worksheet, if you'll want to print a different area next time?

Worksheet with adjacent cells marked as selected

 
a.
b.
c.
 
5. What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

Worksheet column with numbers 1 and 2 in two rows

 
a.
b.
c.
 
6. If you are working in English (U.S), Chinese, or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
 
a.
b.
c.
 
7. Say that you want to paste a formula result — but not the underlying formula — to another cell. In Excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
 
a.
b.
c.
 
8. How do you change column width to fit the contents?

Worksheet column too narrow to show full heading

 
a.
b.
c.
 
9. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
 
a.
b.
c.
 
10. To balance your checkbook in Excel, your best method is:
 
a.
b.
c.
 
advertisement