NEW
Font size
WorksheetsMicrosoft Excel: Tables and Data Formatting
Total questions: 20
Worksheet time: 15mins
Which tab do you click to insert a table in Excel?
Home
Insert
View
What is the main purpose of creating a table in Excel?
To play games
To organize data neatly
To change font only
If your text doesn’t fit in a cell and shows ####, what can you do?
Merge cells
Increase column width
Delete text
Which button is used to apply quick designs (colors/fonts) to cells?
Cell Styles
Format Painter
Alignment
What does the Wrap Text button do?
Makes text bold inside the same cell
Breaks long text into multiple lines inside the same cell
Deletes text inside the same cell
To combine multiple cells into one, you use…
Merge & Center
Insert → Table
AutoSum
Which alignment is commonly used for numbers?
Left
Right
Center
Which alignment makes titles look professional?
Center
Right
Bottom
What tool can make your header row stand out?
Bold text and fill color
Spell check
Merge cells only
Which border style is best to show table outlines?
Thick outside border
No border
Strikethrough
If your text is too long, which is better: Wrap Text or Merge Cells?
Wrap Text
Merge Cells
Delete text
What is the benefit of structured tables compared to plain ranges?
They look bigger
They include filters and quick formatting
They use more memory
You created a table but want the title across 6 columns. What should you do?
Wrap Text
Merge & Center
Insert Picture
If you apply Wrap Text but text is still hidden, what should you check?
Row height
Font type
Sheet name
Why is using too many colors in a table not recommended?
It slows Excel
It makes the table confusing and hard to read
It deletes data
Which of these is the BEST example of good formatting?
Centered title, bold headers, consistent alignment
Random fonts, no borders, too many colors
All data in one merged cell
Which tool lets you quickly format alternating row colors in a table?
Table Styles
Merge Cells
Header/Footer
If a column of numbers is not aligned properly, what problem might occur?
Formulas stop working
Numbers are hard to compare
Rows disappear
You want to show long category names like “Daily Transportation Costs” in one cell without making the column too wide. Which tool is best?
Merge Cells
Wrap Text
Hide Column
Why is it better to format tables consistently before presenting?
Saves ink when printing
Changes the meaning of data
Makes the table professional and easy to understand
