Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Office Melbourne Melbourne Years Service 5.6 5.5 5.3 Employee Name Sam Mason Lemin Lu James Viney Will Chang Divika Kapoor Bin Wang Andy Forbes Tom
Office Melbourne Melbourne Years Service 5.6 5.5 5.3 Employee Name Sam Mason Lemin Lu James Viney Will Chang Divika Kapoor Bin Wang Andy Forbes Tom Peters Elan Forbes Phil Smith Jason Kerr Chris Powe Jordan Riddle Start Date 21/9/15 15/10/15 26/12/15 20/4/18 5/5/18 26/5/18 29/11/19 23/1/20 15/4/18 1/4/18 22/4/16 13/7/16 21/6/20 Sydney Melbourne Sydney Sydney Melbourne Sydney Melbourne Sydney Sydney Sydney 3.0 3.0 2.9 1.4 1.3 Days Leave 18 15 5 9 23 24 6 19 16 30 10 5 9 Phone Extension 2782 2379 2459 2369 2729 2148 2170 2570 2849 2984 2239 2468 2318 3.0 3.1 5.0 4.8 0.8 8 To find the total days leave for people in the Melbourne office I should use which function? A SUMIFS B COUNTA C VLOOKUP D COUNTIFS TRUE FALSE FALSE FALSE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started