StationX
Start free

Browse › Excel Productivity

Manipulate Data in Worksheets in Microsoft Excel

Guided

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 manipulate data in worksheets by using Microsoft Excel.

  1. Use the Paste Special > Values button
  2. Use the Quick access toolbar
  3. Use the RANDBETWEEN AND SEQUENCE functions to add data to a specific number of columns and rows
  4. Insert a row above the data and add column headers
  5. Open a new workbook and copy specific data between workbooks by using Paste Special > Values
  6. Add a simple formula
  7. Use Flash Fill to copy the formula to all other rows
  8. Remove the conditional formatting rule
  9. Clear formatting from all cells
  10. Format columns to use the Currency formatting option