# Excel Assessment

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.

 Name Surname Email Company name Do you want to receive newsletters / notices from us?

## Question 1

Select the correct symbol for the formula
 Sum / x - \ + # * I don't know Minus / x - \ + # * I don't know Divide / x - \ + # * I don't know Multiply / x - \ + # * I don't know

## Question 2

. Select if the statements are true of false
 You can paste cells without the formulas True False I don't know You cannot add headers or footers in excel when printing, only in Word True False I don't know When totaling more than one cell, you must always use the SUM formula True False I don't know You can calculate formulas across multiple spreadsheets and files True False I don't know

## Question 3

. Select the most appropriate definition from each drop down box, to fit each description
 The cell width and height will not change Wrap text Merge and Center Shrink to fit I don't know The cell height will change Wrap text Merge and Center Shrink to fit I don't know The cell width will change Wrap text Merge and Center Shrink to fit I don't know

## Question 4

 How do you insert a list in excel? Go to options and click lists Right click on the cell and insert a list Click on data validation I don't know

## Question 5

.

In the dataset below, what is the correct formula in C3. You want this formula to be copied and pasted to the cells below.

 =B3*C1 =B\$3*C\$1 =B3*C\$1 =\$B\$3*\$C\$1 I don't know

## Question 6

.

What is the result of the following formula?

 It will give an error TRUE FALSE 1 I don’t know

## Question 7

Which of these phrases correctly describes a date?
 You cannot use formulas on dates It refers to a list It is text It is a number I don’t know

## Question 8

Select if the formula is correct or incorrect
 =A1:A3 Correct Wrong I don't know =sum(a1:a3,b1:b3) Correct Wrong I don't know =\$A1+A\$2 Correct Wrong I don't know =A1\$+A2 Correct Wrong I don't know =(a1+a2) x 2 Correct Wrong I don't know =(a1+a2)/a1 Correct Wrong I don't know

## Question 9

In the following dataset, if you wanted to return the surname for Grant, which formula or combination of formulas would you use?

 VLOOKUP INDEX MATCH MATCH/INDEX MATCH/VLOOKUP I don't know

## Question 10

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.

Table 1

Table 2

 Change to compact form Change to tabular form Change to outline form Change to columns I don’t know

## Question 11

In the below pivottable, in which field is the quarter heading?

 Rows Values Filter Columns I don’t know

## Question 12

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.

Table 1

Table 2

 =SUMIFS('Sumifs1 Database'!\$C:\$C,'Sumifs1 Database'!\$B:\$B,A\$4,'Sumifs1 Database'!\$D:\$D,C\$3) =SUMIFS('Sumifs1 Database'!\$B:\$B,'Sumifs1 Database'!\$C:\$C,\$A4,'Sumifs1 Database'!\$D:\$D,C\$3) =SUMIFS('Sumifs1 Database'!\$C:\$C,'Sumifs1 Database'!\$D:\$D,\$A4,'Sumifs1 Database'!\$D:\$D,C\$3) =SUMIFS('Sumifs1 Database'!\$C:\$C,'Sumifs1 Database'!\$B:\$B,\$A4,'Sumifs1 Database'!\$D:\$D,C\$3) I don’t know

## Question 13

If you type the following formula in A1, what will the formula do?

 Get the data from another sheet This formula is wrong Calculate the total of B1 and A1 Direct the cell to sheet2 I don’t know

### Empower Yourself - BOOK NOW!

U4th Floor, Block 2
Protea Hotel (Conference Centre)
Cnr Gordon Hood and Hendrik Verwoerd Drive
Centurion 0046
South Africa
VAT No: 4410263224

#### Contact Details:

Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do
Nelson Mandela