Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ETM 1030 > EL1 C4 > Flashcards

EL1 C4 Flashcards

1
Q

What generally displays in the Sort By option box at the Sort dialog box?

A

the title of the first column of selected cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Using the _____ dialog box to sort data in a column maintains the relationship among the data.

A

sort

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which of the following is not one of the paper sizes for an Excel worksheet at the Size button drop-down list?

A

landscape

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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?

A

Press the Redo button

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Use the Background button in the Page Setup group on the Page Layout tab to do which of the following?

A

Insert into the worksheet a background picture that displays behind the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A restriction placed temporarily on data in a worksheet to isolate specific data is called a(n)…

A

filter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the two options for page orientation in the Page Setup group on the Page Layout tab?

A

portrait and landscape

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You can find options for printing headings and gridlines on the Sheet tab at the Page Setup dialog box and

A

in the Sheet Options group on the Page Layout tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Do the worksheet gridlines appear by default when printed? If not, can you instruct Excel to print them? How?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Use this keyboard shortcut to redo an action.

A

CRTL + Y

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Using options at the Page Setup dialog box with the Margins tab selected, you can center a worksheet…

A

both vertically and horizontally on a page

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Excel’s spelling check feature reviews the worksheet from _____ to _____.

A

the active cell; the last cell in the worksheet that contains data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Use the Search option at the expanded Find and Replace dialog box to search by _____ or _____.

A

rows; columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

To sort data by a column other than the default column, which of the following methods should you use?

A

Click the Sort & Filter button and then click Custom Sort

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Page breaks display as _____ along cell borders in a worksheet.

A

dashed lines

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

To use Excel’s spelling check feature, click the Spelling button in the _____ group on the_____ tab.

A

Proofing; Review

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

To fit all the data in a worksheet on one page when printed, you should use the _____ on the Page Layout tab.

A

buttons in the Scale to Fit group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Use the Print Area button in the Page Setup group on the Page Layout tab to…

A

print specific areas of a worksheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

You can find options for printing headings and gridlines on the Sheet tab at the Page Setup dialog box and…

A

in the Sheet Options group on the Page Layout tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

When you click the Sort & Filter button on the Home tab, data will be sorted in…

A

selected cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

When you filter data, the filter arrow in the column header turns into a(n) _____ icon.

A

funnel

22
Q

How do you display the Find and Replace dialog box?

A

Click the Find & Select button in the Editing group on the Home tab and then click Find.

23
Q

Which of the following buttons is not found on the Header & Footer Tools Design tab?

A

background

24
Q

What are the default left/right and top/bottom margins of an Excel worksheet?

A

0.7 inch and 0.75 inch

25
Q

You can preview headers and footers before printing the worksheet…

A

at the Print backstage area

26
Q

When you specify that column titles are to print on worksheet pages, how does Excel know what cells to use as the column titles?

A

You specify the range in the Rows to repeat at top text box in the Page Setup dialog box.

27
Q

Filter options are available in the _____ group on the _____ tab.

A

Editing; Home

28
Q

You can adjust the printed output of a worksheet by a percentage using an option in the _____ group.

A

Scale to Fit

29
Q

You can use the Undo button to…

A

reverse a command

30
Q

If you specify multiple print areas in a worksheet, how will they print?

A

The areas will print on separate pages

31
Q

At the Page Setup dialog box with the Margins tab selected, you can set margins and…

A

adjust the distance between the header or footer and the top or bottom of the page

32
Q

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.

A

Header; Odd Page Header

33
Q

Clicking the filter arrow in a heading will display a list of options to do all the following except…

A

sort all the records

34
Q

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.

A

Within

35
Q

Which of the following is not a sort option at the Sort & Filter button drop-down list?

A

Sort Even/Odd

36
Q

Click the Page Break Preview button to view worksheet pages and page breaks and to change which of the following?

A

worksheet page breaks

37
Q

To remove formatting at the Find and Replace dialog box, click the Clear Find Format option at the _____ button drop-down list.

A

Find

38
Q

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?

A

to print row and column titles on multipage worksheets

39
Q

If the selected cells contain dates, what sort options will be provided at the Sort & Filter button drop-down list?

A

Sort Oldest to Newest and Sort Newest to Oldest

40
Q

You can use headers and footers to print which of the following?

A

text, such as page numbers, at the top and bottom of each page

41
Q

At the Page Setup dialog box with the Margins tab selected, the value in the Header measurements box is which of the following?

A

the distance from the top of the page to the header

42
Q

When you click the Header & Footer button, the worksheet displays in _____view.

A

Page Layout

43
Q

What happens if you select a column in a worksheet and then click Insert Page Break on the Breaks button?

A

A page break is inserted left of the column

44
Q

Excel is primarily a spreadsheet program, but it also contains some basic _____ functions, such as sorting data.

A

database

45
Q

Can you specify more than one print area? If so, how?

A

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

46
Q

When data is sorted using the Sort & Filter button, it is sorted by which column?

A

the first selected column

47
Q

At the expanded Find and Replace dialog box, you can do which of the following?

A

Search for specific cell formatting and replace it with other formatting

48
Q

Which of these tasks cannot be accomplished using options on the Header & Footer Tools Design tab?

A

displaying selected rows of data in the header on every page

49
Q

When you use the Filter feature, a(n) _____ appears with each column label in the worksheet.

A

arrow

50
Q

Insert and customize headers and footers with options at the _____ dialog box with the Header/Footer tab selected.

A

Page Setup

51
Q

When would you use the Then by option at the Sort dialog box?

A

to sort by more than one column

52
Q
A

ETM 1030 (18 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions