Question 1

Page Break Preview displays your page as it will look when printed. ____________________

Accepted Answer

A) True 
 B)False  True

Question 2

A ____ contains column headings or field names in a data source.

Accepted Answer

A)   header row
B)   column header
C)   table header
D)   footer A

Question 3

A ____ is the design of the typeface.

Accepted Answer

A)   point
B)   style
C)   font
D)   format C

Question 4

If the text does not fit on one line of a cell, you can wrap to new lines.

Accepted Answer

A) True 
 B)False

Question 5

When you ____ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.

Accepted Answer

A)   split
B)   freeze
C)   hide
D)   unhide

Question 6

An example of a font size is 12 _____.

Accepted Answer

A)   characters
B)   points
C)   pixels
D)   millimeters

Question 7

In Excel, a cell's width is automatically adjusted when the font size changes.

Accepted Answer

A) True 
 B)False

Question 8

When filtering data, you can control the screen data displayed by specifying certain criteria.

Accepted Answer

A) True 
 B)False

Question 9

To display the current date in a footer, insert the date ____________________.

Accepted Answer

The answer of To display the current date in a...

Question 10

To change the angle of the text direction, click the ____________________ button.

Accepted Answer

The answer of To change the angle of the text...

Question 11

When a comment is added to a selected cell, it can be viewed in _____.

Accepted Answer

A)   a ScreenTip
B)   the VIEW tab
C)   the formula bar
D)   Live Preview

Question 12

The header and footer commands are located on the ____ tab.

Accepted Answer

A)   HOME
B)   FILE
C)   PAGE LAYOUT
D)   INSERT

Question 13

In a worksheet, a split can be removed by double-clicking the split bar.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is NOT true about changing alignment?

Accepted Answer

A)   By default, Excel aligns text at the left of the cell.
B)   You can adjust the alignment of the content of a cell vertically.
C)   You can decrease the margin between the edge of the cell and the cell contents.
D)   All of the above are true.

Question 15

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.

Accepted Answer

A)   hides
B)   filters
C)   freezes
D)   splits

Question 16

How many worksheets are contained in a blank workbook by default? Why would you add a new worksheet to a workbook? What do you click to display a different worksheet? Can you copy and paste data from one worksheet to another? List at least one method for inserting a new worksheet. What happens when you delete a tab for a worksheet that contains data?

Accepted Answer

The answer of How many worksheets are contained in a...

Question 17

To remove the data and the formats from a cell, you need to ____________________ the cell.

Accepted Answer

The answer of To remove the data and the formats...

Question 18

The default Zoom setting is 75%.

Accepted Answer

A) True 
 B)False

Question 19

Spreadsheets are often used for reporting finances and managing expenses.

Accepted Answer

A) True 
 B)False

Question 20

When you use the Insert Sheet button, the new sheet tab appears to the right of the active sheet tab.

Accepted Answer

A) True 
 B)False

Exam 19: Organizing and Enhancing Worksheets

Page Break Preview displays your page as it will look when printed. ____________________

A ____ contains column headings or field names in a data source.

A ____ is the design of the typeface.

If the text does not fit on one line of a cell, you can wrap to new lines.

When you ____ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.

An example of a font size is 12 _____.

In Excel, a cell's width is automatically adjusted when the font size changes.

When filtering data, you can control the screen data displayed by specifying certain criteria.

To display the current date in a footer, insert the date ____________________.

To change the angle of the text direction, click the ____________________ button.

When a comment is added to a selected cell, it can be viewed in _____.

The header and footer commands are located on the ____ tab.

In a worksheet, a split can be removed by double-clicking the split bar.

Which of the following is NOT true about changing alignment?

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.

To remove the data and the formats from a cell, you need to ____________________ the cell.

The default Zoom setting is 75%.

Spreadsheets are often used for reporting finances and managing expenses.

When you use the Insert Sheet button, the new sheet tab appears to the right of the active sheet tab.