EXPLAIN MANY TYPES OF EXCEL FORMULA

Question

Accepted Answer

Excel formulas are used to perform calculations and manipulate data in spreadsheets.

Arithmetic formulas: perform basic mathematical operations like addition, subtraction, multiplication, and division.
Logical formulas: evaluate conditions and return true or false values.
Text formulas: manipulate text data, such as concatenating strings or extracting specific characters.
Lookup formulas: search for specific values in a range and return corresponding values.
Statistical formulas: calculate statistical measures like average, sum, count, etc.
Date and time formulas: perform operations on dates and times, such as adding or subtracting days.
Financial formulas: calculate financial metrics like interest, present value, or future value.
Array formulas: perform calculations on multiple cells or ranges of data simultaneously.
Conditional formulas: apply specific calculations or formatting based on certain conditions.
Nested formulas: combine multiple formulas within one another to perform complex calculations.

Accepted Answer

Excel has many types of formulas, including basic formulas, advanced formulas,and cube function.
Basic formulas 
These formulas perform simple mathematical operation,such as adding, averaging, or counting 
SUM: Add the value in a selected range of cell
AVERAGE: Calculates the average of the value in a selected range of cell 
COUNT:Counts the number of cell in a range that contain number 
COUNTA: COUNTS the number of cell in a range, regardless of type

EXPLAIN MANY TYPES OF EXCEL FORMULA

Popular interview questions of Claim Processing Executive

Top HR questions asked in Desun Hospital & Heart Institute Claim Processing Executive