Topic Presented:
Tasks
Member Name Part Presented Duration (min) 1. Populate all necessa
1 member names, what p
2 each member will prese
3
4 2. Sort by Member Nam
5
3. Change cells B4:D4
Total Presentation Length (min):
4. In cell D11, insert a f
length of your presenta
5. CONDITIONALLY fo
red if the total length of
BETWEEN 10 and 12 m
6. Insert a pie chart tha
presentation will be dist
part presented). Name
and place it under the d
1. Populate all necessary information (topic presented,
member names, what parts they will present, how long
each member will present for)
2. Sort by Member Name in ascending order.
3. Change cells B4:D4 and C11 to BOLD formatting
4. In cell D11, insert a formula that calculates the total
length of your presentation
5. CONDITIONALLY format cell D11 to display text as
red if the total length of the presentation is NOT
BETWEEN 10 and 12 minutes
6. Insert a pie chart that details the how the
presentation will be distributed (either by presenter or
part presented). Name it "Presentation Distribution"
and place it under the data
Topic Presented: Blu-Ray
Member Name Part Presented Duration (min)
1 Heath Introduction 2
2 Hyun Ji Previous technologies 2
3 Jesse Current Applications of Blu-ray 2
4 Ju-Eun How Blu-ray is Different 2
5 Ted Competeing storage systems 2
Total Presentation Length (min): 10
Presentation Distribution
Competeing Introduction
storage systems Introduction
Previous technologies
Current Applications of Blu-ray
How Blu-ray is Previous
Different technologies
How Blu-ray is Different
Current
Competeing storage systems
Applications of
Blu-ray
Tasks
1. Populate all necessary information (topic presented,
member names, what parts they will present, how long
each member will present for)
2. Sort by Member Name in ascending order.
3. Change cells B4:D4 and C11 to BOLD formatting
4. In cell D11, insert a formula that calculates the total
length of your presentation
5. CONDITIONALLY format cell D11 to display text as
red if the total length of the presentation is NOT
BETWEEN 10 and 12 minutes
6. Insert a pie chart that details the how the
presentation will be distributed (either by presenter or
part presented). Name it "Presentation Distribution"
and place it under the data