ICDL ● DAAdmin login
ONLINE ASSESSMENT · SET A

Data Analytics Assessment

60 multiple-choice questions · 1 mark each · Select one answer per question.

Student details

Enter your name exactly as it should appear in the results.

QUESTIONS

Questions 1–10

0 / 60 answered
Q1Which analytics type answers “What happened?”
Q2Which analytics type investigates causes of past outcomes?
Q3Which analytics type estimates likely future results?
Q4Which analytics type recommends the best action?
Q5A numerical sales-total analysis is mainly what kind of analytics?
Q6Which statistic is calculated as the sum divided by the count?
Q7Which statistic is the middle value after sorting observations?
Q8Which measure identifies the most frequent value?
Q9Which statistic is generally less affected by extreme values?
Q10What is the mean of 4, 6, 8 and 10?
Q11Which file format commonly stores comma-separated records?
Q12Which source is a valid data import source in the course?
Q13Why should column headings be checked after importing?
Q14When importing a CSV, what may need to be specified to separate fields?
Q15Which column value should normally be interpreted as a date?
Q16Which feature is intended to eliminate repeated records?
Q17What does VLOOKUP help validate against?
Q18Which function returns one result when a condition is TRUE and another when FALSE?
Q19Which function extracts characters from the start of text?
Q20Which function extracts characters from the end of text?
Q21What does formatting a dataset as an Excel Table enable?
Q22Which feature provides clickable buttons to filter an Excel Table?
Q23What happens when a slicer selection is cleared?
Q24Why is a consistent header row important in a Table?
Q25To show only records for 'East', which action is most relevant?
Q26What is the main purpose of a PivotTable?
Q27Which aggregation gives the number of transaction rows?
Q28Which aggregation gives total revenue?
Q29Which aggregation gives a typical arithmetic amount per record?
Q30A PivotTable shows 'Sum of Sales'. What does this describe?
Q31What does grouping dates by month in a PivotTable support?
Q32Which is an example of numeric grouping?
Q33What does frequency analysis commonly describe?
Q34Which data field is most suitable for grouping by years?
Q35A PivotTable has daily sales dates. To compare quarters, what would you do?
Q36Which PivotTable area provides a report-wide field filter?
Q37Which object can filter a PivotTable using clickable category buttons?
Q38What is a PivotTable Timeline mainly used for?
Q39What should you use to display only one region in a PivotTable?
Q40What happens when you select one category in a PivotTable slicer?
Q41What is a PivotChart?
Q42What is a key advantage of a PivotChart?
Q43Which chart is generally suitable for comparing sales across regions?
Q44Which chart is generally useful to show a trend over months?
Q45What would you do to visualize a PivotTable summary?
Q46Which desktop tool is covered for creating visual analysis reports?
Q47Which component is primarily used to view and share published Power BI content online?
Q48Which view in Power BI Desktop is used to place visuals on a report page?
Q49What is typically the first step before building visuals from an Excel file?
Q50Which element usually lists dataset fields available for report visuals?
Q51Which visual is suitable for showing a single KPI such as total sales?
Q52Which visual is designed for rows and columns of grouped values?
Q53Which visual generally represents location-based information?
Q54What does a slicer add to a Power BI report?
Q55Which visual is appropriate for comparing categories using bars?
Q56Where are Power BI Desktop reports commonly published for sharing?
Q57What is the purpose of a dashboard tile?
Q58Which choice promotes readable dashboard design?
Q59Why is whitespace useful on a report page?
Q60Which is a good practice when arranging several visuals?

Complete all 60 questions before submitting.