StationX
Start free

Browse › Excel Productivity

Work With Data 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 import data and format workbook properties in Microsoft Excel.

  1. Import data from a CSV file into Excel
  2. Add a hyperlink to a web page
  3. Select a worksheet and perform adjustments to ensure that all data is visible
  4. Add a title, current date as footer, and "Page x of y pages" as footer
  5. Freeze the top x rows so that the header information for the dataset is always in view
  6. Use page break preview
  7. Set the print area, margins, and page breaks to ensure that the entire workbook prints on x number of pages
  8. Add file properties
  9. Save the file as an .xlsx file and export a copy of the file as a PDF file