Excel Review - Unit 6

Which answer below is how to freeze rows in Microsoft Excel?

• Right-click on the row you want to freeze, go to the 'Layout' tab, click on 'Freeze Panes', and select 'Freeze Top Row' from the dropdown menu.
• Select the row above the rows you want to freeze, go to the 'Insert' tab, click on 'Freeze Panes', and select 'Freeze Panes' from the dropdown menu.
• Select the row below the rows you want to freeze, go to the 'View' tab, click on 'Freeze Panes', and select 'Freeze Panes' from the dropdown menu.
• Highlight the rows you want to freeze, go to the 'Home' tab, click on 'Format', and select 'Freeze Rows' from the dropdown menu.

How do you split a worksheet in Excel?

• Right-click on the worksheet and select 'Split'
• Press Ctrl + S to split the worksheet
• Go to the 'Insert' tab, click on 'Split' in the 'Layout' group
• Go to the 'View' tab, click on 'Split' in the 'Window' group

How do you pronounce Chaffin?

• Chaaaafin

• Chayfin

• Choffin

• Chefin

What is the state bird of Texas?

• Blue Jay
• Cardinal
• Mockingbird

• American Robin

Sort sheet organizes all of the data in your worksheet by one column.

• TRUE

• FALSE

Select the Data tab on the Ribbon, then click the A-Z command to sort A to Z, or the Z-A command to sort Z to A. This is how you do what?

• Sort data in Microsoft Excel
• Format text in Microsoft Word
• Insert a chart in Microsoft PowerPoint
• Create a new slide in Microsoft Excel

If your data isn't sorting properly, double-check your cell ____ to make sure they are entered into the worksheet correctly.

• values
• formulas
• functions
• entries

If your worksheet contains a lot of content, it can be difficult to find information quickly. ____ can be used to narrow down the data in your worksheet, allowing you to view only the information you need.

• Filtering
• Grouping
• Highlighting
• Sorting

In order for filtering to work correctly, your worksheet should include a _____ ____, which is used to identify the name of each column.

• Top row
• Header row
• First row
• Data row

Excel allows you to _____ for data that contains an exact phrase, number, date, and more.

• Search
• Scan
• Browse
• Find