All categories

3 years ago

List four useful spreadsheet functions and explain what they do.

Computers and Technology

1 answer:

Helen [10]3 years ago

8 0

Answer:

SUM, AVERAGE, MAX,MIN

Explanation:

Sum: The SUM function is categorized under Excel Math and Trigonometry functions. ... The function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel. SUM helps users perform a quick summation of specified cells in MS Excel.

Average: The AVERAGE function in Excel does exactly what you think it should. It computes the mathematical average of a set of numbers. In other words, it adds up a set of numbers and then divides the sum by how many numbers are being averaged.

Max: he MAX function will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values. In financial analysis, MAX can be useful in calculating the highest score, the fastest time, the highest expense or revenue amount, etc.

Min: will return the minimum value in a given list of arguments. From a given set of numeric values, it will return the smallest value. Unlike the MINA function, the MIN function ignores numbers, text, and logical values TRUE and FALSE and text values. In financial modeling.

You might be interested in

The concepts of ________________, _________________, and _________________ for covert acts are pivotal to understanding state-on

DIA [1.3K]

The concepts of Power, anonymity and political utility for covert acts are pivotal to understanding state-on-state interactions within cyberspace.

<h3>What is Anonymity?</h3>

Anonymity describes cases where the interim person's identity is anonymous.
Some writers have argued that anonymity, though technically accurate, does not capture what is more centrally at stake in contexts of anonymity.
The essential concept here is that an individual is non-identifiable, unavailable, or untrackable.
Anonymity is seen as a technique, or a way of realizing, sure other values, such as solitude, or liberty.
Over the past few years, anonymity tools used on the dark web by offenders and harmful users have drastically changed the ability of law enforcement to use conventional surveillance Techni.

To learn more about Anonymity, refer to:

brainly.com/question/28115737

#SPJ4

3 0

1 year ago

Which type of network topology is the most common and easiest to use?

Airida [17]

<span>A network layout or topology that is the most common, the most simple and easiest to use out of the four network topologies is the Bus topology, one cable is used for installation so it is also the cheapest network type.</span>

5 0

4 years ago

Create and apply a CSS class named YellowBackground that selects a yellow background. Apply the class to your HTML file’s body t

RSB [31]

<!DOCTYPE html>

<html>

<head>

<title>Page Title</title>

</head>

<style>

.YellowBackground {

background-color:yellow;

}

</style>

</body>

</html>

Like this?

7 0

3 years ago

What is the default file name in Word??? Plzzzz help me!!!!!

kondaur [170]

If your document does not have any text in it and you haven't set the “Title” property, Word inserts “DocX.docx” as the file name, where the “X” is a number that depends on how many new documents you have created during your current Word session.

7 0

3 years ago

Read 2 more answers

Explain any two from 7cs communication<br>

LuckyWell [14K]

Answer:

it is be concise and be coherent

7 0

3 years ago