Page 13 of 14PREVNEXT

SharePoint lists VII: Handy tips and tricks

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


You want to create a list based on an Excel spreadsheet. In step 1 of 2 in Excel’s Publish dialog box, what would you enter for the Address?

The URL for the list.

The URL for the list items.

The URL for the site that you want the list to be on.

The name that you want the list to have, for example, “Sales Data.”

If you modify a view to include the Edit (link to edit item) column, what will happen?

A new column will appear, containing a handy Edit button to click.

A new column will appear, containing the text “Link” which you can use to edit an item.

A link will be added to the Title of the item, allowing you to click it and edit.

A pop-up menu will appear over the Title of the item. On that menu, there will be an Edit command.

If you wanted users to be able to use pictures, tables and hyperlinks in their list items, which of the following setting would you need for that column?

Rich text

Enhanced rich text

Super enhanced rich text

Plain text

How do you save a list as a template?

Go to List Settings, and then click Save list as template.

Go to List Settings, click Advanced settings, and then click Save list as template.

Go to Site Actions, and then click Save list as template.

Go to List Settings, click Validation settings, and then click Save list as template.

Page 13 of 14PREVNEXT