List four useful spreadsheet functions and explain what they do.

Answers

Answer 1

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.


Related Questions

Which type of document is not likely to print well on a laser printer?
Select one:
a. report with numerous high-glossy photographs
b. report with text and basic geometric shapes
c. report with text and some pie charts

Answers

probably C since pie charts aren't really used for laser printers from my knowledge.

Packet-switching was advanced by which of the following people?
Sergey Brin
Leonard Kleinrock
Tim Berners Lee
Bill Gates
DONE

Answers

Answer:

Leonard Kleinrock

Explanation:

Select the correct answer. The color wheel can be a useful tool for finding colors that go well together. A. True B. False

Answers

Answer:

A. True

......................

analyze the ethical issues in the use of information technology in Multinational company (MNC) and support you answer with one example

Answers

Answer:

Explanation:

Multinational Companies tend to have millions of users from all over the globe who use their services and in doing so provide their information. This information gets saved on the databases of these companies. It is then up to the company on how they will use this information. This is where ethicality comes into play. A company can act ethically and protect the information that has been entrusted to them by their user, or they can act unethically and use the users' personal data to make profits. It has recently come to light that some companies have been using users' private data and would sell it to other companies for profit. These buying companies would then use the data for a variety of things such as ad targeting and statistics. These companies profited massively and the actual owners of the data did not, which makes this incredibly unethical.

How are images added to a website? CODING

Answers

Answer:

Depends

Explanation:

This is what I know and I researched some years back

Copy the URL of the image you wish to insert.

Next, open your index. html file and insert it into the img code. Example: <img src=”(your image URL here)”>

Save the HTML file. The next time you open it, you'll see the webpage with your newly added image.

Explanation:

Hi! I also don't know how to add images since im new to the app too, I've read some of the comments from the other answer and i found it really helpful too! Im just answering so that he can get brainliest! And im sorry if im not supposed to answer if i dont know the answer,,

identify and state the value of hardware components​

Answers

Answer:

Explanation:

Hardware is the most visible part of any information system: the equipment such as computers, scanners and printers that is used to capture data, transform it and present it to the user as output. Although we will focus mainly on the personal

what would players do in Mobile legends bang bang report you for while playing The game

Answers

Answer:

For being Annoying

Explanation: because that game sucks.

Fill in the blank to complete the sentence.
If you only want to use the localtime function, you can load just that one function into active memory using the following line of code.

from _______ import localtime()

(Sorry for bad picture) ​

Answers

Answer:

The correct answer is time

Explanation:

from time import localtime()

what are the picture affect features​

Answers

Answer: ????????????????????????????

Explanation:

Write the following functions. Each function needs function comments that describes function and its parameters double sphereVolume( double radius) double sphereSuface( double radius) double cylinderVolume( double radius, double height) double coneSurface( double radius, double height) double coneVolume( double radius, double height) That computes the volume and surface of the sphere with radius, a cylinder with a circular base with radius radius , and height height , and a cone with a circular base with radius radius , and height height . Then write a test program to prompt user to enter values of radius and height, call six functions and display the results c++

Answers

Answer:

Output

height: 10

radius: 2

Cylinder volume: 125.6

Cone Surface: 76.6037

Cone Volume: 41.8667

Sphere volume: 33.4933

Sphere surface: 50.24

Cylinder volume: 125.6

Explanation:

//Declaring variables

#include <iostream>

#include <cmath>

using namespace std;

//Defining Pi value

const double PI=3.14;

//Decliring the functions

//volume function for cone

double volumeCone(double r,double h){

       return  PI * r * r  * (h/3);

}

//volume function for sphere surface

double surfaceSphere(double r){

       return 4 * PI  * r * r;

}

//volume function for cylinderVol

double cylinderVol(double r,double h){

       return  PI * r * r * h;

}

//volume function for sphere volume

double sphereVol(double r){

       return 4/3.0 * PI * r * r * r;

}

//volume function for cone surface

double surfaceCone(double r,double h){

       return  PI * r * (r+sqrt(h *h + r  * r));

}

int main(){

       double r,h;

//print the values of height and radius

       cout<<"height: ";

       cin>>h;

       cout<<"radius: ";

       cin>>r;

//print the values of geometric forms

       cout<<"Cylinder volume: "<<cylinderVol(r,h)<<endl;

       cout<<"Cone Surface: "<<surfaceCone(r,h)<<endl;

       cout<<"Cone Volume: "<<volumeCone(r,h)<<endl;

       cout<<"Sphere volume: "<<sphereVol(r)<<endl;

       cout<<"Sphere surface: "<<surfaceSphere(r)<<endl;

       cout<<"Cylinder volume: "<<cylinderVol(r,h)<<endl;

       

       

}

how do artificial intelligence works?

Answers

Explanation:

AI systems work by combining large sets of data with intelligent, iterative processing algorithms to learn from patterns and features in the data that they analyze. Each time an AI system runs a round of data processing, it tests and measures its own performance and develops additional expertise

AI systems learn from the patterns and features in the data they study by combining vast volumes of data with sophisticated, iterative processing methods.

Each time an AI system processes data, it evaluates and measures its own performance and gains further expertise.

Due to the fact that AI never requires a break, it can perform hundreds, thousands, or even millions of tasks extremely quickly, acquiring a great quantity of knowledge in a short period of time and becoming extremely capable at whatever work it is trained to perform.

However, the key to properly understanding how AI works is to recognize that it is not a single computer program or application, but a complete discipline or science.

The goal of AI science is to develop a computer system capable of imitating human behavior in order to tackle complicated issues using human-like cognitive processes.

AI systems accomplish this goal by utilizing a variety of methodologies and processes, as well as a diverse array of different technology.

Fill in the blank with the correct response.
Fast Ethernet is ______times faster than Ethernet.

Answers

Answer: 100 Mbps

Explanation: Fast Ethernet runs 100 Mbps and Ethernet offers up to 1 Gbps.

Fast Ethernet is 10 times faster than Ethernet.

What is Ethernet?

Metcalfe modified the name to "Ethernet" in 1973. He did this to demonstrate that any computer, not just Alto's, would be supported by the technology he had developed.

He chose the term "Ether" to refer to the physical medium that carries bits to stations, which is a crucial aspect of the system. Fast Ethernet transmission, which is at least 10 times faster than standard Ethernet, helps maintain compatible connections to high-speed servers.

It reduces bandwidth bottlenecks for network systems running multiple IP video cameras and the Internet of Things and supports seamlessly complex networks that simultaneously run a number of bandwidth-hungry software programs.

Therefore, fast Ethernet is 10 times faster than Ethernet.

To learn more about Ethernet, refer to the link:

https://brainly.com/question/13441312

#SPJ2

Choose the correct color to complete the sentence. Colors have different meanings in different cultures. In western cultures the color generally represents purity cleanliness. In many Asian cultures, it is associated with death and mourning,​

Answers

white

i really do hope this helps

TRUE or FALSE.

2.2 Connectivity is the term used to describe the ability to connect to the internet by using a device
such as a computer or cell phone

Answers

Answer:

True

Explanation:

Because it is the very best way to get it done

Write a C program to perform simple C arithmetic calculations. The user is to enter a simple expression (integer operator integer) such as
15 + 30
The program is to extract the 2 operands and the operator, perform the indicated calculation and display the result. For example
15 + 30 = 45
Operators should include + , - , * , / , and %
Operands are positive integers , no sign
Use getchar to input the expression
Allow for variable spacing before the first operands and between operators and operands ( 0, 1, or more spaces)

Allow the user the option of entering another expression
Code a function for each operator to do the appropriate arithmetic operations (5 functions)
No global variables
No string handling functions
No arrays
May only use input and output functions such as getchar and putchar

Answers

Answer:

Input example:

select the funcion: 1                                                                                                                  

write the 1sd number2                                                                                                                  

write the 2nd number1                                                                                                                  

value is 2.000000                                                                                                                      

Explanation:

#include <stdio.h>

main()

{

//define the variables as float

float a, b, c, e;

char d;

while (1)  

{      

//input values

printf("select the function: ");

scanf("%c",&d);

printf("write the 1sd number");

scanf("%f",&a);

getchar();

printf("write the 2nd number");

scanf("%f",&b);

getchar();

if (d=='%')

{

    a=a*b/100;

}

if (d=='*')

{

    a=a*b;

}

if (d=='+')

{

    a=a+b;

}

if (d=='/')

{

    a=a/b;

}

if (d=='-')

{

    a=a-b;

}

printf("value is %f \n",a);

}

printf("final value is %f",a);

getchar();

}

=SUM(A2:A19,013,855,19)
What is the meaning of sum

Answers

Answer:

The answer to this question is given below in the explanation section.

Explanation:

The meaning of the sum is to add the value of the given cells. Basically,the meaning of the sum is the addition of numbers.

For example, in excel write in the formula bar, "=Sum()" its meaning is to add the value of all the given reference cells. As given in the question, "=Sum()" will add the value of the cells A2,A19, O13 and then add into 855 and 19. After all this, show the addition result in the cells where this formula is written.

4.11 LAB: Remove gray from RGBSummary: Given integer values for red, green, and blue, subtract the gray from each value.Computers represent color by combining the sub-colors red, green, and blue (rgb). Each sub-color's value can range from 0 to 255. Thus (255, 0, 0) is bright red, (130, 0, 130) is a medium purple, (0, 0, 0) is black, (255, 255, 255) is white, and (40, 40, 40) is a dark gray. (130, 50, 130) is a faded purple, due to the (50, 50, 50) gray part. (In other words, equal amounts of red, green, blue yield gray).Given values for red, green, and blue, remove the gray part.Ex: If the input is:13050130the output is:80 0 80Find the smallest value, and then subtract it from all three values, thus removing the gray.Note: This page converts rgb values into colors.LAB

Answers

Answer:

Written in Python

rgb = []

colr = []

for i in range(0,3):

     inp = int(input("Input: "))

     if (inp >=0 and inp<=255):

           rgb.append(inp)

     else:

           print("Range is 0 to 255")

           exit()

colr.extend(rgb)

rgb.sort()

for i in range(0,3):

     print(colr[i] - rgb[0])

Explanation:

The next two lines declares two empty lists

rgb = []

colr = []

The following iteration lets user input into rgb list

for i in range(0,3):

     inp = int(input("Input: "))

     if (inp >=0 and inp<=255):

           rgb.append(inp)

     else:

           print("Range is 0 to 255")

           exit()

This line copies the content of rgb to colr

colr.extend(rgb)

This line sorts list rgb

rgb.sort()

This iteration calculates and prints the difference between each individual input and the smallest of the inputs

for i in range(0,3):

     print(colr[i] - rgb[0])

CHALLENGE ACTIVITY 5.2.3: Basic while loop expression. Write a while loop that prints userNum divided by 4 (integer division) until reaching 2 or less. Follow each number by a space. Example output for userNum = 160: 40 10 2 Note: These activities may test code with different test values. This activity will perform four tests, with userNum = 160, then with userNum = 8, then with userNum = 0, then with userNum = -1. See "How to Use zyBooks". Also note: If the submitted code has an infinite loop, the system will stop running the code after a few seconds, and report "Programend never reached." The system doesn't print the test case that caused the reported message.

Answers

Answer:

input with 160

output: 40 10 2

Explanation:

import java.util.Scanner;

//Define the class divideFour

public class divideFour

{

  public static void main(String[] args)

  {

      //Declaration of variables as integer

      int userNum;

      //set an input

      userNum = 160;

      //Run the while loop until the conditions are not satisfied.

      while(userNum>2)

      {

          //Divide userNum by 4 and store it in the same.

          userNum = userNum/4;

          //Print the new value of the userNum

          System.out.print(userNum+" ");

      }

      System.out.print("");

  }

}

if i press the home button of the phone so it opens but how it opens?
Please answer with explanation ​

Answers

Answer:

by its system software

Explanation:

it is programmes by programmers like that its language is binary (0,1) so thats y when we switch it it gets to on just because that button is programmed like that if the home button wasn't on the mobile the mobile would not work it would be useless...

Help me with this plzz

Answers

Answer:

the 1st one I believe

Explanation:

because plagiarism means to copy someone else work without permission. Example- if you are writing an essay and copy something off the internet and call it your own that's plagiarism

Answer:

Yeap you are right. The correct ans is the 1st one.

Plagiarism is the representation of another author's language, thoughts, ideas, or expressions as one's own original work.

With respect to computer hardware, what is a major difference between Mac OS and Windows or Linux?

Answers

Answer:

Key Differences Between Linux and MAC and Windows

Windows is dominant over the other two as 90% of users prefer Windows. Linux is the least used operating system with users accounting for 1%. ... MAC is costlier than Windows and the user is forced to buy a MAC system built by Apple.

Submit your interview questions in preparation for your interview

Answers

Answer:

Preparing for an interview...Get my certifications, TWIC card, Certificates, diplomas together.

Carefully examine the job description. ... chemical plant project manager requirements- experience and education

Consider why you are interviewing and your qualifications. ... 10+ years of experience, education requirements, location, certificates, enjoying this kind of work

Perform research on the company and role. ... The company is respectful and they are very good to their employees and their employee's families.  The company even has a charity in which it helps its employees in times of need. I make sure I know my role and responsibilities as in I keep track of the crew that works under me and their work and safety. Also, in knowing my job, I make sure we make it to deadlines we are given and keep the companies we work for happy with following their rules also.  I need to be respectful and responsible at all times.

Consider your answers to common interview questions. ... I will come to the interview reviewing my job duties and studying the type of chemical plant I want to work in and the hazards I may have to be aware of.

Practice your speaking voice and body language... I will come dressed appropriately and not in flip flops. I will have my shoulders raised and speak clearly.  I will chose my words wisely. I will show respect and determination. I will not cross my arms nor put my hands in my pockets.  I will not use vulgar or offensive language. I will answer all questions truthfully and to the best of my knowledge.

Explanation:

The interview questions preparation for interview are that common questions to asked for the candidate.

What is interview?

The term interview refers to a formal meeting with the involvement of two people as interviewer and interviewee. The interviewer is one who asks questions and the interviewee is one who answers questions. The conversion is related to the skills, knowledge, and experience related to the job.

According to the preparation for interview are the common question was the based on the interview. The portfolio contains information related to achievements, skills, knowledge, working experiences, and some personal details. The portfolio has a significant role to play in job interviews. The portfolio related question are the mainly prepared.

As a result, the interview questions preparation for interview are that common questions to asked for the candidate.

Learn more about on interview, here:

https://brainly.com/question/13073622

#SPJ2

Use python
def exec_2(f):
f()
f()
any function that is passed into exec_2() will be executed twice without parameters. Your task is to write a function exec_4(f) that takes in a function f as a parameter and executes the function f 4 times using the function exec_2. The function f in this case will draw a cute koala bear, and, in conjunction with, exec_4(), you will draw 4 koalas on the same tree! Suppress the newline in the print statement for the koala, this can be done using print's end argument
def exec_2(f):
f()
f()
def exec_4(f):
# define this function using exec_2
# define a new function here that prints out the koala once
# use your function and exec_4 to draw 4 koala bears!

Answers

Answer:

Here is the Python program:

def exec_2(f):

    f()

    f()

   

def exec_4(f):

    exec_2(f)

    exec_2(f)

   

def print_koala():

    print("koala")    

exec_4(print_koala)

Explanation:

The program works as follows:

First method:

def exec_2(f):

f()

f()

any function that is passed into exec_2() will be executed twice without parameters.

Second method:

def exec_4(f):

    exec_2(f)

    exec_2(f)

function exec_4(f) takes in a function f as a parameter and executes the function f 4 times using the function exec_2. At first exec_2(f) call the function f is executed twice and and second exec_2(f) call the function f is again executed twice so the function f executes 4 times in total.

Third method:

def print_koala():

    print("koala")  

a function that prints out the koala once

This function has a print statement which is passed the string koala to print on output screen.

exec_4(print_koala)

function exec_4 is used to print koala four times. This function exec_4 takes as argument the function print_koala() So this works as follows:

exec_4(print_koala)

The body of exec_4 executes as:

exec_2(print_koala)

exec_2(print_koala)

Now at first call to exec_2(print_koala) the program moves to the function exec_2 which executes print_koala()  method twice. Since print_koala() method has a print statement print("koala") so this is executed twice:

koala                                                                                                                                           koala

Now at second call exec_2(print_koala) the program moves to the function exec_2 which executes print_koala()  method twice again. Since print_koala() method has a print statement print("koala") so this is executed again twice:

koala                                                                                                                                           koala

So the output of the entire above program is:

koala                                                                                                                                           koala                                                                                                                                           koala                                                                                                                                           koala

The screenshot of program along with its output is attached.

1. What is a program? Please answer properly it doesnt matter how long it takes. ill give brainliest if you want just ask! :3

Answers

Answer:

A program is a type of app used for coding and programming. It is also a real-life term for a system that helps people with problems and issues they cannot fix by themselves.

use the __________ to measure small amount of liguid

Answers

The volumetric flask is use to measure

differences between the first four generations of computers​

Answers

Answer:

Explanation:

These first generation computer were mainly used for scientific computations. Some examples of these computers are ENIAC, EDVAC, EDSAC, UNIVAC I and IBM 701.

Which of the following hardware devices could you install without having to hire an experienced professional? Check all of the boxes that apply.

external hard drive

internal hard drive

external speakers

RAM

video card

MP3 player

Answers

The hardware devices that can be installed without hiring an experienced professional are as follows:

external hard driveexternal speakersMP3 player

What are hardware devices?

The hardware devices is the external device that is connected to the computer system. It helps to either give inputs or take outputs from the computer system.

The examples of hardware devices are external hard drive, external speaker, and MP3 player that does not require any technical person for their connection.

Learn more about hardware devices, here:

https://brainly.com/question/26475462

#SPJ2

Which step do you think is most useful from big data life cycle and why?

Answers

Answer:

Big data lifecycle consists of four phases: data collection, data storage, data analysis, and knowledge creation. Data collection phase consists of collecting data from different sources. In this phase, it is important to collect data from trusted data sources.

I think business cases analysis is useful step because (BCA) provides a best-value analysis that considers not only cost but other quantifiable and non-quantifiable factors supporting an investment decision. This can include but is not limited to, performance, producibility, reliability, maintainability, and supportability enhancements

Explanation:

mark me brainliest

When James added a date field to a PivotTable, Excel grouped the date values into quarters, months, and years. He does not want to group the data this way, so he clicks the Remove button on the PivotTable Tools Analyze tab.

a. True
b. False

Answers

When James clicks the Remove button on the PivotTable Tools Analyze tab is a true statement.

What is PivotTable?

A PivotTable is known to be a kind of interactive method that is used to quickly make a summary of large amounts of data.

Note that this table is one that a person can use to analyze numerical data thoroughly and it is known to be one that answer quick and unplanned questions about one's data.

Note that one can  remove the set date field without having any effect on the year or quarter fields.

Learn more about PivotTable from

https://brainly.com/question/15214258

When you create a calculated item for a field in a PivotTable, it appears as a new item within the field. Question 4 options: True False

Answers

When you create a calculated item for a field in a PivotTable, it appears as a new item within the field is a false statement.

What is a calculated item in a pivot table?

A Calculated Item is known to be a kind of custom formula that is seen in an Excel pivot table.

It is known to be one that can use the sum of other items in the same field. For example, when a person calculate the sum of 2 other items in a field. Note that Calculated items are not depicted or shown in the PivotTable Field List.

Learn more about PivotTable from

https://brainly.com/question/15214258

Other Questions
What is an equation of the line that passes through the points (4,8)(4,8) and (2,7)(2,7)? What is the formula for finding the molar mass of water?A.mass of H + 2 + mass of OB.mass of H x 2 + mass of OC.mass of H + mass of O x 2D.(mass of H + mass of O) x 2 Gina wants to help cut back on the large levels of air pollution in her city. Which of the following steps should shetake?A use public transportation systems less oftenB. purchase a less fuel-efficient vehicleC. try to use her city's bus system more oftenD. drive her personal car as often as possible to help raise emissions A triangle has a base of 14 centimeters and a height of ( 3x - 4 ) centimeters . The area of the triangle is greater than 56 centimeters . Solve the inequality 1/2 (14) ( 3x - 4 ) > 56 to find the possible values of x??? show your work please The chemical colchicine disrupts cell division. which cell process would most likely stop if colchicine were added to a culture of human liver cells? Suppose you are spinning a child around in a circle by her arms. Theradius of her orbit around you is 2 meter. Her speed is 5 m/s. Her massis 20 kg. What is the magnitude and direction of tension in her arms? You bought 100 shares of stock at $15 per share. You sold your 100 shares at $21.75 per share. Calculate your totalprofit from the sale. What is the division expression that is the same as 1/9 divided by 5?1/9 x 59/1 x 5/11/9 x 1/5 Can somebody list only 2 ways whales are different from fish?(Make it only like 1 sentence)(WILL MARK BRAINLIEST):D Which group of words shows acause/effect relationship.Owithin the limitsin order to The area of a sector of a circle with a central angle of 6pi/5 rad is 31 km2.Find the radius of the circle.r =km Japanese-americans living on the west coast of the united states in early 1942 were sent to internment camps on the alleged grounds that they. HelpppppHong Kong is part of China. But people in Hong Kong have more freedoms than people in mainland China. Why might the Chinese government want to limit the freedoms of the people of Hong Kong? Once you have come to a decision, you should "go" over it and __________. a. determine if you need to make changes b. determine if there were unintended consequences c. determine if the outcome was intended d. all of the above please select the best answer from the choices provided. a b c d What does Banquo suspect of Macbeth when he says that (Macbeth) play'd most foullyfort" The first phase of the selling process involvesto sell. HELP please ASAP pls... Q. no. 1a. Find the product of x2 * x in exponential form. The Nobel Prize-winning economist Oliver Hart once said, "If we know the marginal social cost [of pollution] emissions, a tax is better, but if we know the optimal quantity, cap and trade is better. " Given this statement and the knowledge of ways governments can intervene in markets, evaluate the following statement: Any outcome that can be achieved by taxing can also be accomplished by establishing a quota. This is because a. If we know the marginal social cost, we can set the optimal quantity equal to the optimal price. If we know the optimal quantity, we can set a quota equal to the optimal price. b. If we know the marginal social cost, we can set the tax so that price is equal to the optimal price. As a result, the optimal quantity will be achieved. If we know the optimal quantity, we can set a quota and the market will find the optimal price. c. Knowing the marginal social cost allows companies to know how much to increase their prices and make more profits. This is better for the economy as a whole because then companies can create more jobs. Cap and trade restricts quantity, which lowers profits. d. If we know the optimal quantity, cap and trade can be used to set the price. If we know the marginal social cost, a tax can be used to set the quantity Match the description to the character.1. Helen's half brother Captain 2. Helen's mother Kate 3. Helen's father doll 4. Annie Sullivan's brother Jimmy 5. first word spelled for Helen James 6. Annie Sullivan's teacher Mr. Anagnos