Topic Presented: Privacy
Tasks
Member Name Part Presented Duration (min) 1. Populate all necessa
1 Ren Zhang Introduction of Privacy 3 member names, what p
2 Katie Nestor Background Information 3 each member will prese
3 Mimi Weber Positive Aspects and Criticism 3
4 Ben Hamme Opinion Piece 2 2. Sort by Member Nam
3. Change cells B4:D4
Total Presentation Length (min): 11
4. In cell D11, insert a f
length of your presenta
Presentation Distribution
5. CONDITIONALLY fo
red if the total length of
BETWEEN 10 and 12 m
Ben
6. Insert a pie chart tha
Ren
presentation will be dist
part presented). Name
1 and place it under the d
2
Mimi 3
Katie 4
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