Exam 31: Applying Advanced Formats to Worksheets

You can switch between banded rows and banded columns using the ____ tab.

Occasionally you may need to apply a number format that is not already predefined in the existing number formats.

____ provide professional presentation features for displaying worksheet data.

Excel has predefined ____ for numbers such as Greater Than, Less Than, Above Average, and Below Average.

AutoFilters are automatically added to the data when you format data as a table.

After you select a format for your table, the Table Format tab appears on the Ribbon.

To convert a table back to a normal range, but keep the data and table style formatting, click the ____ tab on the Ribbon, then click the Convert to Range option in the Tools group.

Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea would like to highlight the months where her spending was more than her earnings. She needs to use a ____ formatting formula.

Themes are a simple way to make your worksheet appear more professional.

Before you apply a theme, you need to add some basic formatting to the data, such as a table format, so that Excel knows how to apply the theme to your worksheet.

Case EX 9-2 Matt runs a local cat shelter. He uses an Excel workbook to store information about the various cats residing at the shelter. If Matt needs to only display the information about male cats who are older than 3 years, he can use a ____.

Formats are composed of ____.

The New Formatting Rule dialog box is opened through the ____ group on the Home tab.

Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea wants to display the months in the format 2014-March. She needs to ____.

If the last cell in the lower-right corner of a table is selected, you can press ____ to create a new, formatted row.

The ____ character divides the parts of the format code.

With ____, you can have borders, background colors, shading, and graphic effects applied instantly to an entire workbook.

When formatting tables, you should be sure that there are no blank columns or rows .

To keep the table formatting intact, it is best to use the commands on the Insert and Delete menus in the ____ group on the Home tab.

You can create your own conditional format rule based on a formula called a(n) ____________________ formula.