D467 Exploring Data - Set 1 - Part 3

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 41: What spreadsheet function can be used to find the average of a specified range of values?

MAX

MIN

AVERAGE

SUM

Question 42: In a relational database, what term refers to a unique identifier for each record in a table?

Foreign key

Index

Primary key

Attribute

Question 43: Which type of bias occurs when a sample is not representative of the entire population?

Sampling bias

Observer bias

Confirmation bias

Interpretation bias

Question 44: What does the SQL keyword INSERT do?

Deletes records from a table

Adds new records to a table

Updates existing records in a table

Filters data in a query

Question 45: In the context of data ethics, what is the principle of "consent"?

Data should be shared without the users permission

Users should be informed about how their data will be used before it is collected

Data must be encrypted at all times

Data should be anonymized before use

Question 46: What is the primary function of the COUNT function in SQL?

To count the number of characters in a string

To return the total number of rows in a table

To calculate the sum of numeric values

To filter data based on specific criteria

Question 47: A company collects data about employee turnover. What type of data is this?

Qualitative

Nominal

Quantitative

Discrete

Question 48: What does a pivot table do in a spreadsheet?

Filters data based on specific conditions

Summarizes and reorganizes data for analysis

Merges multiple datasets into one

Deletes duplicate records from a dataset

Question 49: What is the key difference between first-party and third-party data?

First-party data is collected directly by the user, while third-party data is bought from external sources

Third-party data is always more accurate than first-party data

First-party data is more secure than third-party data

Third-party data is collected by an individual, while first-party data is public

Question 50: What is the purpose of conditional formatting in a spreadsheet?

To change the appearance of cells based on specific conditions

To calculate the sum of numerical values

To find the maximum value in a range

To merge data from two columns

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass!

Get Exam Support