All categories

3 years ago

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

Computers and Technology

1 answer:

cluponka [151]3 years ago

8 0

Answer:

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

=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.

You might be interested in

What is ment by creative middle way solution

SOVA2 [1]

Looking for a way to resolve conflicting values that comes as close as possible to satisfying all relevant obligation

7 0

3 years ago

80. A .......... is used to read or write data.<br>A. CD B. VDU C. ROM D. RAM

Volgvan

Answer:

Depending on exactly what they mean by read and write, both A and D are valid. In fact, if you read that as "read or write" as being a logical OR and not the logical AND that the sentence probably intends, then all four answers could be correct.

What they probably mean to say though is "..... is used as a read/write storage medium", in which case A is the correct answer.

A. Data can be written to or read from a CD. This is probably the "right" answer

B. A human can "read" data from a Visual Display Unit, and the computer "write" it. That of course is not the intended meaning though.

C. Data can be read from Read Only Memory, but not written to.

D. Data can be both read and written to Random Access Memory, but not retained after the computer is powered off.

8 0

2 years ago

.What particular skills does a team leader need in addition to the other skills needed by any team member. (choose all that appl

omeli [17]

Answer:

encourage and support team members

always keep a vision of the “big picture”

communicate frequently with team members

Explanation:

As a team leader, this is important to motivate and encourage team members to move on are especially needed during the hard time to face some challenges or solving some problems.

Besides, a vision of big picture from the team leader will assure the entire team that they are moving in a right direction to achieve a bigger goal despite they are facing a number of challenges/obstacle.

A team work need frequent communication to minimize misunderstanding and to ensure the job allocation and coordination running smooth as expected. A team leader plays the vital role to be proactive in communication with members to make sure every job arrangement are monitored and on track.

6 0

2 years ago

Running the cpu at a faster speed than the manufacturer recommends is called ________.

laila [671]

Overclocking is forcing the Central Processing Unit to run at a faster speed than the recommended manufacturer setting. While the CPU may function at a higher speed, it is not recommended because it could damage your CPU.

Which would suck, since replacing that small chip tends to be costly.

5 0

3 years ago

write the structure of an email message ques.2 what do you mean by search engine? write its component .ques. 3 what are the adva

loris [4]

Answer:

1.....There is a standard structure for emails. Email contents are primarily classified as two, the header and the body. We are going to see the contents come under the two subparts. The email header gives us common details about the message such as the unique identity of the message.

Explanation:

2......a program that searches for and identifies items in a database that correspond to keywords or characters specified by the user, used especially for finding particular sites on the World Wide Web.

its components are ....

A search engine normally consists of four components e.g. search interface, crawler (also known as a spider or bot),indexer, and database.

3.....Advantages Of eLearning

It is a very efficient way of delivering courses online. Due to its convenience and flexibility, the resources are available from anywhere and at any time. Everyone, who are part time students or are working full time, can take advantage of web-based learning.

hope this will help you ..

please like and mark as brilliant.

4 0

3 years ago