Test on Excel 2007 Basics

I have an Excel 2003 file that uses the range names "Qtr1", "Qtr2" and "Qtr3". Why does my file produce incorrect results in Excel 2007?

The range A2:C12 has consistent cell background and font formatting across all cells. Why do some cells appear different?

When you change the color scheme in Excel 2007, what will be affected?

What do these little green icons on the Excel Recent Documents list menu mean?

The headings for columns A, B and C have been changed. How has this been done?

(i) Why do these dots show in the Name Box and (ii) what can you do about it?

Why is there such a big gap between the Ribbon and Excel cells?

What has happened to Excel?

The Developer Ribbon is hidden by default. Where would you go to make it visible?

What formula would you enter in B16 to show the total for just the person selected on only the date entered?


There are 10 questions in test, all related to Excel 2007 basic level. For your own benefit, try to complete the exam with Excel (and its online help) closed.

Even if you don't know the answers, have a guess anyway ... we'll tell you all the answers anyway, and you might learn something!



I got 5/10 at first test. I must work. :)

68 days 9 hours 43 minutes ago


at first I got 5/10 today and now did it again hahaha I got 2/10

77 days 2 hours 43 minutes ago

Joan Hackett

I can't believe my score I really need to study as much as I can. excel I really through I knew this. but I guess I didn't I have a test next week I guess I better study my butt off. which study for excel it so much involve with this. I just hope I pass my test. do anyone have anything that can help me with excel.

153 days 5 hours 40 minutes ago

Lisa Sigona

Wow, I thought I knew Excel - guess I have a lot to learn!

208 days 9 hours 29 minutes ago


Microsoft is illogical

352 days 12 hours 38 minutes ago

Niika Ted

I enjoyed the test, it showed me where my skills stand and shined light on what I need to improve upon.

611 days 14 hours 53 minutes ago


In English please!!!

699 days 3 hours 17 minutes ago

Ihead Go

Found a site (http://www.iheadgo.com) that offers tons of practice exams for multiple subjects. They offer practice exams for almost anything possible. Check it out.
Checking out this site and looks interesting...a lot of different Exams TI.

748 days 6 hours 3 minutes ago


Did anyone else notice that ? 7 has the same answer for c and d and so does one of the other ?s

849 days 2 hours ago


This tests are challenging but easy we need something more difficult

1010 days 3 hours 48 minutes ago

CoachExcel .
Microsoft Excel Solutions and Training

Your Facebook Friends on WizIQ

More Tests By Author

Test your Excel Knowledge UPDATED !
10 Questions | 14921 Attempts

Test your Excel Knowledge
10 Questions | 4144 Attempts