Walking$/$Step Counter Part A $$ Create a MICROSOFT EXCEL SPREADSHEET based on the below:

There are programs that you may have seen that keep track of $$steps$$ as you walk around, and also display calculations

based on walking, such as distance traveled, calories burned, and time spent.

Create a Microsoft Excel spreadsheet that will allow a$)$ someone to type in the number of steps walked as input in a cell,

and then b$)$ you create Excel calculation cells to take that input and calculate outputs as described in the example below:

Name your spreadsheet: CalcValidationExcel $-$ Your Name

TEXT LABELS INPUT $/$ OUTPUT ASSUMPTIONS EXAMPLE

INPUT: Number of Steps Walked

$($in this cell, allow

spreadsheet user to type in

the number of steps walked$)6,000$

OUTPUT: Distance Walked in Miles

$($in this cell, you calculate the

distance they walked based

on the number of steps input$)$

assume the average person

takes $2,000$ steps per mile

that they walk $3$

OUTPUT: Time Spent in Minutes

$($in this cell, you calculate the

time they walked based on

the number of steps input$)$

assume the average person

takes $6,000$ steps per hour

they walk, and there are $60$

minutes in an hour

$60$

OUTPUT: Calories Burned

$($in this cell, you calculate the

calories they burned off

based on the number of steps

input$)$

assume the average person

walks $20$ steps to burns $1$

Calorie $300$