Free Excel 2003 quiz - Test Your Skills!

Linking worksheets and workbooks

The aim of this quiz is to check your knowledge of Linking worksheets and workbooks in Excel 2003.

We've detected that you don't have Javascript enabled in your browser - you can still try the Quiz, but clickable 'image map' questions won't work. Please enable Javascript and refresh this page. If you can't, you can follow this link for a version which converts image questions to multiple-choice. You may also prefer to use the multiple-choice version if you use screen reading software, like JAWS, to browse.

Please ensure that you read all questions carefully and spell all answers correctly! Once you have completed the quiz, please click the 'score my answers!' button to find out how you did.

If you like this quiz, there are plenty more where it came from! You can see the full list of subjects here.

You can learn more about our classroom, online and soft skills courses at our Happy websites.

Questions

Look at the formula below. What will this formula do?

Please select an answer...
- Add cell B10 on the current sheet to cell A2 on Sheet 2, and subtract cell D15 on Sheet 3
- Add cell B10 on the Sheet 2 to cell A2 on Sheet 2, and subtract cell D15 on Sheet 3
- Add cell B10 on the current sheet to cell A2 on Sheet 3, and subtract cell D15 on Sheet 2
- Add cell B10 on the Sheet 2 to cell A2 on Sheet 3, and subtract cell D15 on Sheet 2
You want to link two cells in different spreadsheet files. You are in the middle of the formula, and need to switch over to the other file. Which menu do you use?

Please select an answer...
- Edit
- Insert
- Tools
- Window
Look at the Excel window below. The next cell in the formula is cell D3 on Sheet 3. Where should you click next with your mouse? Click on the image below where you think you should click:

Please select an answer...

Top