Question: Task 2 Computing the rental period Insert a new column F and name it Rental Period ( Weeks ) . Create a formula that correctly

Task 2 Computing the rental period
Insert a new column F and name it Rental Period (Weeks).
Create a formula that correctly computes the number of weeks that cabin was rented.
Hint: remember that Excel stores dates as numbers
Copy your formula down to the bottom of the data
WARNING: Be careful to copy your formula only to the bottom of the actual
data, not all the way to the bottom of the sheet at row 1,048,576. Creating a
million rows of useless formulas will make your spreadsheet become really slow!
Hint: remember that you can use keyboard shortcuts to rapidly move up and
down enormous ranges of cells.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!