Page 175 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

PRACTICE QUESTION 4

Create DropDown Controls

Create a list of employees

Type in the following information in Column
Tajuddin
Edmira
Rumairah
Haiqal Murniati

Select the data and name the range. In the Name Box type: Employees
Name the sheet: Employees

Create a list of locations on another spreadsheet in the same workbook

Enter the following Locations in Column A and sort them
Kota Bharu
Ketereh
Jeli
Ketereh
Kubang Kerian

Select the data and name the range.
In the Name Box type: Employees
Select the names and name the range.
In the Name Box type: Location
Name the sheet: Location

Create a schedule on another spreadsheet in the same workbook

Rename Sheet3: Schedule
In Cell A1 Type: Employee Name
In Cell A2, use Data Validation to create a Drop Down control using the "Employees" source.
Include an Input Message that says: "Select an employee from the list" .
Fill down Five rows.
In Cell B1 Type: Location.
In Cell B2, use Data Validation to create a Drop Down control using “Location" as
the source.
I nclude and Input Message that says: "Select a Location from the list."
Fill Down five rows

166 | P a g e