Ataare Advisors Microsoft Excel Quiz
This quiz assesses your familiarity with Microsoft Excel features. This will inform which Ataare Excel training is best for you i.e. BASIC or INTERMEDIATE. 

If you score less than 12 points, you should start with the BASIC TRAINING.
Iniciar sesión en Google para guardar lo que llevas hecho. Más información
Correo *
Select all the Excel features, functions and formulae that you are familiar with
42 puntos
Familiar? Tick if yes
Keyboard shortcuts: Ctrl+C/V/X/Y; Paste special etc.
Formula auditing: precedents; dependents; show formulas; evaluate formula etc.
Data tools: Absolute references; Data validation; Flash fill; Text to columns etc.
Data types: General; Text; Date; Number; Custom etc.
Arithmetic formula: SUM; PRODUCT; SUMPRODUCT; SUMIF(S); ROUND etc.
Text formula: LEFT; RIGHT; CONCATENATE; LEN; FIND etc.
Formatting: Cell types; Header types; Data as a Table; Conditional Formatting etc.
Logic formula: IF; AND; OR; IFS; IFERROR etc.
Lookups: HLOOKUP; VLOOKUP
References: INDEX; MATCH; INDIRECT; OFFSET etc.
Slicers and pivot tables
Statistics: AVERAGE/IF/IFS; COUNT/A/IF/IFS; VARIANCE; FORECAST etc.
What-if analysis (incl. Goal Seek)
Basic charts e.g. bar graphs; pie charts; scatter plot etc.
Financial: IRR; FV; PV; NPV; CAGR etc.
VBA code and Macros
Get data: from TEXT; CSV; Web etc.
Advanced charts: combo charts; waterfalls; hierarchy charts etc.
We have two levels of Microsoft Excel training - BASIC and INTERMEDIATE

If you score less than 12 points, you should start with the BASIC TRAINING

Access our BASIC training here and INTERMEDIATE training here

Se enviará una copia de tus respuestas por correo electrónico a la dirección que has proporcionado.
Enviar
Borrar formulario
reCAPTCHA
PrivacidadTérminos
Este formulario se creó en Nelly Thoithi. Denunciar abuso
Google Formularios