Question 1

As shown in the figure above, item ____ points to the button that italicizes text.

Accepted Answer

A)  1 
B)  2 
C)  4 
D)  6 
A)  1 
B)  2 
C)  4 
D)  6

Question 2

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

Accepted Answer

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

Question 3

What is meant by the format of a cell? How do you format a cell or range?

Accepted Answer

The format of a cell determines how the

Question 4

As shown in the figure above, item 2 is the ____ button.

Accepted Answer

A)  Number Format 
B)  Accounting Format 
C)  Currency Style 
D)  Percent Style 
A)  Number Format 
B)  Accounting Format 
C)  Currency Style 
D)  Percent Style

Question 5

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: A type of conditional formatting that visually illustrates differences among values.
A predefined set of attributes that gives your Excel worksheet a professional look.
The name for a collection of characters (letters, numerals, symbols, and punctuation marks) with a similar, specific design.
Equal to 1/72 of an inch.
Has a default value of 8.43 characters, a little less than one inch.

Accepted Answer

The Answer of font and column width and point and is...

Question 7

As shown in the figure above, item 2 points to the ____ button in the Styles group on the Home tab of the Ribbon.

Accepted Answer

A)  Format as Table 
B)  Cell Styles 
C)  Format Painter 
D)  Conditional Formatting 
A)  Format as Table 
B)  Cell Styles 
C)  Format Painter 
D)  Conditional Formatting

Question 8

You can apply attributes and alignment options using the ____ dialog box.

Accepted Answer

A)  Format Cells 
B)  Insert 
C)  Conditional Formatting 
D)  AutoCorrect 
A)  Format Cells 
B)  Insert 
C)  Conditional Formatting 
D)  AutoCorrect

Question 9

You can change the font and font size of any cell or range using the Mini toolbar.

Accepted Answer

A) True 
 B)False

Question 10

To add a clip to a worksheet, click Clip Art in the Illustrations group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 11

You can change the ____ of labels and values in cells to be left, right, or center.

Accepted Answer

A)  font 
B)  font size 
C)  cell style 
D)  alignment 
A)  font 
B)  font size 
C)  cell style 
D)  alignment

Question 12

As shown in the figure above, item 3 points to the ____ button in the Styles group on the Home tab of the Ribbon.

Accepted Answer

A)  Format as Table 
B)  Cell Styles 
C)  Format Painter 
D)  Conditional Formatting 
A)  Format as Table 
B)  Cell Styles 
C)  Format Painter 
D)  Conditional Formatting

Question 13

Susan is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created the worksheet shown below. But she is not familiar with the formatting features of Excel and has asked you for help.   The worksheet title and the labels would look better if they stood out more from the data. a) Write the procedure for changing the font of the worksheet title to Times New Roman and the font size to 16 using the Format Cells dialog box. b) Write the procedure for making the three labels bold using the Ribbon.

Accepted Answer

a) Right-click cell A1, click Format Cel

Question 14

The ____________________ feature automatically corrects some spelling errors as you type.

Accepted Answer

The answer of The ____________________ feature automatically corrects some spelling...

Question 15

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

Accepted Answer

A)  Alignment 
B)  Styles 
C)  Clipboard 
D)  Font 
A)  Alignment 
B)  Styles 
C)  Clipboard 
D)  Font

Question 16

As shown in the figure above, the currently selected font is ____.

Accepted Answer

A)  Regular 
B)  Calibri 
C)  Times New Roman 
D)  font 11 
A)  Regular 
B)  Calibri 
C)  Times New Roman 
D)  font 11

Question 17

You can apply formatting before or after you enter data in a cell or range.

Accepted Answer

A) True 
 B)False

Question 18

As shown in the figure above, item ____ points to the Center button.

Accepted Answer

A)  4 
B)  5 
C)  6 
D)  8 
A)  4 
B)  5 
C)  6 
D)  8

Question 19

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

Accepted Answer

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

Question 20

As shown in the figure above, item ____ points to the button that adds lines or borders.

Accepted Answer

A)  3 
B)  4 
C)  7 
D)  8 
A)  3 
B)  4 
C)  7 
D)  8

Exam 17: Excel 2007 Unit C: Formatting a Worksheet

As shown in the figure above, item ____ points to the button that italicizes text.

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

What is meant by the format of a cell? How do you format a cell or range?

As shown in the figure above, item 2 is the ____ button.

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

As shown in the figure above, item 2 points to the ____ button in the Styles group on the Home tab of the Ribbon.

You can apply attributes and alignment options using the ____ dialog box.

You can change the font and font size of any cell or range using the Mini toolbar.

To add a clip to a worksheet, click Clip Art in the Illustrations group on the Home tab.

You can change the ____ of labels and values in cells to be left, right, or center.

As shown in the figure above, item 3 points to the ____ button in the Styles group on the Home tab of the Ribbon.

The ____________________ feature automatically corrects some spelling errors as you type.

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

As shown in the figure above, the currently selected font is ____.

You can apply formatting before or after you enter data in a cell or range.

As shown in the figure above, item ____ points to the Center button.

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

As shown in the figure above, item ____ points to the button that adds lines or borders.

Word 2007 Unit A: Creating Documents With Word 2007

Word 2007 Unit B: Editing Documents

Word 2007 Unit C: Formatting Text and Paragraphs

Word 2007 Unit D: Formatting Documents

Outlook 2007 Unit A: Getting Started With E-Mail

Outlook 2007 Unit B: Managing Information Using Outlook

Powerpoint 2007 Unit A: Creating a Presentation in Powerpoint 2007

Powerpoint 2007 Unit B: Modifying a Presentation

Powerpoint 2007 Unit C: Inserting Objects Into a Presentation

Powerpoint 2007 Unit D: Finishing a Presentation

Access 2007 Unit A: Getting Started With Access 2007

Access 2007 Unit B: Building and Using Queries

Access 2007 Unit C: Using Forms

Access 2007 Unit D: Using Reports

Excel 2007 Unit A: Getting Started With Excel 2007

Excel 2007 Unit B: Working With Formulas and Functions

Excel 2007 Unit D: Working With Charts

Concepts Unit A: Understanding Essential Computer Concepts

Office 2007 Unit A: Getting Started With Microsoft Office 2007

Windows Vista Unit A: Getting Started With Windows Vista

Windows Vista Unit B: Understanding File Management

Windows Xp Unit A: Getting Started With Windows Xp

Windows Xp Unit B: Understanding File Management

Integration Unit A: Integrating Word and Excel

Integration Unit B: Integrating Word, Excel, and Access

Integration Unit C: Integrating Word, Excel, Access, and Powerpoint

Internet Unit A: Getting Started With Internet Explorer 7

Filters