CGS Excel Chapter 4
Activating Page Layout View using the Status Bar button automatically bring up the Header and Footer Tools Design Tab.
False
If you want to split the worksheet into four panes, double-click the split button in the View tab of the Ribbon after selecting the entire worksheet.
False
Click AutoFit Row Height from the ___button in the cells group of the Home tab to autofit a row.
Format
If your worksheet has both a header row and a column of labels in the first column use the ____ option to freeze the worksheet at the selected rows above the cell and the columns to the left of the cell are always visible.
Freeze Panes
Splitting your worksheet will undo the ___command.
Freeze Panes
Page Layout View is not compatible with ___.
Freeze Panes.
In _____, Excel shows the aspects of the worksheet that are visible only on-screen.
Normal view
Click the __ box and enter a percentage to grow or shrink the worksheet when printed.
Scale
By default, gridlines are visible on-screen when you are working in Excel but they do not print.
True
Clicker the Header & Footer button in the Insert tab of the Ribbon will automatically switch you to Page Layout view and place your insertion point in the Header area.
True
Headings are the numbers at the left of rows and the letters at the top of columns.
True
The Freeze Panes button is located in the __ tab on the ribbon.
View
The freeze panes button is located in the Window group of the ___ tab.
View
if you select an entire column and then click the Insert button, Excel will automatically insert a ___.
column
Clicking the ____ selects an entire column in a worksheet.
column selector
If your worksheet includes a large table of data that prints on more than one page, you should ensure that the ___ or ___ labels to print on every page.
column; row
A _____ is text that appears at the bottom of every page.
footer
A ___ is text that appears at the top of every page.
header
If your workbook is wide, you may want to use ___ orientation to view more columns on one page.
landscape
If you want to adjust the width of a column manually, move your mouse over the ____ column boundary and click and drag until the column is the width you want.
right
Clicking the ____ selects an entire row in a worksheet.
row selector
One method to delete a worksheet is to right click on a sheet ___ and select Delete from the shortcut menu.
tab
A ___ is a unfied color, font, and effects scheme that is applied to a workbook.
theme
In Excel you can split the worksheet view into ____ or ____ panes.
two;four
By default, all the worksheet tabs in Excel are the color ___.
white
