Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Test

Excel text and date functions test

No tips this time. Answer the questions and see your score: 70% or more and you've passed.

  1. Country code. LEFT takes a number of characters from the start of a text. The order codes begin with a two-letter country code. Take the country code (the first two characters) from the order code, in B2
  2. Position of the @. FIND returns the position of a character in a text, counting from the left. Find the position of the @ in the email address, in B2
  3. Capitals. PROPER starts every word with a capital letter and makes the rest lower case. Give the name a capital at the start of each word, in B2
  4. Extra spaces. TRIM removes spaces at the start and end of a text, and turns double spaces in the middle into one. Clean up the extra spaces in the name, in B2
  5. Full name. CONCATENATE joins text from several cells. Add a space between quotes to keep the words apart. Join the first and last name into one full name in C2
  6. Years of service. DATEDIF counts the time between two dates. The last part sets the unit: "y" for years, "m" for months, "d" for days. Work out how many full years Anna has worked here, in C2
  7. Working days. NETWORKDAYS counts the weekdays between two dates, the first and last day included. Weekends don't count. Count the working days between the two dates, in C2
  8. Text length.

← All lessons