A Cork retail chain reviews last year's store revenue totals to compile an annual performance report. Which analytics type does this represent?
Concepts And Statistical Analysis
Question · Easy
An operations manager in Dublin asks, 'Which supplier delays most often caused stock-outs last quarter?' Which analytics approach best fits?
Question · Medium
A Galway energy firm models next winter's electricity demand from five years of meter readings. Which analytics category is this?
Tech Exam Prep Podcast
Listen on Spotify
Podcast
A logistics planner uses optimisation software to recommend the cheapest delivery route for tomorrow's shipments. Which analytics type applies?
Which data type in the ICDL Data Analytics syllabus is measured on a numerical scale and can be counted or ordered?
A survey records product colour choices: Red, Blue, Green, or Yellow. How should this variable be classified?
According to the ICDL Data Analytics Foundation syllabus, which business benefit is gained when analytics identifies recurring patterns in customer behaviour?
In the ICDL data analysis process, during which phase does an analyst collect initial data and assess its quality and relevance?
Which data analysis phase includes activities such as cleaning, transforming, and integrating data into a final analysis-ready dataset?
An Irish marketing team plans to share customer survey results externally. Which data protection practice aligns with the ICDL syllabus and GDPR?
Daily website visit counts for an Irish tourism board are recorded as: 120, 150, 130, 140, 160. What is the mean (average)?
House prices in a Limerick estate (€) are: 210,000; 225,000; 230,000; 240,000; 950,000. Which measure of central tendency is least distorted by the €950,000 outlier?
Customer support tickets per day are logged as: 4, 6, 6, 8, 6, 10, 6. What is the mode?
Exam scores for five ICDL candidates are: 72, 78, 80, 85, 90. What is the range?
Which measure describes how spread out values are around the mean by averaging squared deviations?
In a dataset ordered from lowest to highest, which quartile represents the value below which 25% of observations fall?
Using spreadsheet functions, which measure of central tendency returns the middle value when exam scores are sorted in ascending order?
The ICDL syllabus lists quartiles among measures of variation. What does the second quartile (Q2) represent?
Which ICDL syllabus phase follows modelling and checks whether the analytical results meet the original business objectives?
Question · Hard
Under Ireland's Data Protection Act 2018, which supervisory authority oversees GDPR compliance for organisations processing personal data in Ireland?
Which file format stores tabular data as plain text with fields separated by commas, commonly used for data imports?
Data Preparation
An analyst imports a product list from a supplier's Excel workbook into a master spreadsheet. Which syllabus import source does this represent?
After copying a pricing table from a supplier's web page into a spreadsheet, which syllabus category best describes this activity?
A Dublin HR team connects a spreadsheet to an employee table in a company database to pull current staff records. Which import method applies?
Two rows in an order log share the same OrderID with identical details. What cleansing step should be applied first?
Product codes in column A contain accidental spaces before and after the text, causing VLOOKUP failures. Which function removes extra spaces?
A dataset mixes dates as '05/03/2026' and '2026-03-05'. Why standardise formats before analysis?
A product master list must show only items in the Electronics category without deleting other rows. Which preparation technique applies?
To list transaction amounts from highest to lowest, which sort order should be applied?
A filter shows rows where Region equals 'West' AND Sales exceed €500. How does AND logic behave?
Which formula returns 'Pass' when cell B2 is at least 75 and otherwise returns 'Fail'?
A quality check flags orders only when Status is 'Shipped' AND Quantity is above 100. Which function combines both tests inside IF?
A discount applies when a customer is either 'Gold' tier OR order value exceeds €1,000. Which function tests either condition?
Column A lists product codes; a reference table in columns D:E maps codes to prices. Which function looks up a code and returns its price?
In VLOOKUP, what does setting the range_lookup argument to FALSE accomplish?
To verify each exam score in column B is between 0 and 100 inclusive, which approach matches the syllabus?
Cell A1 contains 'ICDL-DA-2026'. Which function returns the number of characters in the string?
Which function returns the first three characters from the text in cell B2?
Postcode 'D02 H364' is in cell C2. Which formula returns 'H364'?
To extract four characters starting at position 6 from a product code in A1, which function is correct?
Which function returns the starting position of the text 'Analytics' within cell A1?
Why should an analyst format a raw data range as a built-in Excel table before applying filters?
After converting sales data to a table, which tool provides clickable buttons to filter by Region or Product Category?
An imported CSV column of order quantities is stored as text, breaking SUM calculations. What preparation step fixes this?
Accented characters in an imported CSV display as garbled symbols. What is the most likely fix?
A column stores phone numbers with inconsistent leading zeros. Before lookup matching, which combination of steps is most appropriate?
Which preparation activity removes rows that are exact duplicates across all columns in a customer export?
Loading more…