ITKE Community Blog

Jan 4 2013   9:14PM GMT

IT pop quiz: What do you know about Microsoft Excel?

Michael Tidmarsh Michael Tidmarsh Profile: Michael Tidmarsh

Quiz image via Shutterstock

A new semester is about to start for many students but it’s time for another pop quiz for our ITKnowledgeExchange community on Microsoft Excel! See if you can answer any (or all) of the questions below and we’ll give out 100 Knowledge Points for each approved answer. Good luck!

  1. How can a user download data from SAP to Excel using pivot tables? 
  2. How can you keep symbols and numbers together in an Excel column when wrapping text
  3. Is there a way to open Excel and Word files without the ‘read only’ screen?
  4. Can a user keep the same formatting when transferring a report from Oracle Reports 11g to Excel?
  5. What do you need to do when exporting data from SSIS to Excel?
  6. How can a user overcome the ‘Could not find installable ISAM error’ in Microsoft Excel 2007?
  7. How do you incorporate combo boxes into a Microsoft Excel file? 
  8. While having two interlinked Excel workbooks, does a user have to put the same password in for each one?
  9. Is there way to implement conditional formatting for tracking schedules?
  10. How does a user copy and paste data into a cell without the previous chart disappearing? 

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: