CinchiT Solutions Interview Questions and Answers

Excel formulas can be categorized into mathematical, logical, text, date/time, and lookup/reference formulas.

• Mathematical formulas perform arithmetic operations like addition, subtraction, multiplication, and division.

• Logical formulas evaluate conditions and return TRUE or FALSE.

• Text formulas manipulate text strings.

• Date/time formulas perform calculations with dates and times.

• Lookup/reference formulas retrieve data fro...read more

Loops are used to execute a set of statements repeatedly until a condition is met.

• For loop: executes a set of statements for a specified number of times

• While loop: executes a set of statements as long as the condition is true

• Do-While loop: executes a set of statements at least once, and then repeatedly executes the set of statements as long as the condition is true

• For Each loop: used to loop through each element in an