Match the part of motherboard to its function

I have been trying to work on this for a while now, and this is on excel

cluponka [151]

Answer:

=IF(INDEX(INDIRECT(C10), B10)=0,"",INDEX(INDIRECT(C10), B10))

Or

=IF((INDEX((INDIRECT(Dept,TRUE)),Reason))="","",(INDEX((INDIRECT(Dept,TRUE)),Reason)))

Explanation:

Given

Your formula:.

=INDEX(INDIRECT("Dept"),Reason)

Dept column = C (C10)

Reason field = B (B10)

The issue with your formula is that you failed to include a statement to test the falsity of the first condition; in other words, if your if statement is not true, what else should the formula do.

The question says that

"Nest the function inside an IF function so that issues currently displaying as a 0 will display as a blank cell" this means that

if the INDEX() function returns 0, a blank should be displayed in H10 blank, instead.

So, the right formula both of these two. You can use any of them

1. =IF(INDEX(INDIRECT(C10), B10)=0,"",INDEX(INDIRECT(C10), B10))

2. =IF((INDEX((INDIRECT(Dept,TRUE)),Reason))="","",(INDEX((INDIRECT(Dept,TRUE)),Reason)))

The two does the same function; the only difference is that

(1) considers the cell itself while (2) considers the contents of the cell.

The analysis of both is that

They both use a nested indirect reference to check for the content of cells displaying 0.

The first if checks for the above mentioned; if yes, cell H10 is made to display a blank else it's original content is displayed.

8 0

2 years ago

The hottest part of the Earth is the

Troyanec [42]

C. Mantle would be correct

3 0

2 years ago

Read 2 more answers

Write a test program that prompts the user to enter three sides of the triangle (make sure they define an actual triangle), a co

Ivanshal [37]

Answer:

Scanner in = new Scanner(System.in);

System.out.print("Please enter 3 sides of a triangle, color and " +

"whether it is filled or not (true false): ");

double s1 = in.nextDouble();

double s2 = in.nextDouble();

double s3 = in.nextDouble();

String color = in.next();

boolean filled = in.nextBoolean();

Triangle t1 = null;

try {

t1 = new Triangle(s1, s2, s3, color, filled);

}

catch (IllegalTriangleException ite) {

System.out.println(ite.toString());

}

System.out.println(t1.toString());

System.out.printf("Triangle color: %s, Triangle filled: %s%n" +

"Area: %.2f%n" +

"Perimeter: %.2f%n%n",

t1.getColor(),

t1.isFilled(),

t1.getArea(),

t1.getPerimeter());

Explanation:

Scanner in = new Scanner(System.in);

System.out.print("Please enter 3 sides of a triangle, color and " +

"whether it is filled or not (true false): ");

double s1 = in.nextDouble();

double s2 = in.nextDouble();

double s3 = in.nextDouble();

String color = in.next();

boolean filled = in.nextBoolean();

Triangle t1 = null;

try {

t1 = new Triangle(s1, s2, s3, color, filled);

}

catch (IllegalTriangleException ite) {

System.out.println(ite.toString());

}

System.out.println(t1.toString());

System.out.printf("Triangle color: %s, Triangle filled: %s%n" +

"Area: %.2f%n" +

"Perimeter: %.2f%n%n",

t1.getColor(),

t1.isFilled(),

t1.getArea(),

t1.getPerimeter());

7 0

3 years ago

Why is data processing done in computer

oksian1 [2.3K]

Answer:

Explanation:

Data processing occurs when data is collected and translated into usable information. Usually performed by a data scientist or team of data scientists, it is important for data processing to be done correctly as not to negatively affect the end product, or data output.Any use of computers to perform defined operations on data can be included under data processing.

6 0

2 years ago

URLs are the global ______ of resources on the Internet.

adell [148]

I believe the answer might be addresses
<span />

4 0

3 years ago

Read 2 more answers