CommencerCommencer gratuitement

Setting limits

As a data analyst at AutoNexa Motors, you are responsible for ensuring data accuracy in the company's vehicle database. The company maintains an Excel sheet named "Car DB", which contains essential vehicle details such as:

  • Vehicle Identification Numbers (VINs)
  • Make
  • Model
  • Year

However, the sales team frequently enters VINs manually into a separate sheet to track vehicle sales, often leading to errors such as invalid or non-existent VINs. Your task is to implement Data Validation to minimize these mistakes.

Cet exercice fait partie du cours

Data Validation in Excel

Afficher le cours

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice