Simon and pedro are working together on a science experiment. they collect and record their data in excel spreadsheets. they save their data as a web page and post it on their shared internet site. simon’s data is not updating. he followed the steps below when saving his excel spreadsheet.

step 1: on the file menu, click save as
step 2: select “web page” from the “save as type” box
step 3: select publish
step 4: select the “open published web page in browser” check box
step 5: click publish

which step was incorrect?

step 1: simon should have selected print and printed the spreadsheet as an htm file.
step 2: simon should have selected “excelworkbook” from the “save as type” box.
step 3: simon should have selected save instead of publish.
step 4: simon should have selected autorepublish.