BIS 155
TTT12Date, Logical and Lookup Functions (Chapter 7): From the Logic-Lookup worksheet, let's practice using the YEARFRAC function. In cell F7, create a formula to calculate how many years Rush has worked at the company. Calculate for all employees in Column F. You will need to use the Decrease Decimal feature to decrease to one decimal place.
Discuss the YEARFRAC function. Share your formula with the class and how you created it. How can you quickly calculate years worked for the rest of the employees without entering the formula row by row?
9 years ago
5
Answer(1)![blurred-text]()
Purchase the answer to view it
a1.docx- chapter_7.xlsx
Bids(0)
other Questions(10)
- NOVA Video
- Why is it important to consider the full lifecycle of a system when identifying and controlling hazards?
- Diss2
- Consider a specific job within the criminal justice system
- BU330 Accounting for Managers Factoring resource constraints into product mix decisions
- Week 7 - Case Study Practical Exercise
- Women Expatriates
- Prof Maurice
- Calc I file attached
- Physics
