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.
Sign in to Google to save your progress. Learn more
Email *
Select all the Excel features, functions and formulae that you are familiar with
42 points
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

A copy of your responses will be emailed to the address you provided.
Submit
Clear form
reCAPTCHA
PrivacyTerms
This form was created inside of Nelly Thoithi. Report Abuse
Google Forms