StationX
Start free

Browse › Excel Productivity

Can You Use Formulas and Functions in Microsoft Excel?

Advanced

Part of Excel 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 use formulas and functions in Microsoft Excel.

  1. Insert relative, absolute, and mixed references
  2. Reference named ranges and named tables in formulas
  3. Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
  4. Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
  5. Perform conditional operations by using the IF() function
  6. Format text by using RIGHT(), LEFT(), and MID() functions
  7. Format text by using UPPER(), LOWER(), and LEN() functions
  8. Format text by using the CONCAT() and TEXTJOIN() functions