Browse › Excel Expert Productivity
Use Functions to Create Advanced Formulas
Part of Excel Expert Productivity Topic: Essential IT
Access
StationX Infrastructure Labs — 3 attempts per lab
🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab
Already have access? Sign in.
New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.
What you'll do
In this lab, you will create formulas that use logical operations, perform data lookups and analysis by using functions.
- Perform logical operations in formulas
- Look up data by using functions
- Perform data analysis by using functions
- ⏱ About 30 minutes
- Counts towards: Microsoft Excel Expert (Microsoft 365 Apps) (exam MO-211)