Sort
Insert formulas
Highlight information
Insert Charts
Rename Sheets
Protect fields
Embedded Files
Make a copy of this practice SHEET
Sort column A ‘Location” alphabetically
Calculate the AVERAGE number of visitors to all of the 7 Wonders of the World in Cell B:9 → Highlight in YELLOW
Calculate the total SUM of visitors to all of the 7 Wonders of the World in Cell C:9 → Highlight in GREEN
Highlight the information in Columns A and B. Insert a pie chart to the RIGHT of the data that shows visitors to the 7 Wonders of the world
Rename “Sheet 1” to “Visitors” and protect the sheet so it can only be edited by you
Change the Share Settings to “Anyone with the link: Can View” and submit your link as evidence
Page updated
Report abuse