EL1 C4 Flashcards
What generally displays in the Sort By option box at the Sort dialog box?
the title of the first column of selected cells
Using the _____ dialog box to sort data in a column maintains the relationship among the data.
sort
Which of the following is not one of the paper sizes for an Excel worksheet at the Size button drop-down list?
landscape
If you undo an action with the Undo button on the Quick Access Toolbar and then decide that you want to reinstate the action, what should you do?
Press the Redo button
Use the Background button in the Page Setup group on the Page Layout tab to do which of the following?
Insert into the worksheet a background picture that displays behind the data
A restriction placed temporarily on data in a worksheet to isolate specific data is called a(n)…
filter
What are the two options for page orientation in the Page Setup group on the Page Layout tab?
portrait and landscape
You can find options for printing headings and gridlines on the Sheet tab at the Page Setup dialog box and
in the Sheet Options group on the Page Layout tab
Do the worksheet gridlines appear by default when printed? If not, can you instruct Excel to print them? How?
No, the gridlines do not print by default, but you can print them by checking the Print check box in the Sheet Options group on the Page Layout tab.
Use this keyboard shortcut to redo an action.
CRTL + Y
Using options at the Page Setup dialog box with the Margins tab selected, you can center a worksheet…
both vertically and horizontally on a page
Excel’s spelling check feature reviews the worksheet from _____ to _____.
the active cell; the last cell in the worksheet that contains data
Use the Search option at the expanded Find and Replace dialog box to search by _____ or _____.
rows; columns
To sort data by a column other than the default column, which of the following methods should you use?
Click the Sort & Filter button and then click Custom Sort
Page breaks display as _____ along cell borders in a worksheet.
dashed lines
To use Excel’s spelling check feature, click the Spelling button in the _____ group on the_____ tab.
Proofing; Review
To fit all the data in a worksheet on one page when printed, you should use the _____ on the Page Layout tab.
buttons in the Scale to Fit group
Use the Print Area button in the Page Setup group on the Page Layout tab to…
print specific areas of a worksheet.
You can find options for printing headings and gridlines on the Sheet tab at the Page Setup dialog box and…
in the Sheet Options group on the Page Layout tab
When you click the Sort & Filter button on the Home tab, data will be sorted in…
selected cells
When you filter data, the filter arrow in the column header turns into a(n) _____ icon.
funnel
How do you display the Find and Replace dialog box?
Click the Find & Select button in the Editing group on the Home tab and then click Find.
Which of the following buttons is not found on the Header & Footer Tools Design tab?
background
What are the default left/right and top/bottom margins of an Excel worksheet?
0.7 inch and 0.75 inch
You can preview headers and footers before printing the worksheet…
at the Print backstage area
When you specify that column titles are to print on worksheet pages, how does Excel know what cells to use as the column titles?
You specify the range in the Rows to repeat at top text box in the Page Setup dialog box.
Filter options are available in the _____ group on the _____ tab.
Editing; Home
You can adjust the printed output of a worksheet by a percentage using an option in the _____ group.
Scale to Fit
You can use the Undo button to…
reverse a command
If you specify multiple print areas in a worksheet, how will they print?
The areas will print on separate pages
At the Page Setup dialog box with the Margins tab selected, you can set margins and…
adjust the distance between the header or footer and the top or bottom of the page
When creating different odd and even page headers, clicking the Different odd and even pages check box and then clicking the Custom Header button at the Page Setup dialog box with the Header/Footer tab selected will display the _____ dialog box with the _____ tab selected.
Header; Odd Page Header
Clicking the filter arrow in a heading will display a list of options to do all the following except…
sort all the records
To perform a find and replace operation across an entire workbook, you should change the _____ option to Workbook at the Find and Replace dialog box.
Within
Which of the following is not a sort option at the Sort & Filter button drop-down list?
Sort Even/Odd
Click the Page Break Preview button to view worksheet pages and page breaks and to change which of the following?
worksheet page breaks
To remove formatting at the Find and Replace dialog box, click the Clear Find Format option at the _____ button drop-down list.
Find
At the Page Setup dialog box with the Sheet tab selected, you can specify rows and/or columns to print on every page of the worksheet. How is this feature normally used?
to print row and column titles on multipage worksheets
If the selected cells contain dates, what sort options will be provided at the Sort & Filter button drop-down list?
Sort Oldest to Newest and Sort Newest to Oldest
You can use headers and footers to print which of the following?
text, such as page numbers, at the top and bottom of each page
At the Page Setup dialog box with the Margins tab selected, the value in the Header measurements box is which of the following?
the distance from the top of the page to the header
When you click the Header & Footer button, the worksheet displays in _____view.
Page Layout
What happens if you select a column in a worksheet and then click Insert Page Break on the Breaks button?
A page break is inserted left of the column
Excel is primarily a spreadsheet program, but it also contains some basic _____ functions, such as sorting data.
database
Can you specify more than one print area? If so, how?
Yes, by selecting the first print area, clicking the Print Area button, clicking Set Print Area, selecting the next print area, clicking the Print Area button, and then clicking Add to Print Area
When data is sorted using the Sort & Filter button, it is sorted by which column?
the first selected column
At the expanded Find and Replace dialog box, you can do which of the following?
Search for specific cell formatting and replace it with other formatting
Which of these tasks cannot be accomplished using options on the Header & Footer Tools Design tab?
displaying selected rows of data in the header on every page
When you use the Filter feature, a(n) _____ appears with each column label in the worksheet.
arrow
Insert and customize headers and footers with options at the _____ dialog box with the Header/Footer tab selected.
Page Setup
When would you use the Then by option at the Sort dialog box?
to sort by more than one column
