Deck 31: Applying Advanced Formats to Worksheets

Question 1

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.

Answer 1

True

Question 2

You can remove conditional formatting rules by clicking the ____ group on the Home tab, clicking the Conditional Formatting button arrow, and then clicking Clear Rules.

A) Styles
B) Font
C) Cells
D) Editing

Answer 2

A

Question 3

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

Answer 3

True

Question 4

The Custom AutoFilter is a feature that lets you display only cells that meet specific criteria.

Question 5

____ are used for seconds in a format code.

A) Sec or sec
B) S or s
C) S% or s%
D) Sec# or sec#

Question 6

Excel offers quite a variety of table sizes in the Table Format gallery.

Question 7

Theme formats apply to your entire workbook with the exception of very few objects, such as an embedded object.

Question 8

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

Question 9

When you create a table in Excel, the rows and columns appear with the same format.

Question 10

The ____ character divides the parts of the format code.

A) ; (semicolon)
B) : (colon)
C) . (period)
D) , (comma)

Question 11

Formatting tables works best when there are existing background colors.

Question 12

If you change a theme in one worksheet, it does not affect the themes in other worksheets.

Question 13

The AutoFormat button cannot be added to the Quick Access Toolbar.

Question 14

You can create your own number format by selecting the ____ category in the Format Cells dialog box.

A) General
B) Special
C) User
D) Custom

Question 15

By applying conditional formats and criteria, you can then view the cell formats to see which cells met the condition.

Question 16

Format codes are simply strings of characters that represent the actual data.

Question 17

Formats are composed of ____.

A) numbers
B) letters
C) codes
D) symbols

Question 18

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

Question 19

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

Question 20

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

Question 21

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

A) Page Layout
B) Data
C) Review
D) Table Tools Design

Question 22

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

A) Alignment
B) Editing
C) Styles
D) Number

Question 23

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

A) Shift
B) Ctrl
C) Alt
D) Tab

Question 24

FIGURE EX 9-1 In Figure EX 9-1 above, you need to click the Format button to open the ____ dialog box.

A) Formatting
B) Format Cells
C) AutoFilter format
D) Fill

Question 25

The ____________________ character puts a comma with the number at the same location it appears in the format code.

Question 26

The Themes group is found on the ____ tab of the Ribbon.

A) Home
B) Page Layout
C) Data
D) Insert

Question 27

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.

A) Editing
B) Cells
C) Font
D) Styles

Question 28

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 ____.

A) Conditional Format
B) Custom AutoFilter
C) Universal Search
D) Banded search

Question 29

____ provide professional presentation features for displaying worksheet data.

A) Queries
B) Tables
C) Modules
D) Macros

Question 30

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. Right now, Matt's workbook uses very basic formatting. To create a formatted table from the range of cells, he needs to use the ____ gallery.

A) Create Table
B) Table Format
C) Table Range
D) New Table

Question 31

Formatting where the rows and columns of a table appear in different formats is referred to as ____.

A) staging
B) banding
C) stripes
D) boxing

Question 32

To remove AutoFilters from a table, select the row with the AutoFilters, click the Sort & Filter button in the ____ group, and then click the Filter option to remove the filters.

A) Styles
B) Font
C) Cells
D) Editing

Question 33

FIGURE EX 9-1 The dialog box in Figure EX 9-1 above allows you to use a formula to apply ____.

A) filtering
B) trace formatting
C) banding
D) conditional formatting

Question 34

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.

A) theme
B) filter
C) banded
D) conditional

Question 35

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 ____.

A) use one of Excel's existing number formats
B) create a custom number format
C) create a new theme
D) apply an existing theme

Question 36

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

A) tables
B) themes
C) AutoFilters
D) conditional formatting

Question 37

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.

A) Editing
B) Home
C) Table Tools
D) Design

Question 38

To filter for number data that is not already defined in the Number Filters menu, create a ____.

A) UserFilter
B) CustomFilter
C) custom AutoFilter
D) secondary AutoFilter

Question 39

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

A) formats
B) designs
C) tables
D) filters

Question 40

You can create a custom format for your conditional format by clicking the ____ button in the New Formatting Rule dialog box.

A) Customize
B) Reveal
C) Modify
D) Format

Question 41

Themes that are loaded with Excel 2010 are located in the ____________________ gallery.

Question 43

____________________ formatting applies a font, border, or pattern to worksheet cells when certain conditions exist in those cells.

Question 44

Describe how to add totals to rows in a table.

Question 45

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

Question 46

Excel refers to the row format as ____________________ rows.