All categories

3 years ago

Enter a formula in cell b7 to calculate the average value of cells b2:b6

1 answer:

7 0

The answer is =AVERAGE(B2:B6)
Or, you can just go to "HOME" tab, then click the arrow down next to AutoSum, click the AVERAGE, then select B2:B6.
Average, which is also called arithmetic mean,can be calculated manually by adding all the numbers in a set, then dividing the count of the numbers in a set. But, in excel, there are shortcut formulas to calculate it.

You might be interested in

What is a disruptive technology? Give an example of an aspect of society that has been impacted by technological change.

Ray Of Light [21]

Answer:

A disruptive technology sweeps away the systems or habits it replaces because it has attributes that are recognizably superior. Recent disruptive technology examples include e-commerce, online news sites, ride-sharing apps, and GPS systems.

4 0

2 years ago

Which of the following best describes a server?

Lady_Fox [76]

Answer:

number 4

Explanation:

7 0

2 years ago

Read 2 more answers

1,2,3,4,5,6,7,8,9,10 – Best case - Sorted in ascending order

Pepsi [2]

Using the knowledge in computational language in python it is possible to write a code that from a random number draw creates an order of increasing numbers

<h3>Writting the code in python:</h3>

def shellSort(array, n):

# Rearrange elements at each n/2, n/4, n/8, ... intervals

interval = n // 2

while interval > 0:

for i in range(interval, n):

temp = array[i]

j = i

while j >= interval and array[j - interval] > temp:

array[j] = array[j - interval]

j -= interval

array[j] = temp

interval //= 2

data = [10,9,8,7,6,5,4,3,2,1]

size = len(data)

shellSort(data, size)

print('Sorted Array in Ascending Order:')

print(data)

See more about python at brainly.com/question/18502436

#SPJ1

5 0

1 year ago

HINTS;

ExtremeBDS [4]

Good job! please mark as branliest?!

4 0

2 years ago

A network administrator is planning redundant devices and cabling in a switched network to support high availability. Which bene

a_sh-v [17]

Answer:

Redundant paths can be available without causing logical Layer 2 loops.

Explanation:

Spanning Tree Protocol is used to allow redundancy in the Layer 2 switched networks without creating cycles/circles also called loops.
These loops are called physical loops.
When two parts of the switched network are connected via two or more Layer 2 switches this result in a loop.
This affects the performance of the network as the result of broadcast packets flooding.
STP puts one port of the switch to forward mode and the rest of the ports within the same part of the network to the blocking mode to avoid broadcast packet flooding. STP puts all the ports that are allowing redundant paths to block mode and the one port that is left after this is placed in forward mode.
Spanning Tree Algorithm is used by STP to determine the optimal path of switch to the network.
Bridge Protocol Data Units are used to share the information about the optimal path determined by the spanning tree algorithm with other switches.
This information helps STP to eliminate the redundant paths.
So this is how STP tracks all the links in the switched network and eliminates redundant loops by allowing only one active path to the destination while blocking all other paths.

7 0

2 years ago