Microsoft Excel Templates Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Manage Interoperability with Other Services

What you'll be asked

  1. What is the primary file extension used to save a standard Microsoft Excel template?
  2. When you modify a file that was created from a template, what happens to the original template file?
  3. Why would a developer choose to save an Excel template as an .xltm file instead of an .xltx file?
  4. A team needs to share a custom template across an organization. Where should the template be saved so it appears in the 'Personal' or 'Custom' tab when users click 'New' in Excel?
  5. If you are designing a template that must pull data from an external SQL database via Power Query, which setting is critical to ensure the end-user can refresh the data without breaking the template's integrity?

Answers and explanations come after you submit.