Exercise catalogue
Choose a category
Pick a topic, then a function. Each exercise opens a real spreadsheet: type the formula, check your answer, and get a hint if you’re stuck.
386 exercises0 completed
First characters.
How LEFT worksLEFTFirst Letter of Product CodesUse LEFT to pull the first character from each product code.BeginnerNot startedLEFTTwo-Letter Region PrefixExtract the two-letter region prefix from each order number.BeginnerNot startedLEFTDefault One CharacterUse LEFT without num_chars to return just the first character.BeginnerNot startedLEFTFirst Three Letters of a NameUse LEFT to shorten a first name to its first three letters.BeginnerNot startedLEFTFirst Four Digits of an IDExtract the first four characters from an employee ID.BeginnerNot startedLEFTExtract Product Code PrefixUse LEFT with a fixed character count to pull a short code from each product ID.IntermediateNot startedLEFTLeft Part of a Concatenated LabelCombine LEFT with the ampersand operator to build a short label from a name.IntermediateNot startedLEFTFirst Two Digits of an Order NumberUse LEFT with a number stored as text to extract a two-digit region code.IntermediateNot startedLEFTLeft Characters with LEN-Based CountUse LEFT with a count derived from LEN to drop the last character of a code.IntermediateNot startedLEFTExtract Initials with LEFT and UPPERCombine LEFT with UPPER to return an uppercase first letter of a city.IntermediateNot startedLEFTExtract Department Code from Employee IDA staffing report stores each employee ID with a two-letter department prefix, and HR needs the department code isolated for a lookup.AdvancedNot startedLEFTFirst Letter of Product for SortingA warehouse team wants a quick sort key made from the first letter of each product name to group items alphabetically.AdvancedNot startedLEFTCombine LEFT with LEN to Strip SuffixInvoice numbers end with a fixed three-character branch suffix, and accounting needs the base invoice number without that suffix.AdvancedNot startedLEFTExtract Area Code from Phone NumberA CRM export stores phone numbers as digits only, and the sales team needs the three-digit area code for territory routing.AdvancedNot startedLEFTYear Prefix from Date TextDates are stored as YYYY-MM-DD text, and a report needs just the four-digit year pulled from the start of each date.AdvancedNot started