$904205$ Bike Type Day Date Time Status Email Phone

Mountain bike Friday $1/18/20304$:$45$ PM COMPLETED sample@sample.com $(555)-555-5555$

$*$Title:$*$ Empowering Women in Engineering Road bike Tuesday $1/8/203011$:$45$ AM COMPLETED sample@sample.com $(555)-555-5555$

Mountain bike Thursday $1/3/20301$:$30$ PM CONFIRMED sample@sample.com $(555)-555-5555$

$*$Subtitle:$*$ Celebrating Women's Contributions to the Field Gravel bike Thursday $1/10/20302$:$45$ PM COMPLETED sample@sample.com $(555)-555-5555$

Mountain bike Friday $1/11/20304$:$00$ PM CONFIRMED sample@sample.com $(555)-555-5555$

$*[$Image: A woman holding a spanner and working on a machine$]*$ Gravel bike Wednesday $1/9/20301$:$30$ PM CONFIRMED sample@sample.com $(555)-555-5555$

Road bike Friday $1/4/20302$:$45$ PM COMPLETED sample@sample.com $(555)-555-5555$

Dear All, Road bike Saturday $1/19/20309$:$30$ AM CONFIRMED sample@sample.com $(555)-555-5555$

Road bike Wednesday $1/16/20302$:$45$ PM COMPLETED sample@sample.com $(555)-555-5555$

As we continue to drive innovation and excellence in our engineering endeavors, we want to take a moment to recognize and celebrate the incredible contributions of women in our field. Mountain bike Monday $1/7/20309$:$30$ AM CONFIRMED sample@sample.com $(555)-555-5555$

Gravel bike Thursday $1/17/20304$:$00$ PM CONFIRMED sample@sample.com $(555)-555-5555$

$*[$Image: A group of women engineers working together on a project or Working as individuals$]*$ Gravel bike Wednesday $1/2/203011$:$45$ AM COMPLETED sample@sample.com $(555)-555-5555$

Gravel bike Monday $1/14/203011$:$45$ AM COMPLETED sample@sample.com $(555)-555-5555$

We believe that diversity and inclusion are essential to driving innovation and success. That's why we're committed to supporting and empowering women in engineering to reach their full potential. Road bike Saturday $1/5/20304$:$00$ PM CONFIRMED sample@sample.com $(555)-555-5555$

Road bike Saturday $1/12/20304$:$45$ PM COMPLETED sample@sample.com $(555)-555-5555$

$*[$Image: A woman engineer leading a team meeting$]*$ Mountain bike Tuesday $1/15/20301$:$30$ PM CONFIRMED sample@sample.com $(555)-555-5555$

Gravel bike Sunday $1/6/20304$:$45$ PM COMPLETED sample@sample.com $(555)-555-5555$

Best regards Road bike Sunday $1/13/20309$:$30$ AM CONFIRMED sample@sample.com $(555)-555-5555$

Customer $12$ Mountain bike Tuesday $1/1/20309$:$30$ AM CONFIRMED sample@sample.com $(555)-555-5555$

Status Count

CONFIRMED

COMPLETED

Utilization Total $0$

This is a datasheet for bike utilization monitoring.

$1$ INSTRUCTIONS: Format Row $1$

Freeze and format the cell, font should be in Bold; fill cell A$1$ to H$1$ color should be blue.

Create a filter that will sort the Bike Types in column B$.$

$2$ INSTRUCTIONS: Set up conditional formatting

Set up conditional formatting so that the "Status" column $($column F$)$ shows:

Yellow for "CONFIRMED" and Green for "COMPLETED"

$3$ INSTRUCTIONS: Create a formula to fill in the missing data in cells D$25$ to D$27$

Use the COUNTIF formula in cells D$25$ & D$26$

Use SUM for the Utilization Total