Question: Task 2 Computing the rental period Insert a new column F and name it Rental Period ( Weeks ) . Create a formula that correctly
Task 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
