Excel Level 1 Chapter 4 ~ Study Guide

Name:

Multiple Choice
Identify the choice that best completes the statement or answers the question.

The funnel icon in this illustration indicates that

a.	Column F has been sorted by values in another column.
b.	Column F has been formatted.
c.	Column F can not be formatted.
d.	rows in column F have been filtered.

The Page Break view allows you to view

a.	and adjust your worksheet page breaks and margins.
b.	and adjust your worksheet page breaks, margins, and headers/footers.
c.	and adjust your worksheet page breaks.
d.	but not edit your worksheet page breaks.

When you use the Filter feature, what appears in each column label?

a.	a down-pointing arrow
b.	a hand
c.	a plus sign (+)
d.	an exclamation point (!)

When planning your own worksheet, your first step should be to

a.	create the formulas you will need.
b.	create a page layout.
c.	identify the purpose of the worksheet.
d.	enter the data.

As shown here, the number 0.3 in the Header box represents

a.	the top margin of the worksheet.
b.	the distance from the top of the page to the header.
c.	the distance from the bottom of the header to the bottom of the page.
d.	the height of the header.

Page breaks display as a broken __________ line in a worksheet.

a.	vertical and/or horizontal
b.	horizontal
c.	yellow
d.	vertical

When using the Sort and Filter button, by which column will the data be sorted?

a.	the first column on the worksheet (A)
b.	the first selected column
c.	the column containing the active cell
d.	the first column containing numbers

If you want to find specific data and replace it with other data, you can display the Find and Replace dialog box by

a.	clicking the Find & Select button in the Editing group on the Home tab.
b.	clicking the Search button in the Clipboard group on the Home tab.
c.	pressing Ctrl + R.
d.	clicking the Find & Select button in the Editing group on the Home tab, then clicking Replace.

Excel’s spelling checker can be started by clicking the Spelling button

a.	in the Editing group on the Home tab.
b.	in the drop-down list on the Office button.
c.	in the Proofing group on the Review tab.
d.	b or c

10.

The Format option in the expanded Find and Replace dialog box allows you to

a.	search for specific cell formatting and copy it to other cells.
b.	search for specific cell formatting and replace it with other formatting.
c.	format the display of the dialog box.
d.	change the formatting of the active cell.

11.

Clicking the filter arrow in a heading displays a list with all these options except

a.	filter all records.
b.	sort all records.
c.	create a custom filter.
d.	select an entry from the column.

12.

If you want to customize a print job you can display the Print dialog box by

a.	clicking Print on the Page Layout tab.
b.	clicking the Office button, then clicking Print.
c.	pressing Ctrl + P.
d.	b or c

13.

Where can you find options for printing headings and gridlines?

a.	on the Office button, Print page
b.	on the Sheet tab of the Page Setup dialog box
c.	on Page Layout tab, Sheet Options group
d.	b and c

14.

Which of the following is not one of the choices on the Print What option of the Print dialog box?

a.	First sheet
b.	Active sheet(s)
c.	Entire workbook
d.	Selection

15.

What happens if you select a column in a worksheet, then click Insert Page Break?

a.	Horizontal and vertical page breaks are inserted to the left of the column and above the active row.
b.	A page break is inserted to the left of the column.
c.	A vertical page break is inserted to the right of the column.
d.	The Page Setup dialog box is displayed.

16.

You can use the Undo button to reverse

a.	a deletion of cell data.
b.	formatting changes to a cell.
c.	changes made to cell data.
d.	All of these

17.

If you want to sort data on a column other than the default column, which method would you choose?

a.	Click the Sort & Filter button, then choose the sort order.
b.	Press Ctrl + S.
c.	Click the Sort & Filter button, then click Custom Sort.
d.	b and c

18.

To make rows and columns of data easier to identify when they spread across several pages, you should

a.	create appropriate headers.
b.	create appropriate footers.
c.	click the Page Layout tab, then the Print Titles button in the Page Setup group, and enter row and column ranges in the Print titles section.
d.	click the Page Layout tab, then the Print Titles button in the Page Setup group, and check Row and column headings in the Print section.

19.

Which of these tasks can not be accomplished by using the Header & Footer Design Tool?

a.	inserting a predesigned footer that automatically adds the word “Confidential”, the current date, and the page number
b.	displaying selected rows of data in the header on every page
c.	creating one header on odd pages and another on even pages
d.	creating a different footer on the first page

20.

When you click the Header and Footer button the worksheet displays in __________ view.

a.	Normal
b.	Page Layout
c.	Page Break Preview
d.	Print Preview

21.

Which of these are Header & Footer Elements found on the Header & Footer Tools Design tab?

a.	Page Number
b.	Current Time
c.	Picture
d.	All of these

22.

The Sort and Filter button on the Home Tab will sort data in

a.	the entire worksheet.
b.	the entire workbook.
c.	the selected cells.
d.	the protected cells.

23.

You can use Headers and Footers to print

a.	repeating rows of data at the top of each page.
b.	repeating columns of data at the left of each page.
c.	text, such as page numbers, at the top and bottom of each page.
d.	All of these

24.

If you wanted all the data on your worksheet to fit on one page when printed, you would use the __________ on the Page Layout tab.

a.	Print Area button in the Page Setup group
b.	Size button in the Page Setup group
c.	choices in the Scale to Fit group
d.	Margins button in the Page Setup group

25.

If you undo an action with the Undo button on the Quick Access toolbar and then decide that you want to reinstate the action, you

a.	can press the Undo button again to reverse the changes.
b.	can press Esc to reverse the changes.
c.	can press the Redo button.
d.	must perform the action again.

26.

Filter options are available in the

a.	Editing group on the Home tab.
b.	Text group on the Insert tab.
c.	drop-down list on the Office button.
d.	a and c

27.

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 box in the Sheet Options group on the Page Layout tab.
b.	Yes, the gridlines are printed by default whenever the worksheet is printed.
c.	No, the gridlines do not print by default, and you cannot make them print.
d.	No, the gridlines do not print by default, but you can print them by clicking the Quick Print button on the Quick Access toolbar.

28.

The Background button in the Page Setup group of the Page Layout tab allows you to

a.	add sound to your worksheet that will play in the background when the data is displayed.
b.	print a large worksheet in the “background” while continuing to enter data in the “foreground”.
c.	insert into the worksheet a background picture that displays behind the data.
d.	insert into the worksheet a background picture that displays behind the data and can also be printed.

29.

If a column contains numbers, you can filter those that are

a.	equal to a specified number.
b.	less than a specified number.
c.	the top ten numbers.
d.	All of these

30.

Click the Size button in the Page Setup group on the Page Layout tab

a.	to set the size of the print area.
b.	to change the size of the worksheet.
c.	to tell your printer to print on a paper size other than the default.
d.	to change the font size.

31.

Worksheet headers and footers are created by

a.	clicking the Header & Footer button in the Text group on the Insert tab.
b.	Excel and are automatically inserted into your worksheet.
c.	switching to Page Layout view and clicking the text Click to add header or Click to add footer.
d.	a or c

32.

In this illustration, which margin does not show the default setting?

a.	Left = 0.7
b.	Right = 0.7
c.	Top = 1.5
d.	Bottom = 0.75

33.

The Sheet tab in the Page Setup dialog box allows you to specify rows and/or columns to print on every page of your worksheet. How is this feature normally used?

a.	to repeat important numeric data on each page
b.	to make multiple copies when printing
c.	to print page summaries
d.	to print row and column titles

34.

The Margins tab of the Page Setup dialog box allows you to center

a.	text within a cell.
b.	text across a range of cells.
c.	a worksheet across a range of columns or rows.
d.	a worksheet vertically or horizontally on a page.

35.

If you specify more than one print area on a worksheet, how will they print?

a.	Only the first print area specified will print.
b.	They will print on separate pages.
c.	They will print on as few pages as possible.
d.	The areas will shrink to fit on one page.

36.

If you want to perform a find and replace operation on just the active worksheet (in a workbook with multiple worksheets), you should

a.	choose Sheet in the Within: drop-down list on the Replace tab of the Find and Replace dialog box.
b.	select all the cells in the worksheet.
c.	make sure the active worksheet appears first among all the other worksheets in the workbook.
d.	copy the worksheet into its own workbook.

37.

The Print Area feature allows you to

a.	print specific areas in a worksheet.
b.	print several worksheets on the same page.
c.	calculate in square inches or square centimeters the area of your worksheet that will be printed.
d.	prink blank “white spaces” in a worksheet.

38.

When planning your own worksheet, your final step should be to

a.	design the worksheet.
b.	enter the worksheet data.
c.	test the worksheet data.
d.	create a sketch of the worksheet.

39.

If you have accidentally pressed the Delete key while writing a complex formula in your worksheet, you will be happy to know that there is a(n) __________ button on the Quick Access toolbar.

a.	Search
b.	Undo
c.	Replace
d.	Redo

40.

The Margins tab of the Page Setup dialog box allows you to set margins and

a.	create custom headers and footers.
b.	set the page orientation.
c.	specify the paper size.
d.	adjust the distance between the header or footer and the top or bottom of the page.

41.

The two options for page orientation in the Page Layout tab, Page Setup group are

a.	Portrait and Landscape.
b.	Vertical and Horizontal.
c.	Top-to-Bottom and Side-to-Side.
d.	Left-to-Right and Right-to-Left.

42.

Excel’s default print settings can be changed by

a.	using the Print dialog box.
b.	clicking the Page Layout tab, Page Setup group, Print Area.
c.	clicking the Quick Print button on the Quick Access toolbar.
d.	All of these.

43.

The Pages option of the Print range section in the Print dialog box allows you to specify which

a.	worksheets in a workbook to print.
b.	pages within a worksheet to print.
c.	highlighted cells within a worksheet to print.
d.	print areas to print.

44.

Which of the following is not a sort option in Excel?

a.	Sort Smallest to Largest
b.	Sort Oldest to Newest
c.	Sort Ascending
d.	Sort Z to A

45.

What will happen if you check the Row and column headings option in the Sheet tab of the Page Setup dialog box?

a.	The row numbers and column letters in your worksheet will print along with the rest of the worksheet.
b.	You will be prompted to enter text to serve as titles for the rows and columns in your worksheet.
c.	The first row and first column of your worksheet will print on each page.
d.	Headers and footers will be printed along with the rest of your worksheet.

46.

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

a.	outline.
b.	what-if scenario.
c.	filter.
d.	sort.

47.

Which of these is a task that should be performed during the design stage of creating a worksheet?

a.	entering formulas into the worksheet
b.	verifying the accuracy of calculations
c.	determining how to organize the data
d.	formatting the worksheet

48.

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

a.	Yes, by repeating the same steps used to specify the first print area.
b.	Yes, but the print areas must be on different worksheets.
c.	Yes, by setting the first print area, then selecting the next print area, clicking the Print Area button, and then clicking Add to Print Area.
d.	No, you can only specify one print area.

49.

The Page Layout tab allows you to adjust the printed output by a percentage through the use of an option in the __________ group.

a.	Sheet Options
b.	Page Size
c.	Margins
d.	Scale to Fit

50.

What happens if you click the Options<< button near the lower right corner of this illustration?

a.	All Find and Replace options except the Find what: and Replace with: drop-down lists will be hidden.
b.	The Find tab will be displayed.
c.	A wizard will be started.
d.	More Find and Replace options will be displayed.