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
lora16 [44]
3 years ago
6

In order to average together values that match two different conditions in different ranges, an Excel user should use the functi

on.
Computers and Technology
1 answer:
Tomtit [17]3 years ago
6 0
In order to average together values that match two different conditions in different ranges, an Excel user should use the Excel Average functions.<span>To calculate average in Excel,the powerful Excel Average functions will do the work behind the scene.  </span>You use the AVERAGE function in Excel to return the average (arithmetic mean) of the specified cells. The different functions are : <span><span>Excel AVERAGE - calculate the mean of cells with numbers.  </span><span>Excel AVERAGEA - find an average of cells with any data. </span><span>Excel AVERAGEIF - average cells based on a given criterion. </span><span>Excel AVERAGEIFS - average cells that match several criteria.</span></span>
You might be interested in
Alfred, a software programmer at Gamma Inc., develops a program that spreads Trojan viruses to the organization’s network. When
Rasek [7]

Answer: (A) legal and ethical

Explanation:

 In the above given scenario, the liam's behaviors is consider as legal and ethical. The organization ethics is the morals of an association, and it is the means by which an association reacts to an inner or outside upgrade. Hierarchical morals is associated with the authoritative culture.

The ethical standard are basically depend on the human standards of good and bad and lawful guidelines depend on composed law, while moral norms depend on human rights and wrongs.

In the organization, the ethical and legal value are basically expressed by each employee as it is the regulatory law which is developed by the government for the particular organization to maintain the discipline.

3 0
4 years ago
Consider the following code segment, which is intended to set the Boolean variable inRange to true if the integer value num is g
Natasha_Volkova [10]

Answer:

Option d  num = 50, min = 50, max = 50

Explanation:

Given the code segment:

  1. boolean isBigger;
  2. boolean isSmaller;
  3. boolean inRange;
  4. if (num < max)
  5.        {
  6.            isSmaller = true;
  7.        }
  8.        else {
  9.            isSmaller = false;
  10.        }
  11.        if (num > min)
  12.        {
  13.            isBigger = true;
  14.        }
  15.        else {
  16.            isBigger = false;
  17.        }
  18.        if (isBigger == isSmaller) {
  19.            inRange = true;
  20.        } else {
  21.            inRange = false;
  22.        }

If we have num = 50, min = 50 , max = 50,  the condition num < max will be evaluated to false and therefore isSmaller is set to false.

The condition num > min will be evaluated to false as well and therefore isBigger is set to false.

Since isSmaller and isBigger are both false and therefore isBigger == isSmaller will be evaluated to true and set the inRange = true. This has violated the statement that if the integer value num is greater than min value and less than max value, then only set inRange to true. This is because num = 50 is neither greater than min nor less than max, it is supposedly not in range according to the original intention of the code design.

8 0
3 years ago
Who is the intended audience of a pseudocode document?
cluponka [151]

Answer and Example:

Pseudocode is an artificial and informal language that helps programmers develop algorithms.

Pseudocode is a "text-based" detail (algorithmic) design tool. The rules of Pseudocode are reasonably straightforward. All statements showing "dependency" are to be indented.

Pseudocode is understood by the programmers of all types. it enables the programmer to concentrate only on the algorithm part of the code development.

Java would use this.

3 0
3 years ago
Write a program that asks the user for three strings. Then, print out whether the first string concatenated to the second string
ipn [44]

Answer:

import java.util.Scanner;

public class num5 {

   public static void main(String[] args) {

       Scanner in = new Scanner(System.in);

       System.out.println("Enter The First String");

       String str1 = in.next();

       System.out.println("Enter The Second String");

       String str2 = in.next();

       System.out.println("Enter The Third String");

       String str3 = in.next();

       String oneAndTwo = str1+str2;

       if(str3.equals(oneAndTwo)){

           System.out.println(str1+" + "+str2+" is equal to "+str3+"!");

       }

       else

           System.out.println(str1+" + "+str2+" is not equal to "+str3+"!");

   }

}

Explanation:

  • Implemented in Using Java Programming Language
  • Import Scanner Class to prompt and receive users' input
  • Create three string variables and store the three values entered by the user (str1, str2 and str3)
  • Concatenate str1 and str2 using the + operator and assign to a new variable
  • Use the if statement with Java's .equals() method to check for equality of the new string with the third string
  • Print the appropriate message if the equal or not
8 0
3 years ago
10 points + brainliest to first correect answer :) incorrect answers/ answers with no effort will be deleted this is easy im jus
Gala2k [10]

Answer:

The first option is incorrect

Explanation:

With the Control+C method, you copy the text. With the Control+V method, you paste it. You do not remove any of the text and instead create a duplicate

6 0
3 years ago
Other questions:
  • Modern car odometers can record up to a million miles driven. What happens to the odometer reading when a car drives beyond its
    8·1 answer
  • The domains of the risk IT framework mutually inform each other, creating flexibility and agility. It is possible to uncover a p
    10·1 answer
  • Given the lists list1 and list2 that are of the same length, create a new list consisting of the last element of list1 followed
    13·1 answer
  • Once the term of copyright has expired,a work
    15·1 answer
  • Who can help me on my school we will to google meet and i share my screen
    5·1 answer
  • Consider the following MARIE Code: 100 If, Load X /Load the first value 101 Subt Y /Subtract the value of Y, store result in AC
    8·1 answer
  • Help!! Best answer will get Brainliest!!
    10·2 answers
  • HELP PLEASE !!!!!!!!!!!! Amy needs to ensure that she can enter a parameter that will match the values End, deadend, and flatend
    8·1 answer
  • Write a function that accepts a pointer to a C-string as an argument and returns the number of words contained in the string. Fo
    13·1 answer
  • How does technology affect our daily lives essay
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!