Managing Worksheets
Formatting Cell Contents
Formatting the Page Layout
Customizing Print Options
Definitions
100
If you reduce the ______ significantly, you won't be able to read the data in the worksheet.
What is magnification?
100
To span text across several columns, _______.
What is merge several cells?
100
Before printing a worksheet, you should look at it in _____ _____.
What is Print Preview?
100
You can change the print settings using commands on the ______ _______ tab.
What is Page Layout?
100
When you _____ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.
What is freeze?
200
An alternative way to freeze rows and columns is to _____ a worksheet.
What is split?
200
The merge and center button is in the ______ group on the Home tab.
What is Alignment?
200
The _____ _____ _____ view will show exactly how the worksheet will print.
What is Page Break Preview?
200
If you don't want to print the entire worksheet, you can identifythe _____ you want to print before you choose the print command.
What is range?
200
To divide worksheets into two panes.
What is split?
300
When you need to add a new category to an excel workbook, you click the ______ ______ button.
What is Insert Worksheet?
300
Two common uses of spreadsheets include
What is reporting finances, managing expenses and budgets, and tracking student grades? (any two)
300
______ can be used to insert dates, times, filenames, the file path, and page numbers automatically.
What is fields?
300
When using the default print settings, _______ will not print.
What is gridlines?
300
A tab in the horizontal scroll bar to provide quick and easy access to a worksheet.
What is a sheet tab?
400
One way to keep rows and columns visible as you navigate a worksheet is to _____ them.
What is freeze?
400
By default, Excel aligns text at the _____ side of the cell and numbers at the _____ side of the cell.
What is left, right?
400
A header is printed in the _____ margin of every worksheet page.
What is top?
400
By default, ________ added to the worksheets do not print.
What is comments?
400
A set of predefined formats that you can apply to all of the worksheet data with a single click.
What is a table style?
500
Excel is useful for organizing data into ______.
What is categories?
500
You can use the _______ _______ to copy the format of a worksheet cell without copying the contents of the cell.
What is Format Painter?
500
When the worksheet is more than one page in length, Excel determines where to _____ the page and begin a new one.
What is break?
500
Before ______ take the time to see what the printed copy will look like.
What is printing?
500
To screen for data matching specified criteria.
What is filter data?
M
e
n
u