Recall & Review
beginner
What is a Table in Excel?
A Table in Excel is a range of cells that are organized with headers and rows, which Excel treats as a single object. It helps manage and analyze data easily.
Click to reveal answer
beginner
How do you insert a Table in Excel?
Select your data range, then go to the Insert tab and click on 'Table'. Confirm the range and if your table has headers, check the box. Click OK to create the Table.
Click to reveal answer
beginner
Name two benefits of using Tables in Excel.
1. Tables automatically apply filters and sorting to your data.<br>2. Formulas inside Tables automatically adjust when you add or remove rows.
Click to reveal answer
intermediate
What happens to formulas when you add new rows to an Excel Table?
Formulas in Tables automatically copy down to new rows, so you don’t have to drag or copy them manually.
Click to reveal answer
beginner
How do Tables help with data formatting?
Tables come with built-in styles that format rows and columns for better readability. They also alternate row colors automatically.
Click to reveal answer
What is the first step to create a Table in Excel?
✗ Incorrect
You must first select the data range you want to convert into a Table.
Which tab contains the 'Table' option in Excel?
✗ Incorrect
The 'Table' option is found under the Insert tab.
What feature do Tables automatically add to your data?
✗ Incorrect
Tables automatically add filters to each column header.
When you add a new row to a Table, what happens to the formulas?
✗ Incorrect
Formulas in Tables automatically fill down to new rows.
What visual benefit do Tables provide?
✗ Incorrect
Tables apply alternating row colors for easier reading.
Explain how to insert a Table in Excel and why it is useful.
Think about the steps and what benefits you get after creating a Table.
You got /6 concepts.
List three benefits of using Tables in Excel.
Consider how Tables help with data handling and appearance.
You got /5 concepts.