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
Formats a number as text.
How TEXT worksTEXTFormat a price with two decimalsUse TEXT to display a numeric price with exactly two decimal places.BeginnerNot startedTEXTAdd a dollar sign to salesUse TEXT to show a sales amount with a dollar sign and thousands separator.BeginnerNot startedTEXTShow a percentageUse TEXT to convert a decimal fraction into a percentage string.BeginnerNot startedTEXTFormat a date as textUse TEXT to display a date stored as text in a friendly month-day-year format.BeginnerNot startedTEXTPad a number with leading zerosUse TEXT to display a number with a fixed width using leading zeros.BeginnerNot startedTEXTFormat Sales with Thousands SeparatorUse TEXT to display a sales figure with a comma thousands separator.IntermediateNot startedTEXTCurrency with Two DecimalsCombine TEXT with a currency format to show a price with a dollar sign.IntermediateNot startedTEXTDate in Long Month FormatUse TEXT to convert a date value into a friendly month-day-year string.IntermediateNot startedTEXTPercentage with One DecimalFormat a decimal ratio as a percentage using TEXT.IntermediateNot startedTEXTCombine TEXT with CONCATENATE for a LabelJoin a name and a formatted score into one text label.IntermediateNot startedTEXTInvoice Due Date LabelA finance team wants each invoice's due date shown as a friendly text label combining the invoice ID and the due date.AdvancedNot startedTEXTSales Amount with Thousands SeparatorA sales manager wants each region's total displayed as a currency-style text with a dollar sign and thousands separator.AdvancedNot startedTEXTPercentage Growth BadgeAn analyst needs a growth badge showing the product and its growth rate as a percentage with one decimal place.AdvancedNot startedTEXTOrder Date with Weekday NameA logistics coordinator wants each order shown with its date and the full weekday name for scheduling.AdvancedNot startedTEXTRounded Units with Custom LabelA warehouse lead wants each item's quantity shown rounded to the nearest ten with a 'units' suffix.AdvancedNot started