StationX
Start free

Browse › Excel Expert Productivity

Can You Perform Data Analysis by Using Advanced Functions and Features?

Advanced

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 perform data analysis by using advanced functions and features.

  1. Perform a what-if analysis to determine the effect of an increase in prices on overall sales figures
  2. Use the Goal Seek and Scenario Manager features to perform the what-if analysis
  3. Use the PMT function to calculate monthly payments for a loan