Data Profiling with COUNT & SUMPRODUCT in Excel

What is the primary purpose of data profiling?

• To create new data

• To review and analyze existing data

• To delete unnecessary data

• To visualize data in charts

Which of the following is NOT a technique used in data profiling?

• Data Visualization

• Standard Deviation

• Frequency Count

• Mean and Mode

What does the Power Query Editor help identify in data?

• Data trends

• Null values and errors

• Data visualization

• Data encryption

Which Excel function is used to count non-empty cells?

• COUNTBLANK

• SUMPRODUCT

• COUNTA

• COUNT

What is the purpose of the COUNTBLANK function in Excel?

• To count unique values

• To count blank cells

• To count text cells

• To count numeric cells

How does the SUMPRODUCT function help in data analysis?

• By visualizing data

• By finding unique values

• By calculating the sum of products

• By counting blank cells

What should be done if a division error occurs while using SUMPRODUCT?

• Change the formula

• Ignore the error

• Re-enter the data

• Check for blank cells and update them