Across
- 6. Another word for "text" in programming and Excel.
- 10. The character usually used to separate arguments in a function.
- 11. Every Excel _____ must begin with an equals sign (=).
- 12. The function used to add up the final_amount column.
- 13. The speed at which data is generated and processed.
- 15. A specific category (aisle) found in your grocery dataset.
- 17. Different types of data like text, video, and sensor logs.
- 19. The process of removing noise and duplicates from a dataset.
- 21. The first step in the big data lifecycle: to _____ data.
- 22. A logic type that returns either TRUE or FALSE (used in IF).
- 25. The most important 'V'; data is useless unless it provides this.
- 26. The 'V' that refers to the noise, abnormality, and uncertainty of data.
- 27. Function used to count cells that meet a single specific criterion.
- 29. Column D in your grocery data, used to categorize products.
- 30. Excel Operations & Logic
Down
- 1. You must enclose text in double ____ in an Excel formula.
- 2. Data that provides information about other data.
- 3. The modern Excel function that replaces multiple nested IFs.
- 4. Analytics that zero in on "correct" behavior to forecast trends.
- 5. Data like PDFs and videos that don’t have a pre-defined model.
- 7. Data organized into formatted repositories like SQL databases.
- 8. The 'V' representing the massive amount of data generated.
- 9. The function used to find the highest value in a range.
- 14. A visual representation used to display big data analysis results.
- 16. The intersection of a row and a column in Excel.
- 18. A common framework used for distributed storage of big data.
- 20. A massive unit of digital data (approx. 1,024 Exabytes).
- 23. A process or set of rules used by a computer to solve problems.
- 24. The function used to find the mean value of unit_price.
- 28. A collection of two or more cells (e.g., A2:A1981).
- 31. An IF function placed inside another IF function.