Which of the following are ways you can add the contents of a Microsoft Office Excel 2003 worksheet to your SharePoint site?
-
From your SharePoint site, on the Create page, under Custom Lists, click Import Spreadsheet, and then specify the Excel worksheet to convert to a list.
-
From Excel, convert the worksheet data to a list, and then use the Publish List command to save it as a list on your SharePoint site.
-
From a document library on your SharePoint site, use the Upload Document command to add the Excel worksheet to your document library.
-
All of the above.
SharePoint provides multiple methods to incorporate Excel worksheet data. All three options are valid: importing spreadsheets via the Create page converts Excel data to SharePoint lists, publishing from Excel using the Publish List command, or simply uploading worksheets to document libraries. Option D correctly captures that all these methods work.
"All of the above" is correct — Excel 2003 worksheet data can be brought into a SharePoint site via any of the three listed routes: importing a spreadsheet as a custom list from the site's Create page, using Excel's "Publish List" command (via the List/Export Range wizard) to push a worksheet range to SharePoint as a list, or simply uploading the .xls file itself into a document library. Since all three are legitimate, documented methods, no single one is the exclusively correct answer.