UNIT 5 VLOOKUP SUMIF and COUNTIF Functions IT Spreadsheet Application
Business Finance
Unit Outcomes:
Use the VLOOKUP function to find values.
Apply filtering to data.
Prepare data to convert charts.
Format a worksheet as a table.
Use the SUMIF and COUNTIF functions.
Create a Pivot Table.
Add a clustered bar pivot chart.
I attached the example data
