TestOut Office Pro – Excel Videos 5.9.3 & 5.9.4 (15)

What problem is mentioned with the current table in the document?

• Missing headers

• Duplicate records

• Incorrect formulas

• Misaligned columns

Where do you find the option to remove duplicates in Excel?

• Home tab

• Insert tab

• Design contextual tab

• View tab

What happens to the total row if it is not configured correctly?

• It disappears

• It gets sorted with the rest of the data

• It changes color

• It becomes a header

What can you configure in the Table Style Options group?

• Font size

• Banded rows and columns

• Cell borders

• Text alignment

What is the first step to fix the issue with the total row?

• Add a new row

• Delete the existing total row

• Change the row color

• Move the row to the top

What is the benefit of using tables in Excel?

• They are visually appealing

• They help organize data efficiently

• They are easy to print

• They require less memory

What is one of the main benefits of using tables in Excel?

• They make the spreadsheet colorful.

• They allow for easy display, filter, and sort of information.

• They automatically create charts.

• They increase the font size.

What is a structured reference in Excel tables?

• A reference to a specific cell like B4.

• A reference to the table column header.

• A reference to the entire worksheet.

• A reference to the first row only.

How can you name a table in Excel?

• By clicking on the table and typing a name in the Table Name field.

• By selecting the first cell and typing a name.

• By saving the file with a new name.

• By changing the font style.

What should you do to ensure clear results with table formulas?

• Use random labels.

• Use meaningful labels for the header row.

• Use only numbers in the header row.

• Use the same label for all columns.