Excel exercises on DATA VALIDATION

This page lists the 6 exercises about Data validation in Excel on our website:

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use validation settings in Microsoft Excel 2007 to control the data that users can enter into a spreadsheet.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Apply data validation and outlining to an existing Excel 2007 business model.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use Microsoft Excel 2007 to provide a drop-down list within your spreadsheet. Additionally, protect the sheet against update, amendment and the viewing of sensitive data.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Set data validation on cells to stop invalid entries.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Apply data validation and protection to an Excel 2007 model for the London Olympics.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Data validation
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use validation and protection settings in Microsoft Excel 2007 to create a robust spreadsheet model.

Go to exercise ...

You can search our full list of Excel exercises here, or why not have a look at our other Excel training resources?

This page has 0 threads Add post