min() and max() find smallest and largest values in iterables. Functions can be called with single iterable or multiple regular arguments. All input values must be comparable types
Replaces one or all matches of a pattern with a new string. Pattern can be string or RegExp object. Original string remains unchanged. Only first occurrence of string pattern is replaced
if statements allow multiple elif parts with optional else. for loops iterate over sequences in order. range() generates arithmetic progressions for number iteration. break and continue statements control loop execution. else clauses execute when loop terminates without break
Excel formulas are expressions that perform operations based on cell values. Formulas always start with an equal sign (=). Excel has over 500 predefined functions for various calculations
Methods are blocks of code performing specific tasks. Java has user-defined and standard library methods. Methods can be declared with return type and parameters
Functions are blocks of code that run only when called. Functions can accept parameters and return values. Functions are defined using the def keyword