Question
Sales ($ millions) Quarter 1 500 Quarter 2 350 Quarter 3 495 Quarter 4 620 In Excel, Write a function that compares the sales in
| Sales ($ millions) | |
| Quarter 1 | 500 |
| Quarter 2 | 350 |
| Quarter 3 | 495 |
| Quarter 4 | 620 |
In Excel,
Write a function that compares the sales in Quarters 1 and 2, and returns the text "Q1 is better than Q2" or "Q2 is better than Q1".
Use a formula to achieve: If Q1 sales are greater, return the difference between Q2 and Q1 (Q2-Q1). If Q1 sales are less, return the increase.
The company sets the goal for the sales team: to have at least one quarter of sales exceeding $600 million. If the sales team meets the goal, use the formula to return "Quota met", otherwise "Quota not met"
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
The Internal Auditing Pocket Guide
Authors: J. P. Russell
1st Edition
0873895606, 978-0873895606
