Pick three (3) Excel tasks from the list below. Use YouTube to research each task and demonstrate how they
are used in the worksheet below. Format the worksheet
Research List
Create a Drop down List
Use Conditional formatting to display numbers greater than 5 for Gallons Sold
Data validation with whole numbers
ROUND function
VLOOKUP function
COUNTIFS
Insert a hyperlink