Excel Skills Assessment
    Progress          
  1 2 3 4 5 Report
 
  Current Ranking  
  Beg Beg-Int Int Int-Adv Adv  
   
     
   
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            
                 
   
 
Click Next  
    Progress          
  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            
                 
                 
                 
                 
                 
   
 
      Progress          
  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.            
                 
     
      Progress          
  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            
                 
     
      Progress          
  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!  
   
 
Thanks for completing the questionnaire  
 
You have achieved the following total score (out of 10)  
 
Excel Skill Area 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 experience this gives you the Excel Skill Level of a    
   
To get the detailed breakdown (see the example below), fill in your email address    
and click the FINISH button to submit your questionnaire. NOTE that the detailed     
report is manually generated so may take a day or so to receive.    
   
 
Some instant fix recommendations based on your answer sets (you can help yourself right now!)  
URL  
 
 
 
 
 
Example of the full report you will receive if you submit this questionnaire.