Questions about Microsoft Excel / Google Sheets

A visually engaging, modern graphic showcasing Excel spreadsheets and supply chain elements like inventory and logistics, with vibrant colors and a professional look.

Excel Essentials for Supply Chain

Welcome to the Excel Essentials for Supply Chain quiz! This quiz is designed to assess your knowledge and comfort level with Excel and Google Sheets as they relate to supply chain management.

  • Gauge your proficiency with logical functions
  • Explore your experience with inventory analysis
  • Understand your familiarity with demand planning
11 Questions3 MinutesCreated by AnalyzingData23
All questions are to help provide an understanding of a base-line introduction to Excel for Supply Chain and managing the expectations and focuses of this youtube series.
All questions are to help provide an understanding of a base-line introduction to Excel for Supply Chain and managing the expectations and focuses of this youtube series.
How comfortable are you with logical functions [IF, AND, OR]?
Never used them before
Could figure it out if I looked it up
Have successfully used them previously
Very Familiar
How comfortable are you with nested functions / logical orders when using functions?
Never used them before
Could figure it out if I looked it up
Have done it previously but it is a lot of work
Second nature (i.e experience with coding or pseudo-coding)
Which of the following would you consider the most "complex" within Excel?
IF/ELSE functions
Lookups (Vlookup, Hlookup, etc)
Pivot Tables
Linking Excel Files or Google Sheets Together
Nested functions
Macros
Do you know what goes into Forecasting?
No
Somewhat
Yes
Do you understand 80/20 or ABC Principles?
No
Somewhat
Yes
How much experience do you have with Excel?
Basically none
Can navigate it
Use it at work to do reports or update information
Create my own sheets to help with work
Have you done any Inventory Analysis before?
No
Yes
Have you done any financial analysis before?
No
Yes
Have you done any demand planning before?
No
Yes
What are of Supply Chain are you in?
Inventory management
Demand planning
Purchasing/Buying
Procurement (Sourcing/Negotiating rather than buying)
Logistics / Scheduling
{"name":"Questions about Microsoft Excel \/ Google Sheets", "url":"https://www.supersurvey.com/QPREVIEW","txt":"Welcome to the Excel Essentials for Supply Chain quiz! This quiz is designed to assess your knowledge and comfort level with Excel and Google Sheets as they relate to supply chain management.Gauge your proficiency with logical functionsExplore your experience with inventory analysisUnderstand your familiarity with demand planning","img":"https:/images/course5.png"}
Make your own Survey
- it's free to start.