this contains column headings or field names in a data source.
What is header rows?
100
The ___ command scales the worksheet up or down as neccessary to fit the worksheet data on the designated number of pages.
What is page orientation?
100
A workbook can contain a maximum of three worksheets.
What is false?
100
You do this to combine several cells into a single cell,
What is merge?
100
To overcome the problem of rows and columns from going out of view when you scroll, you can do this.
What is change the zoom settings or freeze?
200
When you do this to a column or row, you lock them so you can keep an area visible as you scroll through the worksheet.
What is freeze?
200
Using default settings, ___ will print.
What is cell styles?
200
The Page Break Preview View will show exactly how the worksheet will print.
What is true?
200
when you do this to a cell, it changes the way it appears.
What is formatting the cell?
200
Excel is useful for organizing data into this.
What is categories?
300
this appears at the bottom of the screen for quick and easy access to the worksheet
What is sheet tab?
300
To sort worksheet data, you must indicate the ___ or on which you wan to base the sort.
What is criteria?
300
Excel aligns text at the right of the cell and numbers at the left by default.
What is false?
300
You do this when the text doesn't fit on one line.
What is wrap?
300
This is a set of predfined formats you can apply to all of the worksheet data with a single click.
What is table styles?
400
A set of predefined formats you can apply to some of the worksheet data such as a header row, a cell showing a total, or a cell showing the date and time
What is cell style?
400
To span text across several columns, ____ several cells.
What is merge?
400
When you delete the content of a cell using the Delete Key or the Backspace Key, the formats for the cell remain in the cell.
What is true?
400
To apply this, you must first select a cell or a range of cells to be formatted.
What is a cell style?
400
You can look at the worksheet in this to see what it'll look like when printed.
What is print preview?
500
when you do this, you screen data that matches specified criteria
What is filter?
500
The header and footer fields can provide automatic updates for ___.
What is the date, the file name, or the file path?
500
When worksheet rows and columns are hidden, the data remains intact.
What is true?
500
You can sort the data in the worksheet by doing this.
What is filtering?
500
These will not print with default print settings.
What is gridlines, row numbers, and column letters?