The icon below represents the ___________

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

3 years ago

Given the following structure and variable definitions, struct customer { char lastName[ 15 ]; char firstName[ 15 ]; unsigned in

garri49 [273]

Answer:

see explaination

Explanation:

a)

customerRecord.lastName

b)

customerPtr->lastName or (*customerPtr).lastName

c)

customerRecord.firstName

d)

customerPtr->firstName or (*customerPtr).firstName

e)

customerRecord.customerNumber

f)

customerPtr->customerNumber or (*customerPtr).customerNumber

g)

customerRecord.personal.phoneNumber

h)

customerPtr->personal.phoneNumber or (*customerPtr).personal.phoneNumber

i)

customerRecord.personal.address

j)

customerPtr->personal.address or (*customerPtr).personal.address

k)

customerRecord.personal.city

l)

customerPtr->personal.city or (*customerPtr).personal.city

m)

customerRecord.personal.state

n)

customerPtr->personal.state or (*customerPtr).personal.state

o)

customerRecord.personal.zipCode

p)

customerPtr->personal.zipCode or (*customerPtr).personal.zipCode

6 0

3 years ago

Easter Sunday is the first Sunday after the first full moon of spring. To compute the date, you can use this algorithm, invented

BlackZzzverrR [31]

Answer:

The program written in Java without comment is as follows

import java.util.*;

public class MyClass {

public static void main(String args[]) {

Scanner input = new Scanner(System.in);

System.out.print("Year: ");

int y = input.nextInt();

int a = y%19;

System.out.println("a = "+a);

int b = y / 100;

System.out.println("b = "+b);

int c = y%100;

System.out.println("c = "+c);

int d = b / 4;

System.out.println("d = "+d);

int e = b%4;

System.out.println("e = "+e);

int g = (8 * b + 13)/25;

System.out.println("g = "+g);

int h = (19 * a + b - d - g + 15)%30;

System.out.println("h = "+h);

int j = c/4;

System.out.println("j = "+j);

int k = c%4;

System.out.println("k = "+k);

int m = (a + 11 * h)/319;

System.out.println("m = "+m);

int r = (2 * e + 2 * j - k - h + m + 32)%7;

System.out.println("r = "+r);

int n = (h - m + r + 90)/25;

System.out.println("n = "+n);

int p = (h - m + r + n + 19)%32;

System.out.println("p = "+p);

}

Explanation:

<em>I've added the full source code as an attachment where I use comments to explain difficult lines</em>

Download java

7 0

4 years ago

A company asked you help mitigate the brute force attacks carried out against its users' Windows account passwords. You successf

alexdok [17]

Answer:

a. Require user account passwords

e. Set failed logon restrictions

b. Require strong passwords

Explanation:

3 0

3 years ago

Fire stick optimizing system storage and applications

vivado [14]

Answer:

IN MY PROFILE

Explanation:

I HAVE AWNSERED THIS QUESTION THROUGHOUT MY BEING HERE PLEASE DO NOT BE AFRAID TO CLICK ON MY PROFILE AND FIND THE ANSWER

5 0

3 years ago

The icon below represents the ____________.