THE GAMBIA NATIONAL AUDIT TEAM: DATA ANALYSIS, REPORT AUTOMATION

What keyboard shortcut allows you to navigate to the edge of a data table in Excel?

• CTRL + Shift

• CTRL + Arrow keys

• ALT + Arrow keys

• SHIFT + Arrow keys

In Excel data management, what is the primary benefit of converting raw data into a dynamic Excel Table?

• It allows for manual sorting only

• It enables automated formulas and audit trail integrity

• It restricts data entry

• It removes all formatting

How can you standardize mixed upper and lower case entries in an Excel column?

• Use the TRIM function

• Use the PROPER, UPPER, or LOWER functions

• Use the DATEVALUE function

• Use the SUBSTITUTE function for commas

Which Excel function is used to remove extra spaces from cell entries?

• CLEAN

• TRIM

• PROPER

• VALUE

When developing PivotTable reports, what is the first step in formulating guiding questions?

• Select chart types

• Identify key metrics like sums or variances needed for analysis

• Import data from CSV

• Add slicers

In Power Query, what feature records steps for data transformation, allowing edits or reordering?

• PivotTables

• Applied Steps pane

• DAX formulas

• Slicers

How do you automate reporting in Excel using Power Query and PivotTables?

• Manually copy data each time

• Refresh the query and PivotTable to update with new data

• Use SQL queries only

• Delete and recreate the table

What is the main purpose of data visualization in Excel?

• To store raw data

• To transform mountains of data into actionable intelligence

• To trim spaces

• To format dates

When should you use a pie chart in Excel visualizations?

• For comparing trends over time

• For showing proportions of a whole, like category breakdowns

• For detailed numerical comparisons

• For scatter plots

Slicers in Excel are best used when?

• You need to filter data interactively across multiple charts or PivotTables

• You want to trim text

• You are formatting numbers

• You are merging cells