UNIT 5 VLOOKUP SUMIF and COUNTIF Functions IT Spreadsheet Application

/in /by

UNIT 5 VLOOKUP SUMIF and COUNTIF Functions IT Spreadsheet Application

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