This assessment is not a test but rather a skills assessment. If you do not know an answer then choose "I don't know". It is for your own benefit to start at the correct level to ensure you get all the skills from bottom up. This assessment is split into basic, intermediate and advanced questions. You will get a report on what you scored per level.
In the dataset below, what is the correct formula in C3. You want this formula to be copied and pasted to the cells below.
What is the result of the following formula?
In the following dataset, if you wanted to return the surname for Grant, which formula or combination of formulas would you use?
In the following pivottable, the names are below the categories in Table 1. How do you display them in column B, next to the categories, as shown in Table 2.
In the below pivottable, in which field is the quarter heading?
You have a database in Table 1. What is the correct formula in cell C4 in Table 2, to total the numbers for the Warehouse for Week 1. This formula should then be also copied and pasted to all blue cells. The database sheet is called Sumifs1 Database.
If you type the following formula in A1, what will the formula do?
Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do