Rating                
Total Score                
           
             
 
                   
     
                   
You must answer all questions (even with a 'Don't know') to move to the next page  
Answer Multiple Choice Questions              
  1 To create a formula you start by typing              
a @              
  b +              
  c -              
  d =              
  e Don't know              
                   
     
  2 To link a cell to another sheet or spreadsheet you              
a Type = and click on the other sheet or spreadsheet cell              
  b Type the name of the sheet and the cell reference              
  c Type the name of the sheet, a ' and the cell reference              
  d Type the name of the sheet, a ! and the cell reference              
  e Don't know              
                   
     
  3 If you copy the cell in B4 to C5, what will the formula look like and what will the answer be              
a '=B$1' and 0              
  b '=B1' and 0              
  c '=A$1' and OK              
  d '=B$1' and OK              
  e Don't know              
                 
                   
                   
                   
                   
                   
                   
                   
     
  4 In order to change the name of a excel file the best option would be to              
a Change the name shown in cell A1 of Sheet 1              
  b In folder change name of the file while the file is closed              
  c Click the Save icon (or use CTRL S)              
  d Use the 'Save As'              
  e Don't know              
                   
   
 
Already know your level and don't want to finish the test? See the available options  
Beginner Course  
Intermediate Course  
Advanced Course  
 
or  
 
Click to email request for more information  
    Progress          
www.AuditExcel.co.za 1 2 3 4 5 Report
 
  Current Ranking  
 
Beg Beg-Int Int Int-Adv Adv  
   
   
   
   
Answer Multiple Choice Questions            
  5 In order to change the way the printer prints (portrait to landscape) you would            
a Go to Print Preview and choose page setup and choose the landscape option          
  b Go to Page Setup and choose the Landscape option            
  c Use the Print Option and then change the Printers Properties            
  d Choose the Print Area option and Set the print Area to be landscape            
  e Don't Know            
                 
                 
                 
  6 If you've copied this cell (A1 with =1/3 in it) and you pasted as values into cell B1 (which has no formatting) what could it look like          
a 0.33            
  b 1/3            
  c =1/3            
  d 0.333333333333            
  e Don't Know            
                 
                 
                 
  7 If you insert a row at Row 1, 2 and 4 in the first picture (pic A), resulting in the second picture (pic B), what will the answer be in cell B7?            
a 39            
  b 18            
  c 25            
  d 33            
  e 31            
                 
    PICTURE A            
               
                 
                 
                 
                 
                 
                 
                 
    PICTURE B            
               
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
  8 How do I make cell A1 look like cell A3            
a Go to the Format Cells option and Wrap Text            
  b Go to the Format Cells option and Shrink to Fit          
  c Go to the Format Cells option and Merge Cells            
  d Hold ALT down and click enter at each new line point            
  e Don't Know            
                 
                 
                 
                 
                 
   
 
Already know your level and don't want to finish the test? See the available options  
Beginner Course  
Intermediate Course  
Advanced Course  
 
or  
 
Click to email request for more information  
      Progress          
www.AuditExcel.co.za 1 2 3 4 5 Report
 
  Current Ranking  
  Beg Beg-Int Int Int-Adv Adv  
   
   
 
 
Answer Multiple Choice Questions            
  9 If a row is hidden e.g. rows 5 and 6 in the picture, and you copy the formula in C4 by dragging it down from C4 to C7 the following will happen          
a The formula will be included in the hidden cells            
  b The hidden cells will be overwritten with the new formula            
  c The formula will be copied into C7 only            
  d The formula in C7 will say = B4+C4            
  e Don't Know            
                 
                 
                 
                 
                 
     
     
  10 If you sort the following list in ascending order what will be the result          
a A1, A2, A10, A11, A20, A100            
  b A1, A10, A100, A11, A2, A20            
  c A100, A10, A1, A11, A20, A2            
  d A20, A2, A11, A100, A10, A1            
  e Don't Know            
                 
                 
                 
     
     
  11 In order to get this data set to go back to showing all the data items you would need to            
a Set the filter in column A, B, and E to show all            
  b Set the filter in column C and D to show all            
  c Use the menu items to Show All or Clear all            
  d Set the filter in column C to show all            
  e Don't know            
                 
               
                 
                 
                 
                 
                 
                 
                 
                 
     
     
12 Which of the following comments makes the most sense to you            
  a Separating the areas where your inputs, calculations and reports are is the most important thing you can do when working with spreadsheets            
  b Ensuring that you are consistent with your formula is critical especially with regards hardcoding of numbers into formula (specifically not doing it)            
  c The structure of your spreadsheet (columns, rows and sheets) is critical in order to enable easy and safe changes to be made on your spreadsheet            
  d Keeping a history of the different versions of your spreadsheet will enable you to easily go back to a version that meets your requirements            
  e Linking spreadsheets is only sensible when no other option exists. In this case you must make sure that all the linked spreadsheets are open when you make changes to any of them.            
                 
     
 
Already know your level and don't want to finish the test? See the available options  
Beginner Course  
Intermediate Course  
Advanced Course  
 
or  
 
Click to email request for more information  
 
or   
 
Click Next below  
      Progress          
www.AuditExcel.co.za 1 2 3 4 5 Report
 
  Current Ranking  
  Beg Beg-Int Int Int-Adv Adv  
   
   
 
 
Answer Multiple Choice Questions            
  13 The result of the formula in cell B6 will be            
a 0.08          
  b 0.04            
  c 8            
  d 4            
  e Don't know            
                 
                 
                 
                 
                 
                 
                 
     
     
  14 The VLOOKUP function in D3 will have the following answer (note that the last '1' could also say True)            
a Anna            
  b Toni            
  c Adrian            
  d Trevor            
  e Don't Know            
                 
               
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
     
     
  15 The answers that will be shown in cell A15 and A16 (respectively) are            
a 6 & 30            
  b 6 & 20            
  c 8 & 30            
  d 8 & 20            
  e Don't know            
               
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
     
     
  16 In order to make the TRANSPOSE function work (NOT the Transpose via  Paste Special) you need to do the following. Highlight the areas where you want the information to appear, create a TRANSPOSE formula and            
a Highlight the cells where it is coming from and click ENTER            
  b Highlight the cells where it is coming from and click SHIFT & ENTER            
  c Highlight the cells where it is coming from and click SHIFT & CTRL & ENTER            
  d The TRANSPOSE function does not exist            
  e Don't Know            
                 
     
 
Already know your level and don't want to finish the test? See the available options  
Beginner Course  
Intermediate Course  
Advanced Course  
 
or  
 
Click to email request for more information  
 
or   
 
Click Next below  
      Progress          
www.AuditExcel.co.za 1 2 3 4 5 Report
 
  Current Ranking  
  Beg Beg-Int Int Int-Adv Adv  
   
   
 
 
Answer Multiple Choice Questions            
  17 If the result of a formula is #N/A, you can improve the formula by using a combination of which functions            
a IF & ISERROR            
  b IF & CELL            
  c IF & ERROR.TYPE            
  d IF & NA            
  e Don't Know            
                 
     
     
  18 To build a spreadsheet that automatically removes duplicates (another way to describe it would be to extract unique items)  from a list the following functions should be considered (either as one formula or over multiple cells)            
a VLOOKUP & RANK            
  b COUNTIF & VLOOKUP & RANK            
  c SORT            
  d SUMIF & RANK            
  e Don't Know            
                 
     
     
  19 Match the functions that you find tend to go together in Excel            
a VLOOKUP a AND        
b IF b CONCATENATE      
c DATE c COUNTIF        
d FIND d MATCH        
e LEFT e MID        
      f SUMIF        
      g YEAR        
                 
                 
                 
     
  20 To determine if a record is unique in a list you can use the following tool or function          
a ADVANCED FILTER tool            
  b DATA AUTOFILTER tool            
  c COUNTIF            
  d DATA SORT tool            
  e Don't know            
                 
     
 
OK, now go to the report sheet!  
Click Next below  
   
     
 
 
  Note: Not Mobile Friendly. Please do on desktop rather  
     
  This is an optional section but it would be very useful if you can complete it.  
  Unlike the previous pages, this is NOT a test.    
  All you need to indicate is how often you do these types of tasks in MS Excel  
  0 means never and 5 means all the time    
  By completing this we can improve the recommendations to you, not only telling  
  you what level you are, but also what you should be learning about in MS Excel  
     
Remove unwanted cells/ rows/ columns    
  You spend time cleaning up a spreadsheet by removing cells, rows or columns  
  You find yourself deleting the same information again and again  
       
  So in the spreadsheet below we need to remove all the headers and footers and only leave the red block
       
 
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
1 So how often do you remove unwanted cells, rows or columns?    
 
 
     
 
Work with Dates    
  You do any work involving dates or time in excel.    
  You have to convert dates from mm/dd/yyyy to dd/mm/yyyy or vica versa  
  You need to work out the number of working days between 2 dates  
  You need to work out the day of the week    
       
  In the spreadsheets below we have various conversion from 'strange' dates in Excel to Excel acceptable dates
       
 
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you work with dates in Excel    
2
 
     
 
Summarise/ Report Data    
  Take lots of data and turn it quickly into summarised reports    
  Take transaction data and make monthly report    
  Report by division, geo location, product etc    
       
  In the spreadsheets below, we need to take thousands of rows data and create reports that summarise or extract useful information
       
 
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to summarise lots of data or extract information out of large data sets?
3
 
     
 
Simple Graphing    
  Create simple charts and graphs to get your point across    
  Show a line chart of monthly transactions    
  Split expenses into categories    
       
  Below examples of some simple graphs that are created in Excel  
       
 
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to create simple graphs to visualise your data  
4
 
     
 
Dashboards    
  Create dashboards involving tables of data, charts and things like heat maps to get your message across  
  Allow for easy changes to the information being reported on in the dashboard  
  Allow the source data to be changed so that we can report weekly/ monthly/ quarterly etc  
       
  In the spreadsheet below, we create a dashboard based on a changeable data set with tables, graphs and heat maps. 
       
 
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to create working dashboards that provide management reports
5
 
     
 
Budgets and Forecasts    
  You need to create forward looking reports estimating what may happen in the near future based on a set of assumptions  
  Create budgets per division to be consolidated    
  Create longer term forecasts to assess future years    
  Compare actuals to budget and reforecast till the end of the year  
       
  Below a summary of a proposed budget with the actuals for comparative purposes  
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to create budgets or forecasts    
6
 
     
 
Decision Models    
  Create spreadsheets that help make a decision e.g.    
  - should we lease or buy    
  - what price should we charge    
  - which supplier should we use    
  - should we proceed with the project    
  - how much should we pay for the business    
  - how much debt do we need/ can we handle    
       
  Below we have created a decision model to decide whether a property can handle the required debt.
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to build spreadsheets to help you make a decision  
7
 
     
 
Fill in Gaps    
  You receive reports that have gaps in them but in order to be useable, you need to have the gaps fill in data.  
  You find yourself copy and pasting data again and again to make the spreadsheet useful to use in other reports
       
  So in the spreadsheet below, we need to fill in the spaces so that it shows the information from the cell above
       
 
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to fill in gaps in data?    
8
 
     
 
Remove Duplicates    
  You remove/ change data based on a criteria e.g. it is a duplicate, it contains unnecessary data  
  You want to extract the first/ last time you see the data    
       
  In the spreadsheet below we need to identify and remove the red block as it is a duplicate of the first line
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to remove duplicates    
9
 
     
 
Split/ join cells/ rows/ Columns    
  You need to split/ join cells in different columns/ rows    
  You want to extract say the first 3 characters, or    
  all the characters up to a special character like a comma or hash    
  Split full names into first name/ surname    
  Join cells together to make a sentence, unique reference, full names etc  
       
  In the spreadsheets below we need to split these columns into separate columns based on a set position or set character
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
 
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to split cells into many columns    
10
 
     
 
Transpose Data- Move data around into the order you want  
  Change the structure of a report so that the rows appear in columns, and columns appear in rows  
  Manipulate a report so that the data repeats itself    
  Change the look of a report to match the look of another report    
       
  In the spreadsheet below a simple transpose to move a row into a column  
     
       
       
       
       
       
       
       
  In the spreadsheets below we need to pivot a report so that the rows are in columns and the columns in rows
 
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you have to move data around to get it into a specific row/ column format
11
 
     
 
Merge Data sources together    
  Join data together e.g. add client details to a sales report    
  Merge spreadsheets/ databases to create a big database    
  Consolidate databases to be able to run business intelligence queries  
       
  In the spreadsheet below, we need to get the outstanding expenses from one list and put it into a separate list based on the matching employee number.
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to merge databases/ spreadsheets    
12
 
     
 
Reconcile Lists    
  Compare lists/ databases in order to    
  - reconcile    
  - identify missing items    
  - analyse anomalies    
  - compare supplier information to our information    
       
  In the spreadsheet below, we need to compare 2 lists and identify the items that are missing, exist once or appear too many times based on the transaction ID
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to reconcile lists    
13
 
     
 
Debt Calculations    
  You do any calculations involving interest rates    
  Use functions like present value, future value, interest rate, number of periods, beginning or end period calculations.
  Need to determine what the repayments will be on a loan based on a set IRR  
       
  Below detailed debt calculations with repayments terms and interest capital splits  
       
       
 
 
   
   
   
   
   
     
       
       
       
       
       
       
       
       
       
       
  So how often do you need to create debt calculations    
14
 
     
 
NPV/ IRR/ Payback type calculations    
  You need to determine the returns on cash flows using NPV, IRR, payback periods etc  
  You need to compare 2 businesses/ projects and choose 1 based on a metric  
  Compare pricing options to see which one is more beneficial to you  
       
  Below a financial model with a section indicating the NPV and IRR of the proposed project.
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to create NPV, IRR or payback based spreadsheets  
15
 
     
 
Built Templates/ collect data from many users etc  
  You create templates that will be used by other people to capture/ calculate information  
  You need to aggregate all the information from many spreadsheets  
  You need to use dropdown boxes so that users can choose out of a pre defined list  
  The templates will be used to consolidate the information into a single report  
       
  Below a template to be distributed to users where they have free entry and drop down lists to capture date
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to build spreadsheets to be used by other people.   
16
 
     
   
Review others works    
  You receive spreadsheets from other people and need to check there accuracy, integrity etc  
  You often have to point out errors you find in a spreadsheet    
  You need to get your spreadsheets audited to get debt from a bank  
  You create a bankable feasibility spreadsheet    
       
  Below the results of a review of the formulas in a spreadsheet to identify an error.  
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to review spreadsheets built by others?  
17
 
     
 
Track Data- GANTT charts, Project plans, tracking information  
  You track events in a spreadsheet based on a time line e.g. project timelines, tracking documents flow  
  You itemise data e.g. fixed assets registers, sales lead lists, production scheduling etc  
  You use Microsoft Project but need to combine it with Excel    
       
  Below a spreadsheet that tracks a project over time.    
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  Below a spreadsheet that tracks the  flow of documents between departments to work out turnaround times
       
       
       
     
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to build spreadsheets to track items, events or timelines  
18
 
     
 
Running What Ifs    
  You need to run any sensitivities, what ifs or scenarios    
  You are asked to re run a calculation based on different inputs    
  You need to provide a report based on the impact of a recent event  
  You are not sure which scenario is the most likely    
       
  Below the possible repayments at different levels of interest rates and repayment periods
       
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to answer What If type questions    
19
 
     
 
Identify Trends / Opportunities    
  You need to work with data to spot problems/ trends    
  You are doing forensic work    
  You are involved with Business Intelligence    
  Data mining is one of your tasks    
  You are trying to identify clients that have stopped buying, buying more etc  
       
  Below a chart that helps identify a day when unusual amounts of transaction were processed that needs to be investigated
       
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
  So how often do you need to analyse data to find trends/ risks/ opportunities (data mining)
20
 
     
 
 
     
 
Thanks for completing the questionnaire  
 
You have achieved the following total score (out of 10)  
 
Excel Skill Area (breakdown available via email- see below) Score  
FUNDAMENTALS: Basics of Excel i.e. entering formula, $ signs etc. ??  
USING TOOLS: Using tools like Data Sort, Filter and Pivot Tables ??  
USING FUNCTIONS: Using formula available like IF, VLOOKUP, SUMIF etc. ??  
SUPER USER ATTRIBUTES: Combining all of the above to derive solutions. ??  
   
 
     
Based on our rating  this gives you the Excel Skill Level of a      
     
To get the detailed breakdown and recommendations, fill in your details in the yellow below    
and click the FINISH button (above or below) to score your questionnaire. You will receive an    
email with the scores and a link to your report.      
Name      
     
Email Address      
     
Company Code (if you have been provided with one- fill it in here otherwise ignore)      
     
Location (In South Africa, close to South Africa or further away)  
   
You agree to receive this report via email and 1 more email with customised tips and tricks, after which you can unsubscribe
Now Click Finish Above  
You will receive an email within 5 minutes (please check in your junk mail as well).   
     
 
Please note the T&C's