Advanced Excel Quiz

Edit Answers
123456789
Across
  1. 2. SUM function calculates the _________of values.
  2. 3. The AND function returns TRUE if ______ conditions are met.
  3. 6. The IF function performs a ______________ check.
  4. 8. Power Pivot allows handling _________ datasets.
  5. 9. ________ chart type displays data as slices of a circle
Down
  1. 1. The MATCH function returns the ___________ of a value in a range.
  2. 2. Power Query can be used to perform _________ on data.
  3. 4. Which element in an Excel chart provides a clear label for each data series?
  4. 5. Which function searches for a value in the first column of a table and returns a value from a specified column?
  5. 7. INDEX and MATCH together can perform __________ lookups.