Name: 
 

Computer Literacy Module 2 Lesson 17



True/False
Indicate whether the sentence or statement is true or false.
 

 1. 

Each Excel workbook contains three worksheets by default.
 

 2. 

If desired, you can add new worksheets in your current Excel file.
 

 3. 

If you sort a last name column in ascending order, Adams would come before Williams.
 

 4. 

If you have labels at the top of your columns, you must sort them along with other data.
 

 5. 

When you click the Print button on the Standard toolbar, Excel prints all worksheets in the workbook using the default print settings.
 

 6. 

To fill in a series, a pattern must be established in the initial selection of cells.
 

 7. 

When you drag the fill handle down or to the right, the series increases. When you drag the fill handle up or to the left, the series will decrease.
 

 8. 

To apply an AutoFormat, you must first select the range of cells to be formatted.
 

 9. 

After you have applied an AutoFormat, you cannot make any further formatting changes.
 

 10. 

To sort data in a column from the smallest number to the largest number, you would click the Sort Descending button.
 

 11. 

It is possible to pause a print job in the middle of printing.
 

 12. 

To access the AutoFill Options shortcut menu, double-click the column head of the data column you want to fill.
 

 13. 

You cannot remove a worksheet once you have added it to a workbook.
 

 14. 

You can format text in a cell to align at any angle.
 

 15. 

You can select a standard header or footer for a worksheet or create customized text.
 

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

 16. 

The ____ feature enables you to quickly fill in the days of the week or the months in a year.
a.
AutoCorrect
c.
AutoFill
b.
AutoComplete
d.
QuickFill
 

 17. 

Labels at the top of columns make up the ____ row.
a.
column
c.
header
b.
label
d.
name
 

 18. 

The Sort command is in the ____ menu.
a.
Tools
c.
Format
b.
Edit
d.
Data
 

 19. 

When you ____ cells, you combine several cells into a single cell.
a.
merge
c.
span and center
b.
split
d.
merge and span
 

 20. 

To create a title that spans several columns or rows, click the ____ button on the Formatting toolbar.
a.
Merge
c.
Merge and Span
b.
Merge and Center
d.
Center
 

 21. 

AutoFormats include ____.
a.
borders
c.
data formatting
b.
shading
d.
all of the above
 

 22. 

When you drag the fill handle to the right, what would be the next number that would fill in the series 3, 6, 9?
a.
10
c.
12
b.
18
d.
27
 

 23. 

Excel automatically assigns the filename ____ and a sequential number to a new worksheet.
a.
Worksheet
c.
Page
b.
Sheet
d.
File
 

 24. 

To switch to a different worksheet, you click on the ____ at the bottom of the Excel screen.
a.
View button
c.
worksheet tab
b.
taskbar button
d.
none of the above
 

 25. 

To sort data in Excel, you must indicate the ____ you want to sort.
a.
row
c.
header
b.
column
d.
numbers
 

 26. 

How many different columns of data can you use in a worksheet sort?
a.
one
c.
three
b.
two
d.
as many as required
 

 27. 

The page setup settings you select will apply to ____.
a.
only the current worksheet
b.
all worksheets you create until you change the settings
c.
all the worksheets in a workbook
d.
new one-page worksheets
 

 28. 

To shrink a cell’s contents to fit within the cell, you would select an option from the ____ tab of the Format Cells dialog box.
a.
Fit
c.
Data
b.
Number
d.
Alignment
 

 29. 

You can use a formatting code to insert ____ in a header or footer.
a.
the date
c.
the filename
b.
page numbers
d.
all of the above
 

 30. 

The simplest way to print a worksheet using the default printing options is to click the ____ button.
a.
Default
c.
Print
b.
Worksheet
d.
QuickPrint
 

Completion
Complete each sentence or statement.
 

 31. 

____________________ orientation formats the content of the document with the short edge of the page at the top.
 

 

 32. 

____________________ orientation formats the content of the document sideways with the long edge of the page at the top.
 

 

 33. 

Excel’s ___________________ will complete a series of numbers that follow a set pattern.
 

 

 34. 

You can give your worksheet a professional design appearance by applying a(n) ____________________.
 

 

 35. 

To sort a worksheet by multiple criteria, you must open the ____________________ dialog box.
 

 

 36. 

The Sort buttons are available on the ___________________ toolbar in Excel.
 

 

 37. 

___________________ allows you to look at how a worksheet will appear on the page before you actually print it.
 

 

 38. 

To make sure a worksheet prints on one page, turn on the ____________________ feature.
 

 

 39. 

The ____________________ that indicate the boundaries of each cell in a spreadsheet do not appear on the printed worksheet.
 

 

 40. 

A(n) ____________________ is text that prints in the top margin of every worksheet page.
 

 

 41. 

Text that is printed at the bottom of every worksheet page but does not display in the worksheet window is called a(n) ___________________.
 

 

 42. 

To check the progress of a printing job, double-click the ____________________ icon on the taskbar.
 

 

 43. 

The list of jobs waiting to print is called the print ____________________.
 

 

 44. 

To create a title across several cells quickly, click the _________________________ button on the Formatting toolbar.
 

 

 45. 

The ____________________ tab in the Format Cells dialog box allows you to format numeric data with commas separating thousands.
 

 

 46. 

If you use AutoFill to fill a series of months across a row, the next entry in the series April, June, August would be ____________________.
 

 

 47. 

To give a worksheet a new name, you can right-click the ____________________ and then select Rename from the shortcut menu.
 

 

 48. 

You can use ____________________ to fill cells with or without formatting from the source cells.
 

 

 49. 

To control how the print output of a worksheet divides to more than one page, you can insert a manual ____________________ in a location of your choice.
 

 

 50. 

You change the margins of a worksheet in the ____________________ dialog box.
 

 



 
Check Your Work     Reset Help