Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Open the start file BA2013-Fixit-2-0. The file wall be renamed automatically to include your name. Change the project file name if directed to do so
Open the start file BA2013-Fixit-2-0. The file wall be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook. 3. Begin by removing all the fill color, font colors, and borders from the worksheet. This worksheet has so many different formats, it is probably easier to start from a clean slate. 4. All fonts in the worksheet should be set to Calibri, 12 point size. 5. Apply appropriate formatting for the title. Use a cell style. 6. Add borders and fill color to make the data table easy to follow. Use bold where appropriate to make row and column headers stand out from the data. 7. An entry for June 9 is missing. You walked for 40 minutes that day, and went 3 miles. Insert the data in the appropriate place. (You can copy the formula to calculate miles per hour from one of the other cells). Note: You must complete step: 7 correctly in order to be able to receive points for completing the next steps. Check your work carefully. 8. Apply text wrapping in cell Do. 9. Apply conditional formatting using data bars to visually compare the distance jogged each day. 10. Ensure that all entries for miles and miles per hour display two digits after the decimal 11. Ensure that all average calculations display only two digits after the decimal. 12. Find all instances of walk and replace with joy
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started