Managing Worksheets
Cells!
Sorting and Filtering
Page Layout
Printing
100
This contains column headings or field names in a data source such as a table or spreadsheet.
What is a header row?
100
Organizing worksheet data is important. These can make your data more visually appealing and easier to navigate.
What are cell styles?
100
This is the maximum amount of columns on which data can be sorted.
What is three?
100
This allows you to see a worksheet exactly as it will print.
What is Page Break Preview?
100
Using the default print settings, these elements won't print.
What are gridlines, row numbers, and column letters.
200
You can use this feature to be able to see heading rows and the data clearly. Don't use it too much or you won't be able to read the data at all.
What is zoom?
200
Sometimes you need one cell to span multiple columns or rows. This allows you to do just that.
What is merging?
200
When you filter, the data that doesn't match the criteria are this.
What is hidden?
200
Changing this will sometimes allow you to fit all the data on one page by changing the direction of the text.
What is page orientation
200
Using the print command prints this.
What is the active worksheet?
300
If you wish to focus on only a range of data, you can do this to make the rest go away.
What is hide the data?
300
You must do this to a cell in order to remove any cell styles.
What is clear the cell?
300
This option is available when you have a range formatted as a table. It allow you to filter the data very quickly and easily.
What is AutoFilter?
300
This command can automatically fit your data onto a certain number of pages.
What is fit?
300
The print settings can be found in this tab.
What is the Print Layout tab?
400
If you have to scroll to see your data, it may be beneficial to do this to your header rows so that you can accurately identify each piece of data.
What is freeze?
400
If you merges cells, but now need to undo the merge, you can do this to the cells.
What is split the cells?
400
This symbol can represent any character in a custom AutoFilter.
What is ??
400
These allow for easy way to provide useful info on printed worksheets.
What are headers and footers?
400
Printing these on every page can make multi-page worksheets easier to follow.
What are column letters and row numbers?
500
This action divides a worksheet into two panes.
What is splitting?
500
Copying the contents of a cell also copies this.
What are formats?
500
This character can represent any series of characters.
What is *?
500
You can insert these fields into headers or footers.
What are dates, times, filenames, file paths, and page numbers?
500
The print settings are saved with this.
What is the workbook?
M
e
n
u