Data GR7 _April-2024

What is data validation?

• A process of ensuring data security

• A process of ensuring data accuracy and adherence to predefined rules

• A process of analyzing data patterns

• A process of generating data reports

What is a cell reference in a spreadsheet?

• The address of a cell based on its row and column location

• The data contained within a cell

• The formatting applied to a cell

• The formula used in a cell

What is a formula in a spreadsheet?

• A graphical representation of data

• A mathematical calculation used to manipulate data

• A style applied to cells for visual enhancement

• A function used to sort data

What does a validation rule specify?

• The format of data entry

• The frequency of data collection

• The storage location of data

• The analysis method for data

What is the COUNT function in a spreadsheet used for?

• The number of non-empty cells in a range

• The average value of cells in a range

• The highest value in a range

• The number of cells containing numeric data types in a range

What is the purpose of data cleansing?

• To store data in a secure location

• To remove errors and inconsistencies from collected data

• To analyze data patterns

• To generate data visualizations

What is the purpose of data normalization?

• To ensure data accuracy

• To eliminate duplicate data and reduce redundancy

• To generate data summaries

• To speed up data processing

What is the purpose of a validation rule?

• To determine the source of data

• To analyze data patterns

• To specify the format and conditions for data entry

• To generate data visualizations

Which keyboard shortcut is commonly used to copy data in Excel?

• Ctrl+Z

• Ctrl+X

• Ctrl+V

• Ctrl+C

Which data type is used to store true/false or yes/no values?

• Text

• Boolean

• Number

• Date/Time