Excel 2016: Review

What feature in Excel allows you to see certain rows or columns at all times?

• Sorting data

• Freezing rows and columns

• Conditional Formatting

• Filtering data

How can you quickly reorganize a worksheet in Excel?

• Using Charts

• Sorting data

• Visualizing data

• Applying Conditional Formatting

What can be used to narrow down the data in your worksheet to view only what you need?

• Formatting data as a table

• Summarizing data

• Freezing Panes

• Filtering data

Which feature allows you to quickly summarize your data in Excel?

• Creating Charts

• Adding conditional formatting

• The Subtotal feature

• Using Find and Replace

How can tables help you in Excel?

• By visualizing data with charts

• They have built-in sorting and filtering options

• By freezing rows and columns

• By summarizing data

What is the purpose of visualizing data with charts in Excel?

• To freeze specific rows

• To sort data alphabetically

• To make it easy to visualize comparisons and trends

• To filter specific information

What does conditional formatting allow you to do?

• Quickly reorganize a worksheet

• Automatically apply cell formatting based on cell value

• Create tables quickly

• Summarize data easily

What can you use to easily search your workbook for specific information?

• Sorting data

• Visualizing data with charts

• Filtering data

• Using Find and Replace

What is the benefit of formatting data as a table?

• It searches your workbook for specific information

• It summarizes your data automatically

• It makes your data easier to use and organize

• It allows you to freeze rows and columns

How can charts help in interpreting Excel workbooks?

• By sorting data alphabetically or numerically

• By illustrating workbook data graphically

• By summarizing data with the Subtotal feature

• By freezing important rows and columns