I don't think I've heard anyone get correct technical advice from anyone at Best Buy..but anyway..
The Airport you bought, assuming it's the Express, can only extend a wireless network created by another Apple router (either the Airport Express or Airport Extreme). It will not extend any other router's network.
I currently have a FiOS router in the basement with it's wireless turned off, an Airport Extreme connecting to it with a wire and creating a wireless network that is being extended throughout my house by an Airport Express on the 1st floor..
if you do have all Apple routers, you need to use Airport Utility and connect to the Airport Express, for example, and there will be an option to "Extend this network" when it sees the network created by another Apple router..