Question 1

____ are used for seconds in a format code.

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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.

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

Formatting tables works best when there are existing background colors.

Accepted Answer

A) True 
 B)False

Question 7

Match between columns
                        Premises: Used to separate hours, minutes, and seconds in a format code.
Puts a percent sign with the number at the same location it appears in the format code.
The character which is a placeholder for a digit in a format code. Nothing will appear if there is not another number available.
Puts a dollar sign with the number at the same location it appears in the format code.
The character which is a placeholder for a digit in a format code. A zero will appear if there is not another number available.

Accepted Answer

The Answer of $ and 0 and # and : is...

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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.

Accepted Answer

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

Question 13

Describe how to add totals to rows in a table.

Accepted Answer

To add totals to rows in a table, you ty

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

The answer of ____________________ formatting applies a font, border, or...

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Excel refers to the row format as ____________________ rows.

Accepted Answer

The answer of Excel refers to the row format as...

Question 20

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

Accepted Answer

The answer of Themes that are loaded with Excel 2010...

Exam 31: Applying Advanced Formats to Worksheets

____ are used for seconds in a format code.

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

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.

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

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

Formatting tables works best when there are existing background colors.

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

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

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

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

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.

Describe how to add totals to rows in a table.

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

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

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

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

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

Excel refers to the row format as ____________________ rows.

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

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters