Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Financial Accounting Australia And New Zealand Edition

Authors: Jerry J. Weygandt

11th Edition

1119668654, 978-1119668657

More Books

Students also viewed these Accounting questions

Question

4. Explain the strengths and weaknesses of each approach.

Answered: 1 week ago