Question

Give the syntax and example of any three mathematical functions in spreadsheet?

ᵖˡᶻ ᵃⁿˢʷᵉʳ ⁱᵗ ᶠᵃˢᵗ ❤️
ᵃⁿᵈ ᵖˡᶻ ᶠᵒˡˡᵒʷ ᵐᵉ​

Answer 1

Answer:

The syntax and example of any three mathematical functions in spreadsheet are as follows: SUM(): This is a function which is used to add all the values within a range of cells. ... COUNT(): It is used to count the number of data. ... AVERAGE(): This function is used to find the average of a given number of cells

Answer 2

Answer:

These are the 9 most useful mathematic functions of Excel:

SUM - Adds its arguments

SUMPRODUCT - The most p

owerful and useful function in Excel

ROUND - Rounds a number to a specified number of digits

ROUNDUP - Rounds a number up, away from zero

SUBTOTAL - Returns a subtotal of a filtered list or database)

TRUNC - Truncates a number to an integer

INT - Rounds a number down to the nearest integer)

ABS - Returns the absolute value of a number

MOD - Returns the remainder from division

POWER - Returns the result of a number raised to a power

SQRT - Returns a positive square roo