Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. excel sheet: https://imgur.com/7uwgwl0 1. how do i

Excel sheet: https://imgur.com/7UwGWL0 1. How do i find how many stores achieved a Tier 4...

70.2K

Verified Solution

Question

Accounting

Excel sheet:

https://imgur.com/7UwGWL0

1. How do i find how many stores achieved a Tier 4 performance based on their January revenue?

2. Tier 5 perfomance based on February revenue?

3. How many stores achieved a Tier 3 or better performance based on their October revenue?

4. Assume we want to look up the revenue for March (cell AH11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AH11?

5.Assume we want to look up the number of employees (cell AI11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AI11?

6. Assume we want to look up a stores phone number (cell AJ11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AJ11?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Algebra
1.2K views

The random variables x and ? are independent and ? is uniform in the interval...

Physics
1.2K views

An ideal gas having a volume of 1.0 liters at 40c and a gauge pressure of 1.0...

Mechanical Engineering
1.2K views

A piston cylinder device containing 0.5 kg of water has initial volume of 0.5L. The device...

Biology
1.2K views

When one portion of a chromosome becomes physically part of another chromosome the type of...

Biology
1.2K views

Figure 5 Ebola virus entry An animation of this process can be found at http...

Physics
1.2K views

a k k c k k k k R2 d kqk k k 7 A...

Physics
1.2K views

4 None of the above A piece of copper and other of germanium are cooled...

Basic Math
1.2K views

Problem 3 Let 2 be a C bounded domain of RN On H 22 we...

Calculus
1.2K views

Find all critical points of the following function f x y 3 X 3 3...

Accounting
1.2K views

Go to the YouTube and search for clips from the show How its Made on...

Accounting
1.2K views

Lightfoot Inc, a software development firm, has stock outstanding as follows: 15,000 shares of cumulative...

Accounting
1.2K views

PLss do not write on paper b/sn_ed42c/data-uuid-45e3f502a9584044608c991f08d69d5a ta Aa Manufacturing Overhead (a) 2,256,000 Required:...