Cross word Day 1

12345678910111213141516
Across
  1. 3. MATCH A combination of two functions that provides more flexibility than VLOOKUP
  2. 4. A function that returns a reference to a range that is a specified number of rows and columns from a cell or range
  3. 6. The programming language used for Excel automation
  4. 8. A function that can perform calculations while ignoring errors and hidden rows
  5. 10. A visual filter that allows for easy data segmentation in PivotTables
  6. 13. A feature in PivotTables that filters data visually
  7. 14. FORMULA A formula that can perform multiple calculations on one or more items in an array
  8. 16. An external data visualization tool that integrates with Excel
Down
  1. 1. A feature that restricts editing of certain cells or sheets in Excel
  2. 2. A function to join multiple text strings into one, now replaced by TEXTJOIN
  3. 5. A term used for matrices with many zero values, often relevant in data analysis
  4. 7. A versatile lookup function that replaces VLOOKUP and HLOOKUP
  5. 9. A term describing a function that calls itself within its definition
  6. 11. FUNCTION A function used to retrieve data from a cube data source in Excel
  7. 12. ARRAY A feature that allows formulas to return multiple results into adjacent cells
  8. 15. A feature that allows for complex data retrieval and manipulation