Excel Quiz 04 – BI Analyst – Google Sheet, Looker Studio, Power Query

When would you use a calculated field in Looker Studio for data cleaning?

1. To perform data formatting and transformation tasks
2. To directly connect to external data sources
3. To modify the dashboard theme
4. To export data to a different format

How can you handle null values in Looker Studio?

1. Apply a filter to remove rows with null values
2. Use the IFNULL function to replace nulls with a specified value
3. Manually delete rows with null values
4. None of the above

Can Power Query save multiple tables into a single CSV file?

1. Yes, using ‘Merge Tables’ feature
2. No, only one table can be saved at a time
3. Yes, if saved as a ‘Combined Query’
4. It depends on the table format

Which tab in Power Query Editor contains options for sorting, filtering, and grouping data?

1. Home
2. Transform
3. Add Column
4. View

How do you sort data in ascending order in Power Query?

1. Click the column header to sort
2. Right-click the column header and choose ‘Sort Ascending’
3. Use the ‘Sort Ascending’ button under the Home tab
4. All of the above

What is the effect of ‘Load to Table’ on data from Power Query?

1. Exports data to a CSV file
2. Loads the data into an Excel table
3. Transforms data into a JSON format
4. Merges the data with an existing dataset

How does the Arrange menu help in designing a Looker Studio report?

1. It allows users to connect new data sources
2. It helps in aligning, grouping, and distributing report elements
3. It changes the color scheme of the dashboard
4. It modifies the data used in visualizations

How can you make a filter apply only to specific charts in a Looker Studio dashboard?

1. Use the Arrange menu to associate the filter with selected charts
2. Use the filter control’s settings to specify target charts
3. It’s not possible; filters always apply to the entire dashboard
4. Use calculated fields to apply filters conditionally

Which of the following is NOT a default chart type in Looker Studio?

1. Time Series
2. Gantt Chart
3. Pie Chart
4. Table

Which tool allows for filling missing values in a column?

1. Fill Down
2. Replace Values
3. Add Values
4. Aggregate Values

How do you rename a column in Power Query?

1. Right-click the column header and select ‘Rename’
2. Double-click the column header
3. Use the ‘Rename’ option under the Transform tab
4. All of the above

When importing a CSV file, what delimiter is typically used to separate values?

1. Semicolon (;)
2. Tab
3. Comma (,)
4. Pipe (|)

How can you automatically refresh data imported into Power Query from a CSV file?

1. Set a manual refresh schedule
2. Use the ‘Auto-Refresh’ option
3. Configure the ‘Query Properties’ to enable auto-refresh
4. Reload the CSV file manually

What happens when you ‘Unpivot’ columns in Power Query?

1. Columns are transformed into rows
2. Rows are transformed into columns
3. Data is aggregated
4. New columns are created

Which of the following actions can be performed from the Looker Studio dashboard?

1. Create new data sources
2. Build visualizations such as charts and tables
3. Customize dashboard themes and layouts
4. All of the above

Which statement about ‘Applied Steps’ in Power Query is correct?

1. Steps can only be deleted, not reordered
2. You can modify, reorder, or delete steps
3. Steps are automatically saved without user interaction
4. Applied steps don’t impact data loading

Which of the following tools allows importing multiple CSV files into Power Query simultaneously?

1. From Folder
2. Import Wizard
3. Merge Files
4. Consolidate

In Looker Studio, what is the primary purpose of a dashboard?

1. To display raw data without any transformation
2. To provide an interactive interface for data visualization and analysis
3. To store the original data sources for the report
4. To manipulate data before importing it into other applications

What is the purpose of the CASE function in Looker Studio?

1. To filter out data from a report
2. To create conditional expressions for calculated fields
3. To merge two data sources
4. To modify the style of the report

What is the primary function of a filter in Looker Studio?

1. To add new charts to a report
2. To control data visibility by limiting the data displayed
3. To rearrange the layout of the report
4. To create calculated fields based on specific conditions

Which of the following techniques can be used to clean data in Looker Studio?

1. Use calculated fields to transform values
2. Apply filters to exclude irrelevant data
3. Merge duplicate rows
4. Both A and B

Which format does Power Query save a file as when exporting data?

1. CSV
2. TXT
3. XLSX
4. Depends on the chosen file type

In which scenario would you use the ‘Pivot’ function in Power Query?

1. To reshape data where row values become columns
2. To merge two datasets
3. To split a column based on a delimiter
4. To remove duplicate values

In Power Query, how can you change the data source for a query after it has been created?

1. It cannot be changed once set
2. Use the ‘Data Source Settings’ option
3. Manually edit the query code in the ‘Advanced Editor’
4. Both B and C

What does the ‘Close & Load’ button do in Power Query Editor?

1. Closes the editor without saving changes
2. Saves the changes and loads the data into the worksheet
3. Deletes the data
4. Only saves the changes but does not load the data

Which of the following is true about ‘Group By’ in Power Query?

1. It only works with numeric data
2. It allows you to perform aggregate functions, such as sum or average
3. It can only group data based on a single column
4. It is used for splitting data into smaller datasets

Which tool would you use to change the data type of a column in Power Query?

1. Data Type dropdown in the Transform tab
2. Remove Columns option
3. Split Columns option
4. Unpivot Columns option

Which tool in Looker Studio allows you to customize chart styles such as colors, fonts, and borders?

1. Data Source Editor
2. Style Panel
3. Data Panel
4. Visualization Panel

What transformation would you use to remove all duplicate rows in a dataset?

1. Transform -> Filter Rows
2. Home -> Remove Duplicates
3. View -> Clean Data
4. Data -> Sort and Filter

Which icon is used to remove a column in Power Query Editor?

1. Filter Icon
2. Delete Icon
3. Remove Columns Icon
4. Sort Icon