Question 1

Number fills change the way data looks in a cell.

Accepted Answer

A) True 
 B)False  False

Question 2

To remove a style from the selected cell, simply click Good in the Good, Bad and Neutral section of the Cell Styles gallery.

Accepted Answer

A) True 
 B)False  False

Question 3

Format Painter enables you to copy formatting from one worksheet cell to another without copying the cell's contents.

Accepted Answer

A) True 
 B)False  True

Question 4

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh wants to get to the Cell Styles gallery. How does he navigate to the Cell Style gallery?

Accepted Answer

A)  In the Styles group on the Home tab of the Ribbon, click the Cell Styles button. 
B)  In the Editing group on the Themes tab of the Ribbon, click the Cell Styles button. 
C)  In the Editing group on the Home tab of the Ribbon, click the Cell Styles button. 
D)  None of the above 
A)  In the Styles group on the Home tab of the Ribbon, click the Cell Styles button. 
B)  In the Editing group on the Themes tab of the Ribbon, click the Cell Styles button. 
C)  In the Editing group on the Home tab of the Ribbon, click the Cell Styles button. 
D)  None of the above

Question 5

Press the Ctrl+B keys to apply bold.

Accepted Answer

A) True 
 B)False

Question 6

You can select a different theme for your workbook. Click the ____ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

Accepted Answer

A)  Page Layout 
B)  Layout 
C)  Format 
D)  Page Format 
A)  Page Layout 
B)  Layout 
C)  Format 
D)  Page Format

Question 7

When you select the Merge & Center button, only the contents from the cell in the ____ corner of the range are kept. All other content is deleted from the worksheet.

Accepted Answer

A)  upper-left 
B)  lower-left 
C)  upper-right 
D)  lower-right 
A)  upper-left 
B)  lower-left 
C)  upper-right 
D)  lower-right

Question 8

By default, the ____ theme is applied to each workbook.

Accepted Answer

A)  Excel 
B)  Office 
C)  Business 
D)  Blank 
A)  Excel 
B)  Office 
C)  Business 
D)  Blank

Question 9

You can remove the borders from a selected cell by clicking ____ in the border style menu.

Accepted Answer

A)  Transparent 
B)  Border Off 
C)  Blank 
D)  No Border 
A)  Transparent 
B)  Border Off 
C)  Blank 
D)  No Border

Question 10

Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell.

Accepted Answer

A)  bottom-right 
B)  upper-right 
C)  bottom-left 
D)  upper-left 
A)  bottom-right 
B)  upper-right 
C)  bottom-left 
D)  upper-left

Question 11

Excel ____ all numbers.

Accepted Answer

A)  right-aligns 
B)  left-aligns 
C)  top-aligns 
D)  bottom-aligns 
A)  right-aligns 
B)  left-aligns 
C)  top-aligns 
D)  bottom-aligns

Question 12

A format is the design of text.

Accepted Answer

A) True 
 B)False

Question 13

To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.

Accepted Answer

A) True 
 B)False

Question 14

Please briefly describe these three ways to position data within cells: Orientation, Wrap Text, and Merge. Also, include an example of when you would use each type of positioning.

Accepted Answer

-Orientation: Rotates cell contents to a

Question 15

Case EX 2-1 Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below. Tessa wants to find and replace italic text with bold text. Where can she find the dialog box to do this?

Accepted Answer

A)  On the Home tab, in the Editing group, click the Find & Select button, and then click Replace. 
B)  On the Ribbon, in the Formatting group, click the Find & Select button, and then click Replace. 
C)  On the Home tab, in the Proofing group, click the Find & Select button, and then click Find. 
D)  None of the above. 
A)  On the Home tab, in the Editing group, click the Find & Select button, and then click Replace. 
B)  On the Ribbon, in the Formatting group, click the Find & Select button, and then click Replace. 
C)  On the Home tab, in the Proofing group, click the Find & Select button, and then click Find. 
D)  None of the above.

Question 16

If you want to specify a precise column width, use the Column Width ____.

Accepted Answer

A)  wizard 
B)  task pane 
C)  status bar 
D)  dialog box 
A)  wizard 
B)  task pane 
C)  status bar 
D)  dialog box

Question 17

To change the background color of a cell, select the cell you want to change. On the Home tab of the Ribbon, in the Font group, click the Background Color button arrow.

Accepted Answer

A) True 
 B)False

Question 18

As you format cells, ____ shows the results of the different formatting options you can choose.

Accepted Answer

A)  Print Preview 
B)  Live Preview 
C)  Gallery Preview 
D)  Format Preview 
A)  Print Preview 
B)  Live Preview 
C)  Gallery Preview 
D)  Format Preview

Question 19

The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.

Accepted Answer

A) True 
 B)False

Question 20

To change the alignment of a cell, select the cell, and then click an alignment button in the Alignment group on the ____________________ tab of the Ribbon.

Accepted Answer

The answer of To change the alignment of a cell,...

Exam 24: Changing the Appearance of a Worksheet

Number fills change the way data looks in a cell.

To remove a style from the selected cell, simply click Good in the Good, Bad and Neutral section of the Cell Styles gallery.

Format Painter enables you to copy formatting from one worksheet cell to another without copying the cell's contents.

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh wants to get to the Cell Styles gallery. How does he navigate to the Cell Style gallery?

Press the Ctrl+B keys to apply bold.

You can select a different theme for your workbook. Click the ____ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

When you select the Merge & Center button, only the contents from the cell in the ____ corner of the range are kept. All other content is deleted from the worksheet.

By default, the ____ theme is applied to each workbook.

You can remove the borders from a selected cell by clicking ____ in the border style menu.

Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell.

Excel ____ all numbers.

A format is the design of text.

To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.

Please briefly describe these three ways to position data within cells: Orientation, Wrap Text, and Merge. Also, include an example of when you would use each type of positioning.

Case EX 2-1 Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below. Tessa wants to find and replace italic text with bold text. Where can she find the dialog box to do this?

If you want to specify a precise column width, use the Column Width ____.

To change the background color of a cell, select the cell you want to change. On the Home tab of the Ribbon, in the Font group, click the Background Color button arrow.

As you format cells, ____ shows the results of the different formatting options you can choose.

The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.

To change the alignment of a cell, select the cell, and then click an alignment button in the Alignment group on the ____________________ tab of the Ribbon.

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

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

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