All categories

2 years ago

What is the formula equivalent to the function =SUM(B1:B5)?

Computers and Technology

2 answers:

bulgar [2K]2 years ago

8 0

Answer:

Option(c) i.e "=B1+B2+B3+B4+B5" is the correct answer for the given question.

Explanation:

The sum function in Microsoft Excel is used to calculate the sum of the cell This function is used to adding the two or more rows. The sum is the aggregate function which gives it gives a single value for the entire column in the microsoft excel.

We can use the sum function in Microsoft excel in the following methods

SUM(B1: B5): it sums the cell from cell B1 to B5 it may also be written as =B1++B2+B3+B4+B5.

posledela2 years ago

6 0

You have the correct answer selected!

You might be interested in

Catherine wants to search online for fruit juices. She is fine with aerated or fresh fruit juices. Which Boolean operator will e

ZanzabumX [31]

<h2>Answer:</h2>

<u>She will use the </u><u>OR Boolean operator</u>

<h2>Explanation:</h2>

Boolean Operators are used to connect and define the relationship between your search terms. Doing searching in any electronic databases like Google search engine, we use Boolean operators to either narrow or broaden our searches. The three Boolean operators are AND, OR and NOT. Among these operators OR is used to add the items. Since Catherine is searching for aerated or fresh fruit juices so she needs both the results therefore she must use OR operator.

8 0

2 years ago

Read 2 more answers

A computer has 4 GB of RAM of which the operating system occupies 512 MB. The processes are all 256 MB (for simplicity) and have

Afina-wow [57]

Answer:

$1-p^{14} = 0.99$

$p^{14}= 0.01$

$p =(0.01)^{1/14}= 0.720$

So then the value of the maximum I/O wait that can be tolerated is 0.720 or 72 %

Explanation:

Previous concepts

Input/output operations per second (IOPS, pronounced eye-ops) "is an input/output performance measurement used to characterize computer storage devices like hard disk drives (HDD)"

Solution to the problem

For this case since we have 4GB, but 512 MB are destinated to the operating system, we can begin finding the available RAM like this:

Available = 4096 MB - 512 MB = 3584 MB

Now we can find the maximum simultaneous process than can use with this:

$\frac{3584 MB}{256 MB/proc}= 14 processes$

And then we can find the maximum wait I/O that can be tolerated with the following formula:

$1- p^{14}= rate$

The expeonent for p = 14 since we got 14 simultaneous processes, and the rate for this case would be 99% or 0.99, if we solve for p we got:

$1-p^{14} = 0.99$

$p^{14}= 0.01$

$p =(0.01)^{1/14}= 0.720$

So then the value of the maximum I/O wait that can be tolerated is 0.720 or 72 %

3 0

2 years ago

Write a static method named countLastDigits that accepts an array of integers as a parameter and examines its elements to determ

Crazy boy [7]

Answer:

See explaination for the program code

Explanation:

code:

public static int[] countLastDigits(int[] list) {

int[] count = new int[10];

for (int i = 0; i < list.length; i++) {

int digit = list[i] % 10;

count[digit]++;

}

return count;

}

8 0

2 years ago

The OSI security architecture provides a systematic framework for defining security attacks, mechanisms, and services. True or F

Alex Ar [27]

Answer:

True is the correct answer for the above question

Explanation:

The OSI security architecture is a security framework that is used to secure the data packets when it is going to transfer on the internet for communication.
It is used to define the security rules and mechanism which need to secure the data packets.
It mainly focuses on Security services, Security attacks, Security mechanisms.
The above question-statement states about the framework which defines the security mechanism to secure from the attacks are known as OSI Security architecture which is the correct statement which is described above. Hence True is the correct answer.

3 0

2 years ago

Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside

podryga [215]

Answer:

Explanation:

To develop the model for Creating the supertype/subtype relationship three diffrent types of notation is given bellow accrdig to the diagram attached.

1.Traditional EER (Enhance Entity-Relational) notation

2.Microsoft Visio notation

3.Subtypes Inside supertype note

<em><u>Traditional EER(Enhance Entity-Relational)notation for the international school of technology diagram is attached bellow</u></em>

The diagram consist of the following entity

Room Supertype

Media Entity Type

COURSE entity type

Section weak entity type

Schedule associatiative entity type

<u><em>Microsoft Visio Notation for the international school of technology is ashown in the diagram bellow.</em></u>

The diagram consist of the following entity

Room Supertype

Media Entity Type

Computer entity type

Instructor entity type

Time slot entity type

<u><em>Subtype Inside Supertype note Notation for the international school of technology is shown in the diagram bellow.</em></u>

The diagram consist of the following entity

Room Supertype

Media Entity Type

Computer entity type

Instructor entity type

Time slot entity type

3 0

2 years ago