Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9 . Go to the Schedule worksheet, which contains the beginnings of a schedule for developing the new website. In cell B 3 , enter

9. Go to the Schedule worksheet, which contains the beginnings of a schedule for developing the new website. In cell B3, enter a formula using the DATE function to enter April 3,2021 as the date.
10. For milestones 210, the dates are five days after the previous start date. To exclude weekends for those days, enter a formula in cell C7 using the WORKDAY function that adds five days to the date in cell C6. Fill the range C8:C15 with the formula in cell C7 to complete the schedule.
11. Move the Website Project Timeline chart to the Overview worksheet. Position the chart so its upper-left corner is in cell H23 and its lower-right corner is in cell M36 on the Overview worksheet. Change the number format of the horizontal axis values in the Website Project Timeline chart to display dates with an abbreviated month name, a hyphen, and the year abbreviated, as in Mar-21.
12. Return to the Schedule worksheet to prepare it for printing. Set top and bottom margins of 1", and then center the worksheet vertically on the page. Insert a footer that displays the Sheet Name in the center section

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

How To Build A Million Dollar Database

Authors: Michelle Bergquist

1st Edition

0615246842, 978-0615246840

Students also viewed these Databases questions