On Sunday I posted a quiz to see what you’ve learned so far in Week One. Answers are below:-

**1. Which function can make a good replacement for nested IF functions?**

CHOOSE. Follow the link for an example

**2. Which function would you use to round 18 to the nearest multiple of 25, and how would you go about doing it?**

You would use the CEILING function. To round 18 to the nearest multiple of 25 you would do this:-

**=CEILING(18,25)**

**3. What would the result of the following function be:**

**=AND(5>7, 7>8, 8<9)**

Because 5 isn’t greater than 7, and 7 isn’t greater than 8, these arguments would return FALSE. As the AND function needs all logical tests to return TRUE for it to follow suit, the function would give a return of FALSE.

**4. What ASCII character is represented by the number 75, and how would you show this on a worksheet using an Excel function?**

The character with an ASCII number of 75 is ‘K’. To find the corresponding character for an ASCII figure you use the CHAR function. Here’s how you’d do it:-

**=CHAR(75)
=K**

**5. If cell A5=10, A6=12 and A7=14, how would you use Excel to find the average?**

Using the AVERAGE function, you’d type this:-

**=AVERAGE(A5, A6, A7)**

or..

**=AVERAGE(A5:A7)**

..to give a value of 12!

That’s it for this weeks quiz. If you didn’t get them all right check out the links in this post to the functions mentioned. See you on Sunday for another test!!