Home › Learn Excel › Test
No tips this time. Answer the questions and see your score: 70% or more and you've passed.
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 B2FIND returns the position of a character in a text, counting from the left. Find the position of the @ in the email address, in B2PROPER 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 B2TRIM 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 B2CONCATENATE 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 C2DATEDIF 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 C2NETWORKDAYS 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