Excel 2007 Practice Exam

Yesterday we took a practice exam. Usually whenever we work on anything in Excel, the steps aren't too difficult, however, I saw a few things I wasn't familiar with. I had never used a Text Function in this program before so I really had to wing it. I remember specifically the question asked to use the lowercase function, and miraculously I found it.