Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics

Authors: Roger A Arnold

13th Edition

1337617407, 9781337617406

More Books

Students also viewed these Economics questions

Question

Define forensic psychology.

Answered: 1 week ago