All categories

1 year ago

If the cell B2 is 68, what will this IF function

1 answer:

8 0

If the cell B2 is 68, this IF function "=IF (B2>60, 'pass', 'fail')" will give pass as a result because 68 is greater than 60.

<h3>What is Microsoft Excel?</h3>

Microsoft Excel can be defined as a software application that is designed and developed by Microsoft Inc., for analyzing and displaying spreadsheet documents by using rows and columns in a tabulated format.

<h3>The types of function in MS Excel.</h3>

In Microsoft Excel, there are different types of functions that are called predefined formulas and these include the following:

Average function
Minimum function
Sum function
Maximum function
Count function
IF function

If the cell B2 is 68, this IF function "=IF (B2>60, 'pass', 'fail')" will give pass as a result because 68 is greater than 60.

Read more on Excel formula here: brainly.com/question/26053797

#SPJ1

Complete Question:

If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')

You might be interested in

Write a brief explanation of the problems that can occur in each of the following scenarios and what you should do to avoid thes

photoshop1234 [79]

1. Horsing around can lead to breaking equipment in the classroom or somebody getting hurt

2. leaving your backpack on the floor can cause someone to fall

3.something unexpected may happen and worsen the problem

4. it can corrupt the computer's files and deleted unsaved work.

if you want the sentences to be longer, add some words to them and make the message the same.

4 0

4 years ago

During the _______ steps of the information processing cycle, data is manipulated, calculated, or organized to create useful inf

labwork [276]

Answer: processing

Explanation:

During the processing steps of the information processing cycle, data is manipulated, calculated, or organized to create useful information.

At this stage, the data that has been gotten will have to be worked on by manipulating it, making necessary calculations in order to get a useful information out of it.

6 0

3 years ago

Design and implement a program to display each directory entry information (files and directories) of current directory, and wit

FromTheMoon [43]

Answer: The code below can display directory as stated in the question

Explanation:

char *

gnu_getcwd ()

{

size_t size = 100;

while (1)

{

char *buffer = (char *) xmalloc (size);

if (getcwd (buffer, size) == buffer)

return buffer;

free (buffer);

if (errno != ERANGE)

return 0;

size *= 2;

}

3 0

3 years ago

Health informatics is an interdisciplinary field which incorporates theory and methodology from fields in computer science. True

noname [10]

Health informatics is an interdisciplinary field which incorporates theory and methodology from fields in computer science is True.

True

<u>Explanation:</u>

To capture patient health information they used interdisciplinary field which is consists patient information and they diseases and cure treatment taken for that patient. All information is store in digital formatted.

The patient information is stored such as health informatics, nurse and doctor treatment, health treatment, medicine details, clinics information.

Health informatics are used to do further analysis on patient health. Doctors are using this information for their further treatment for their patient also.

Information are also can be used as IOT information so that patient information are readily available.

3 0

4 years ago

5) How is the operating system on a desk top computer different from the operating system on a smart phone?

lesya692 [45]

The difference is that system on a desk top preforms all the basic tasks like file management, memory management handling input and output and controlling peripheral devices such ad disk and printers where as some smart phone work on specific hardware

6 0

3 years ago