Small questions, big projects, and everything in between. Pick a guide and take the first step.
Calculate the first entry’s fraction of the total. Follow a five-row photo folders example with the exact formula and an expected result.
Subtract the first value from the second and retain the sign. Follow a five-row photo folders example with the exact formula and an expected result.
Compare the second entry with the first as the baseline. Follow a five-row photo folders example with the exact formula and an expected result.
Use an expanding range to calculate cumulative values. Follow a five-row photo folders example with the exact formula and an expected result.
Scale a value while retaining the original data. Follow a five-row photo folders example with the exact formula and an expected result.
Divide a value into three equal mathematical shares. Follow a five-row photo folders example with the exact formula and an expected result.
Find how many units remain after forming groups of five. Follow a five-row photo folders example with the exact formula and an expected result.
Multiply the first numeric value by itself. Follow a five-row photo folders example with the exact formula and an expected result.
Calculate the nonnegative square root of a positive input. Follow a five-row photo folders example with the exact formula and an expected result.
Create a readable label based on a numeric threshold. Follow a five-row photo folders example with the exact formula and an expected result.
Check whether the first value is inside an inclusive range. Follow a five-row photo folders example with the exact formula and an expected result.
Identify values outside an inclusive range. Follow a five-row photo folders example with the exact formula and an expected result.
Build a readable summary without replacing source cells. Follow a five-row photo folders example with the exact formula and an expected result.
Create an uppercase display copy of a label. Follow a five-row photo folders example with the exact formula and an expected result.
Create a lowercase copy for consistent text comparison. Follow a five-row photo folders example with the exact formula and an expected result.
Capitalize the start of each word in a display label. Follow a five-row photo folders example with the exact formula and an expected result.
Count characters, including spaces, in a text value. Follow a five-row photo folders example with the exact formula and an expected result.
Extract a short prefix without changing the original. Follow a five-row photo folders example with the exact formula and an expected result.
