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

What is netbeans and what is it for??

egoroff_w [7]

Answer:

NetBeans is an open-source integrated development environment (IDE) for developing with Java, PHP, C++, and other programming languages. NetBeans is also referred to as a platform of modular components used for developing Java desktop applications.

Explanation:

I know

4 0

3 years ago

Write an algorithm that receives a number from the user (you can store the number in a variable called N). Then the algorithm sh

lbvjy [14]

Answer:

Algorithm:

1. Declare an integer variable N.

2. Read the value N from user.

3.While(N):

3.1 find r=N%10;

3.2 print r in new line.

3.3 Update N as N=N/10.

4.end program.

Implementation in C++.

// header

#include <bits/stdc++.h>

using namespace std;

// main function

int main()

{

// variable

int N;

cout<<"Enter an Integer:";

cin>>N;

// find the digits of number

while(N)

{

// last digit

int r=N%10;

// print last digit

cout<<r<<endl;

// update the number

N=N/10;

}

return 0;

}

Output:

Enter an Integer:329

7 0

3 years ago

What command do you type in the search box to access the command line intrface in windows?

Whitepunk [10]

Cmd.exe

------------------------------------------

3 0

3 years ago

Write a function that accepts an argument for a persons name. The method should loop through the number of characters in the nam

MatroZZZ [7]

Answer:

#include <iostream>

#include<string.h>

using namespace std;

void printCharacter(string name){

for(int i=0;name[i]!='\0';i++){

cout<<name[i]<<endl;

}

int main()

{

string name;

cout<<"enter the name: ";

cin>>name;

printCharacter(name);

}

Explanation:

first include the two libraries iostream for input/output and string library for using the string.

then, create the main function and declare the variable type string.

cout instruction is used o display the message on the screen.

cin is used to store the value in the name variable.

after that, call the function. The program control move to the the function. In the function for loop is used to print the character one by one until end of the name.

4 0

3 years ago

Some commands listed in a menu cannot be selected.<br><br><br> True or False

bogdanovich [222]

True! Have a nice week

4 0

3 years ago

Read 2 more answers