Excel and Data Science Multiple Choice Questions

Which Excel feature is specifically designed to summarise large data sets dynamically without writing formulas?

• Goal Seek

• PivotTable

• Data Validation

• Flash Fill

You need to total sales only for rows where the Region column equals “NSW”. Which function is the most efficient?

• SUMPRODUCT

• SUM

• SUMIF

• COUNTIFS

In a dashboard, a slicer is most commonly linked to a …

• Conditional formatting rule

• Named range

• PivotTable or PivotChart

• Macro button

What type of cell reference should you use when dragging a formula across rows if the column letter must stay fixed but the row number can change?

• Relative (A1)

• Mixed column-locked ($A1)

• Mixed row-locked (A$1)

Which one of the following best describes the purpose of the XLOOKUP function introduced in recent Excel versions?

• It replaces VLOOKUP/HLOOKUP with a more flexible, array-friendly lookup.

• It scans worksheets for external links.

• It visualises correlations between two variables.

• It encrypts confidential worksheet ranges.

When importing a CSV in Excel, which delimiter is most likely to create column-splitting issues if the file originated from a system using European regional settings?

• Comma ,

• Semicolon ;

• Tab

• Pipe |

In the HSC Enterprise Computing Data Science module, developing a spreadsheet-based data dashboard principally demonstrates which stage of the data-science cycle?

• Data acquisition

• Data cleansing

• Data communication & visualisation

• Model evaluation

Which chart type is least appropriate for showing changes in two variables over time on the same axis?

• Clustered column chart

• Combo chart with a secondary axis

• Line chart

• Donut chart

You create a PivotTable and then insert a Chart linked to it. If you filter the PivotTable, what happens to the chart?

• The chart ignores the filter.

• The chart updates automatically to reflect the filter.

• Excel prompts to refresh manually.

• The chart becomes hidden.

Which Excel function pair is most useful for checking and removing duplicate records in a dataset?

• COUNTIF + Conditional Formatting “Unique”

• RAND + SORT

• INT + MOD

• BAHTTEXT + PROPER