answersLogoWhite

0

What is function in spreadsheets?

User Avatar

Anonymous

10y ago
Updated: 9/15/2022

Function can be used for calculations in a spreadsheet. A simple example of a function is for adding a column of numbers.

EXAMPLE: You have a column of 23 numbers in column B, from row 1 to row 23. To add all of those numbers, and display the results in cell B24, enter =SUM(B1:B23) in cell B24.

See related links for more Excel functions.

What else can I help you with?

Related Questions

What do you mean by calling a function?

It is asking a function to run, by typing the command that runs the function within a program or applications like databases or spreadsheets.


Do software spreadsheets enable one to perform what-if calculations?

Yes they do. Spreadsheets are very good at doing What-If calculations. There are lots of functions available, like the IF function, to help. Other facilities can also be used, so spreadsheets are ideal for it. They are used extensively for doing what-if calculations.


What their values function takes all of the values in each of the specified cells and totals?

If you mean Excel, or similar spreadsheets, you can use the sum() function.


What function takes all of the values in each of the specified cells and totals their values?

If you mean Excel, or similar spreadsheets, you can use the sum() function.


What does the SQL Max function do?

The "SQL Max function" is a computer programming term, which can be used in spreadsheets to give the highest value from the currently selected column.


What is the primary function of Excell?

Excel is an application numerical analysis and manipulation. With it you can create spreadsheets. There are many things you can do with it. See the related questions below.


What can you not create using a word processing application?

A spreadsheet. Spreadsheets usually rely on formulae to calculate numbers. That function is not part of a word-processor.


What is the main feature of spreadsheets that a teacher could use for adding together a list of students examination marks?

The main function to use would be the SUM function. They could type it in directly or start it with the function wizard or best of all the Autosum.


What is the difference between manual and electronic spreadsheets?

Manual spreadsheets are made with a pencil on paper. Electronic spreadsheets are made with a program on a computer.


Advantages and disadvantages of spreadsheets?

There are many advantages and disadvantages of using spreadsheets such as the fact that they are highly organized. One disadvantage of spreadsheets is that they can be complicated to understand.


What is tab in spreadsheets excel?

The tabs at the bottom of the screen identify individual spreadsheets.


Are spreadsheets or databases more powerful?

Databases are somewhat similar to spreadsheets, but databases are more powerful than spreadsheets because of their ability to manipulate the data.