Intro to Excel - Amy Martinez | Laabri | Nneɛma a ɛma wotumi yɛ ade

1

In Excel, which action correctly sorts a table by one column (A to Z)?

null

Click inside the column, then choose Data → Sort A to Z

null

Use Home → Find & Select to rearrange rows alphabetically

null

Change the font to A-Z so the rows reorder automatically

null

Insert a chart; Excel sorts the table when the chart is created

1

In Excel, what feature lets you arrange data in alphabetical or numerical order?

Ɛhia

1

Before you sort a list in Excel, what is the best way to make sure the information in each row stays together?

Convert the column to text, then sort

Insert a blank row between every record, then sort

Click any cell in the table/range, then sort that column

Select only the column you want to alphabetize, then sort

Ɛhia

1

If you sort a column inside a data table in Excel, the entire row moves so the records stay intact.

Nokorɛ

Ɛnyɛ ampa

Ɛhia

1

You want to sort a class list by Last Name first, and then by First Name (A to Z). What should you do?

Use Data → Filter, then click A to Z on the Last Name header only

Sort by First Name first, then sort again by Last Name

Use Home → Conditional Formatting to rank names alphabetically

Use Data → Sort, set Last Name as the first level, then Add Level for First Name

Ɛhia

1

In Excel, what feature lets you show only the rows that meet a condition (for example, only students with a grade below 70)?

Ɛhia

1

When you sort a table that has column headings (like “Name” or “Grade”), which option should you choose in the Sort dialog?

Convert the data to a chart before sorting

Ignore headers and sort everything

My data has headers

My data has footers

Ɛhia

1

You have a list of assignment due dates and want to see the earliest due date at the top. Which sort should you use on the Date column?

Sort A to Z on a different column

Filter by date instead of sorting

Sort Newest to Oldest

Sort Oldest to Newest

Ɛhia

1

Blank rows in the middle of your data can cause Excel to sort only part of the list instead of the whole dataset.

Nokorɛ

Ɛnyɛ ampa

Ɛhia

1

Some rows are highlighted in yellow. You want all the yellow rows grouped together without changing the text or numbers. What should you use?

Text to Columns

Remove Duplicates

Sort by Cell Color

Conditional Formatting