1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Shkiper50 [21]
3 years ago
13

10. Geneva's manager would like to see some additional information to help make sales decisions. Enter a formula in cell J4 usin

g the IF function to it whether or not the item Beaded Earrings should go on sale. It will go on sale if its current sales rank (in cell G4) is 8th or lower. (Hint: If the cell value is greater than or equal to 8, it will go on sale.) a. If this condition is true, the item will go on sale. (Hint: The if_true value should be "YES".) b. If this condition is false, the item doesn't need to go on sale. (Hint: The if_false value should be "-".) c. Copy the formula created in cell J4 to the range J5:J14.
World Languages
1 answer:
jekas [21]3 years ago
3 0

Answer:

IF condition in Cell G4 is:

IF(G4>=8,"YES","-")

Explanation:

  • I have made the excel file with required specifications. Check the file attached.
  • If the Sales Rank is 8 or above Sales decision is "YES" otherwise it is "-".
Download xlsx
<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark"> xlsx </span>
3229bf6c25f1abf99854467c643ff185.jpg
You might be interested in
muszę opisać plakat Tristan i Izolda na min 200 słów a nie mam wogóle pomysłu jak to zrobić będę wdzięczny jak ktoś to zrobi dla
Lapatulllka [165]

Answer:

Co dokładnie trzeba o nich napisać? Naprawdę nie wiem, kim są i skąd pochodzą, więc myślisz, że możesz dać mi krótki opis, zanim spróbuję go napisać?

Explanation:

7 0
3 years ago
ipaliwanag kung bakit ang kumplikadong natural na ecosystem ay hindi gaanong masisira upang makapinsala mula sa insekto, mga sak
spayn [35]
I’m gonna pretend this is just gibberish
5 0
3 years ago
Read 2 more answers
Solve these exercises in Substitution method
Travka [436]

Answer:

;;;

Explanation:

5 0
2 years ago
A storm destroys half of the potato crop. Is this event more likely to hurt potato farmers if the
Gelneren [198K]

Answer:

yes because the crop supply will lower. Thus making less to sell

7 0
3 years ago
Make a list of all the noise you have experienced. Classify them according to types of barriers of communication. What do you th
Zinaida [17]

Answer:

i think you are referring to this:

Physical Conditions

Sometimes “noise” is just exactly that—loud or distracting sounds that make it impossible to hear or concentrate. Or the general level of background noise can be so intense that it is hard to focus for long on one particular voice. A room may be so hot or so cold that people can’t get comfortable and cannot pay attention. Outside activities may be a distraction to those with a view out windows. Finally, it may be lunchtime or too close to quitting time to keep people focused. Fortunately, with some awareness and advance planning, physical barriers to effective communication are some of the easiest to overcome.

Filtering

Personal and particular experiences color how people view the world and how they communicate. A message sender sees the world through one set of filters (experiences and values) and the receiver sees it through a different set of filters. Each message has to pass, therefore, through at least two sets of filters. The more similar people are in lifestyle, experience, culture, and language, the more similar their mental filters are likely to be and the less distortion should occur. This is why people who come from very different social and economic situations than their audience must work extra hard to say exactly what they mean to avoid confusion. Also, the fewer people involved in the transmission of a message, the greater the chance that it will be received as the sender intended. In business, however, messages may be summarized by a manager and relayed through an administrative assistant who has clarified or edited the message. Messages exposed to many filters should be repeated in various ways to make sure they were understood as the sender intended.

Information Overload

We have all been in situations when we felt that too much information was coming at us. When this happens, we feel overwhelmed and fear that we will not be able to retain any information at all. Sometimes it is not just the quantity of communication but the level that causes overload. If the message contains information that is new to the receiver, including processes or concepts that are not familiar, then the chances of overload increase greatly. The sender should break up the message into more palatable or digestible bits and reduce the amount of information that has to be absorbed at any one time. One technique is to make a high-level announcement and then follow it up later with more details. The sender has the primary responsibility to check that the receiver has understood the message. This means that a manager may have to adjust a message to reflect the various experiences of the employees. A new employee may need repeated explanations before beginning an operation, whereas an experienced employee may start rolling his eyes at the same old instructions.

When your audience involves people whose native language is not English or individuals of different educational backgrounds, messages need to be direct and clearly stated to help ensure they are understood.

Emotional Disconnects

Almost the first thing parents learns is never to try to have a rational discussion with a screaming toddler or an angry teenager. If they wait until the young person is more receptive to what they have to say, the odds of a successful conversation improve dramatically. Adults also experience emotional disconnects that affect the chance of successful communication. For example, when a person is feeling stressed or anxious, an expressed concern is more likely to be interpreted as criticism. Constructive criticism made while an employee is emotionally fragile may be perceived as a personal attack. If possible, it is better to postpone a communication if there is a strong likelihood that the intended receiver will misinterpret it because of his emotional state.

Credibility

A businesswoman holding a sign that reads “I am your boss!”

There are better ways to communicate your credibility than reminding everyone of your position.

In communication, the validity of the message is tied to the reputation of the sender. If the receiver doesn’t trust the sender, he will view the message itself with skepticism or suspicion. If the sender is trustworthy, the receiver will likely believe the message despite her personal opinions about that subject. In other words, the trustworthiness of a communication, regardless of format, is heavily influenced by the perceived credibility of the source of that communication.

<u>try that!</u>

<u></u>

3 0
2 years ago
Other questions:
  • What right does a slave have and what was the exception?
    11·1 answer
  • Which phrase best define quotation
    9·1 answer
  • O ensino da língua portuguesa tem por objetivo: I - organizar e aprofundar os conhecimentos linguísticos internalizados pelo alu
    15·2 answers
  • Ano ang kahulugan ng napagtanto
    13·2 answers
  • Read the following sentence:
    11·1 answer
  • Where can I find gymnastics in brooklyn
    6·1 answer
  • One of the main themes in this book is the appeal of the wild. It draws in Buck, and it draws in the reader.
    12·1 answer
  • Most of the story of A Christmas Carol takes place on Christmas ____(world start with e and has 3 letters ​
    13·2 answers
  • 1.) Do Koreans, Chinese, Japanese, Filipinos have the same culture?
    8·2 answers
  • ശുഭാപ്തിവിശ്വാസമാണ് ജീവിതത്തെ മുന്നോട്ട് നയിക്കുന്നത്. "വിശ്വം ദീപമയം" എന്ന പാഠത്തിന്റെ ആശയം ഉൾപ്പെടുത്തി ഒരു ഉപന്യാസം തയ്യാറാക്
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!