All categories

3 years ago

What category of predefined formulas in Excel contains the Boolean functions?

1 answer:

5 0

The predefined formulas in Excel that contain the Boolean functions fall under the Logical Functions category. The Boolean functions consist of "AND", "OR", "XOR", "NOT", "IF", "IFERROR" and "IFNA". When you need to use an Excel Function, you can type the function into the cell. You also need to add the arguments for the function in between brackets. If the function is complex or you are a beginner user, there is a function inputting tool which will help you choose which function you require.

You might be interested in

Match each logical function with its description. AND COUNTIF SUMIF IF tests for a certain condition and returns one of two valu

lakkis [162]

1. IF
2. AND
3. COUNTIF
4. SUMIF

4 0

4 years ago

It is very difficult to enter the stock and microstock photography area. True False

podryga [215]

Answer:

False.

It is not very difficult to enter the stock and microstock photography area.

Explanation:

Micro stock photography is the term given to the the photo industry with royalty free or very low priced photographs.
After you get accepted in the industry you can easily start sharing your photographs in the stock photography field.
You can send your sample on the stock photography websites like, Shutterstock.
Overall if you have that skill and passion, it is not that hard job to become a stock photographer.

5 0

4 years ago

8. To be a Bunk Leader, a staff member must have over 4 service years and have completed leadership training. In cell L2, enter

Nitella [24]

Answer:

=IF(AND([Service Year]>4,[Leadership Training]="Yes"),"Yes","No")

Explanation:

To make use of structured references, a table has to be defined (created). Assume that the table definition is as follows;

Staff --- Service Year --- Leadership Training --- Status

In cell L2, type the above formula

Analyzing the formula:

=; An Excel formula must start with an = sign

IF; This signifies that the formula is an "IF" function

AND; This signifies that there are more than one condition in thee formula and all conditions must be true

[Service Year]>4; The question requires that the formula uses a structured referencing. Structured referencing is such that the columns of a table are called instead of cell names;

Here, reference is being made to [Service Year] because Service Year is a column name and its value must be greater than 4

[Leadership Training]="Yes"; The above analysis is applicable here too because Leadership Training is column name and it must be "Yes" for it to return a true value.

"Yes"; Return Yes if both conditions are true

"No"; Otherwise, return No.

4 0

4 years ago

A typical pda includes a(n) _____.

Ratling [72]

A.External Monitor.Hope I helped.

5 0

4 years ago

Read 2 more answers

Write a Dice Game program that generates two random dice values between 1 and 6 for you, and 2 for the computer. You get to roll

charle [14.2K]

Answer:

#include <iostream>

#include <time.h>

#include <string>

using namespace std;

int main(){

srand(time(NULL));

cout<<"Throw dice"<<endl;

int b =0;

int a=0;

a=rand()%6;

b=rand()%6;

for (int i =0;i<1;i++)

{cout<<"dice one: "<<a<<endl;}

for (int i =0;i<1;i++)

{cout<<"dice two: "<<b<<endl;}

if(a>b)

{cout<<"first dice won"<<endl;}

if(b>a)

{cout<<"second dice won"<<endl;}

else{cout<<"they are same"<<endl;

return main();

}

return 0;

}

Explanation:

/*maybe it help you it is almost done*/

6 0

3 years ago