Question

Formulas is Excel in ICT​

Answer 1

$\huge{\underline{\mathtt{\red{❥A}\pink{N}\green{S}\blue{W}\purple{E}\orange{R}}}}$

A very popular spreadsheet application owned by Microsoft. It is capable of handling more than a million rows of data per worksheet and more than 16 thousand columns per worksheet. It has a built-in scripting language called VBA to let you automate some tasks.

Answer 2

Answer:

Name Formula Function

Sum =SUM(range of values)  

Average =AVERAGE(range of values) Mean value

Maximum =MAX(range of values)  

Minimum =MIN(range of values)  

Integer =INT(value) Rounds a number down to the nearest integer that is less than or equal to it.

Round down =ROUNDDOWN(value, places) Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

Round up =ROUNDDUP(value, places) Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

Count =COUNT(range of values) or =COUNTA(range of values Counts the number of cells in selected range

Count If =COUNTIF(range, criterion) Counts the cell if they fulfil the criteria

If =IF(logical expression, value if true, value if false) Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

Nested If =IF(logical expression, value if true, IF(logical expression, value if true))  

Vlookup Create a named  range first

=VLOOKUP(search criterion, range, index, is sorted)

Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.