Dollar sign ($) indicates currency format in Excel. Currency format displays symbol adjacent to number. Accounting format shows symbol at cell edge regardless of length. Accounting format uses dashes for zeros and parentheses for negatives
Drop-down lists help users work more efficiently in worksheets. List items should ideally be in Excel table format. Data can be converted to table using Ctrl+T
VLOOKUP finds values in tables or ranges by row. Function requires lookup value, table range, and return column number. Default behavior is approximate match (TRUE) or exact match (FALSE)
Greater than or equal to operator in Excel is written as ">=". Formula returns TRUE or FALSE based on comparison results. Can compare numbers or reference cells. Works best with numerical data
SQRT function returns square root of positive numbers. Function introduced in MS Excel 2010. Formula: =SQRT(number)
ABS returns the absolute value of a number. Positive numbers remain unchanged. Formula: ABS(number)