answersLogoWhite

0

Multiplication, division, addition and subtraction are four operations that can be used. Their operators are * / + and - which all appear on your numeric keypad.

Functions that can be used include SUM, MIN, MAX and COUNT.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Do function formulas have operators?

They can have operators. It depends on the formula or function in question. There are lots of kinds of operators that can be used like the mathematical ones, operators for comparisons and boolean operators.


How terms formula and function related?

A formula is an instruction in a spreadsheet to carry out some activity, normally a calculation. A formula must begin with the equals sign. Formulas can be simple or complex and they are built by the user. A function is a pre-defined formula that is built into the spreadsheet program and can be used as a formula or as part of a formula. This is a simple formula, multiplying values in two cells by each other: =B3*D10 The SUM function is a commonly used function. It can be used in a formula like these examples: =SUM(A2:A14) =SUM(A2:A14) * 12


What are some examples of logical operators used in programming languages?

Logical operators used in programming languages include AND, OR, and NOT. These operators are used to combine or modify conditions in conditional statements to control the flow of a program.


What is underlying formula in Excel?

An underlying formula in Excel is used in a spreadsheet to do something different than the formula does. An underlying formula can be used to remove values or display numbers.


What are different types of operators used in VHDL give some examples?

+, -, *, /, and, or, xor


How can formulas in the spreadsheet be audited?

There is a formula auditing toolbar and there are options that can be used. By clicking on a formula to edit it, you can see the range finder highlighting the cells being used in the formula.


How formulas in spreadsheet can be audited?

There is a formula auditing toolbar and there are options that can be used. By clicking on a formula to edit it, you can see the range finder highlighting the cells being used in the formula.


Symbols in an Excel formula are called?

There can be different categories of symbols used, but the ones you are referring to would be operators, such as the signs for addition, subtraction, multiplication and division. Other symbols used include brackets and symbols to aid formatting like currency symbols, decimal points and percentage signs.


What is a function or formula in a spreadsheet program?

A formula in IT may be the instructions put into a spreadsheet to process the data stored on the spreadsheet. Or, it may mean the method used to use Information Technology correctly.


List three arithmetic operators that might be used in a formula?

A plus sign, a minus sign and a star, which is used for multiplication.


Do a formula has to have an equal sign in every spreadsheet?

If you mean "spreadsheet program", not necessarily. That's a standard used in Excel; in older spreadsheets, such as Lotus 1-2-3, the formula used to start with a plus sign instead. A minus could be used as well, if it was appropriate for the formula. However, nowadays it seems to have become quite standard for formulae to start with an equal sign.


What is the name of the spreadsheet technique used to copy a formula from one cell to the adjoining cells?

Copy and paste or Fill.