Manage Tables and Table Data in Microsoft Excel
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 tables and table data in Microsoft Excel.
- Create a table from data within a worksheet
- Add a total row to the table and add a formulas to count the number of rows and calculate the average
- Sort the data by using Data >Sort
- Remove any rows which do not show data in a specific column
- Add a row to a table
- Change the table style
- Ensure columns use special formatting
- Use check boxes on the Table contextual tab to select a style
- Insert a formula that calculates a discount price based on a value
- Ensure the cell calculates the discount correctly
- ⏱ About 30 minutes
- Counts towards: Microsoft Excel (Microsoft 365 Apps) (exam MO-210)