Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1U. Gene 'ua's manager would lilce to see some additional infonnation to help malce sales decisions. Enter a lhrmula in cell Jil- using the IF

image text in transcribed
1U. Gene 'ua's manager would lilce to see some additional infonnation to help malce sales decisions. Enter a lhrmula in cell Jil- using the IF function to it whether or not the item Eleaded Earrings should go on sale. It will go on sale ifil: current sales ranlc [in cell Grill is Ether lower: [Hints ifthe cell value is greater than or equal to 3, it will go on sale-] a- Itthis condition is true. the item will go on sale. [Hint The if_true value shoulcl he ""I"ES".:| h- Itthis condition is 1l'alse. the item doesn't need to go on sale. II'Hr'nL' The il:_l'alse value should he "-"J c- Copy the armula created in cell Hto the range]5:jl4. 11. Enter a JFormula in cell E4 to calculate how long each item has been on sale. This is calculated by subtracting the launch date in cell D4 From the Data Updated date in cell C1.To showthe time in vears. divide that result hvBI- Use an absolute reference to the date in cell {321}. Copy the Jinr'r'nula 'om cell E4 to cells E5:E14

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

Probability and Random Processes With Applications to Signal Processing and Communications

Authors: Scott Miller, Donald Childers

2nd edition

123869811, 978-0121726515, 121726517, 978-0130200716, 978-0123869814

More Books

Students also viewed these Mathematics questions

Question

use Laplace transform to sole y''-3y'+2y = 4t-6; y(0)= 1; y'(0)=3

Answered: 1 week ago

Question

2 Use evaluation highlighting to sort ideas and gain more insights.

Answered: 1 week ago

Question

Compare and Contrast file Systems with database systems?

Answered: 1 week ago

Question

Define Data Abstraction and dinsuun levels of Abstraction?

Answered: 1 week ago

Question

Explain ACID properties and Illustrate them through examples?

Answered: 1 week ago

Question

Discuss How do you implement Atomicity and Durability?

Answered: 1 week ago