EXCEL- Chapter 4- Working with Data

By ________________ in place, you'll be able to scroll through your content while continuing to view the Header Cells.

4.1

• Holding Rows or Columns

• Freezing Rows or Columns

• Icing Rows or Columns

• Scrolling Rows or Columns

You can quickly reorganize a worksheet by_____?

4.1

• Organizing

• Putting in Order

• Sorting your data

• Clicking Random Buttons

____________can be used to narrow down the data in your worksheet, allowing you to view only the information you need.

4.1

• Sorting

• Formatting

• Filters

• Edits

What command allows you to quickly summarize data?

4.1

• Total Command

• Subtotal Command

• Ten Command

• Summary Command

What allows you to illustrate your workbook data graphically?

4.1

• Charts

• Tables

• Spreadsheets

• Workbooks

Excel includes additional options to make your workbooks easier to view and compare. For example, you can choose to ________ or_______.

• open a new window for your workbook

• split a worksheet into separate panes

• Sort Spreadsheet

• AutoSum

• View tab on the Ribbon

When sorting data, it's important to first decide if you want the sort to apply to the ______________ or just a _________.

4.3

• entire worksheet

• cell range

• right answer

• spreadsheet

• Chart

In which tab on the Ribbon will you find the Sort button?

4.3

• Sort

• Data

• View

• Insert

• File

In which tab on the Ribbon will you find the Filter button?

4.3

• Filter

• Data

• View

• Insert

• File

T/F

Filters are cumulative, which means you can apply multiple filters.

4.3

• True

• False