How can users customize spreadsheets to only display specific criteria?

Which of the following will place data in a specific order?

Instead of resizing your column to accommodate your content, what can you use to fit your content to the size of the cell?

When entering numbers into a cell, your spreadsheet program automatically aligns your numbers to:

When entering text into a cell, your spreadsheet program automatically aligns your text to:

Combining multiple cells in your spreadsheet is called:

What formatting tool adds a dollar symbol, a comma separator and two default decimal places to a number?

Which of the following is the correct reference for a cell range?

Study the highlighted cells in the image below and identify which of the following represents the correct cell address for these cells:  

Data stored in a series of rows and columns is called a:

Alexandra has been asked to select cells C5:K5 during her spreadsheet lesson. What has Alexander's teacher asked her to select?

Oliver's teacher has shared multiple worksheets in the same spreadsheet file titled "Spreadsheets_Labs". The teacher asks Oliver to go to the "Budget" worksheet. When he opens the "Spreadsheets_Labs" file he initially sees the "Science Data" worksheet. How can Oliver go to the "Budget" worksheet?

Study the example worksheet in the image. Victor has selected the cell range A3:D7 in this worksheet. Which option would allow Victor to sort the data in descending alphabetical order according to state?

Kara has selected the cell range A1:D8 in the worksheet shown. Which option would allow Kara to sort the data in alphabetical order according to the employees' first names?

Hilda has created a spreadsheet of the inventory of her family's kitchen. She wants to make a grocery list based on items that are at zero. Which tool allows Hilda to display specific criteria (such as items that are at zero) within a cell range of her inventory?

Patricia's partner Alex has shared a spreadsheet he created. On the first row he has given the spreadsheet a title. The title appears in the cell located in the first column even though the spreadsheet is five columns wide. What can Patricia do so that the title appears centered in the first row above the five columns?

Tyrell has a spreadsheet consisting of four columns (A, B, C, and D) and 30 rows. He wants to make Row 1 a header row that contains Columns A through D so that he can add a title to describe all the data. How can Tyrell accomplish this?