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$

$1$A$.(20$ Points$)$ 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

$\backslash$table$[[$INPUT: Number of Steps Walked,$\backslash$table$[[($in this cell, allow$],[$spreadsheet user to tvpe in$],[$the number of steps walked$)]]],[$OUTPUT: Distance Walked in Miles,$\backslash$table$[[($in this cell, you calculate the$],[$distance they walked based$],[$on the number of steps input$)]]],[$OUTPUT: Time Spent in Minutes,$\backslash$table$[[($in this cell, you calculate the$],[$time they walked based on$],[$the number of steps input$)]]],[$OUTPUT: Calories Burned,$\backslash$table$[[($in this cell, you calculate the$],[$calories they burned off$],[$based on the number of steps$],[$input$)]]]]$

ASSUMPTIONS

assume the average person takes $2,000$ steps per mile that they walk

assume the average person takes $6,000$ steps per hour they walk, and there are $60$ minutes in an hour

assume the average person walks $20$ steps to burns $1$ Calori$$