Start free

Browse › Excel Productivity

Can You Manage Cells 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 manage cells in Microsoft Excel.

  1. Paste data by using special paste options
  2. Fill cells by using Auto Fill
  3. Insert and delete multiple columns or rows
  4. Insert and delete cells
  5. Merge and unmerge cells
  6. Modify cell alignment, orientation, and indentation
  7. Format cells by using Format Painter
  8. Wrap text within cells, apply number formats, apply cell formats from the Format Cells dialog box, apply cell styles, and clear cell formatting
  9. Define a named range and name a table
  10. Insert Sparklines, apply built-in conditional formatting, and remove conditional formatting