Question

when inputting a formula into excel or other spreadsheet software, what components are required for the formula to function properly? select one or more:

Answer 1

When inputting a formula into excel or in other spreadsheet software, we need to put equal sign before writing the formula and opening and closing parentheses for the formula.

Spreadsheet software such as excel, go-ogle sheets, or office 365 sheets allows you to perform calculations based on the given formula to perform the calculation. Most common formulas are provided by the spreadsheet softwares, such as sum, average, min, max, difference etc. These built-in formulas also called functions.

However, we can write our own formula to perform specific calculations according to our requirement. The components that are required for formula to function properly; you need to write equal sign “=” before beginning the formula. The second component of the formula is, you must always close the parentheses for any opening parentheses.

For example, if you want to add or do sum, then the formula is”

=sum(range of cells…)

If you want to take an average of a range of numbers, then you can write

=average(range of cells…)

However, you can write your own formula which can have multiple parentheses, for example:

=(A1+B1+(B1/C2)+(B3+(B4/B5)))

You can learn more about spreadsheet formula at

brainly.com/question/1395170

#SPJ4