Exam 8: Excel Lesson 2: Changing the Appearance of a Worksheet

Explore all topics

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?

(Multiple Choice)

4.9/5

(80)

Question 21

Excel ____ all numbers.

(Multiple Choice)

4.7/5

(85)

Question 22

Text that is too long to fit within a cell is displayed in the next cell, if it is empty.

(True/False)

4.8/5

(70)

Question 23

A format is the design of text.

(True/False)

4.9/5

(91)

Question 24

If the next cell already contains data, any text that does not fit in the cell is ____________________, or hidden from view.

(Short Answer)

4.8/5

(66)

Question 25

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

(Multiple Choice)

4.9/5

(70)

Question 26

Identify the letter of the choice that best matches the phrase or definition.

Features such as bold, italic, and underlining that add emphasis to a font.

Cell style

A collection of formatting characteristics you apply to a cell or range of data.

Font

The design of text.

Font size

Correct Answer:

Verified

Features such as bold, italic, and underlining that add emphasis to a font.

A collection of formatting characteristics you apply to a cell or range of data.

The design of text.

Combination of formatting characteristics such as alignment, font color, and borders.

Determines the height of characters as measured in points.

(Matching)

4.9/5

(87)

Question 27

To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the____ keys.

(Multiple Choice)

4.8/5

(92)

Question 28

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column headings.

(Multiple Choice)

4.8/5

(84)

Question 29

Case EX 2-1 Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below. Once the Find and Replace dialog box appears, with the Replace tab displayed, what button should Tessa click to expand the dialog box so that she can enter in the formatting styles she wants to find and replace?

(Multiple Choice)

4.8/5

(81)

Question 30

The Cell Styles library includes many predefined styles.

(True/False)

4.9/5

(79)

Question 31

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.

(True/False)

4.8/5

(80)

Question 32

Data can be indented (or ____ ) within cells to help distinguish categories or set data apart.

(Multiple Choice)

4.8/5

(81)

Question 33

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.

(Multiple Choice)

4.7/5

(65)

Question 34

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?

(Multiple Choice)

4.9/5

(83)

Question 35

The ____________________ format displays numbers with a dollar sign, a thousands separator, and two decimal places.

(Short Answer)

4.9/5

(87)

Question 36

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

(Multiple Choice)

5.0/5

(69)

Question 37

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

(True/False)

4.8/5

(89)

Question 38

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.

(Multiple Choice)

4.9/5

(90)

Question 39

You can use the Format Painter to copy formatting only to adjacent cells or ranges.

(True/False)

4.8/5

(82)

Question 40

Showing 21 - 40 of 46

Exam 8: Excel Lesson 2: Changing the Appearance of a Worksheet

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?

Excel ____ all numbers.

Text that is too long to fit within a cell is displayed in the next cell, if it is empty.

A format is the design of text.

If the next cell already contains data, any text that does not fit in the cell is ____________________, or hidden from view.

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

To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the____ keys.

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column headings.

The Cell Styles library includes many predefined styles.

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.

Data can be indented (or ____ ) within cells to help distinguish categories or set data apart.

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.

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?

The ____________________ format displays numbers with a dollar sign, a thousands separator, and two decimal places.

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

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

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.

You can use the Format Painter to copy formatting only to adjacent cells or ranges.

Access Lesson 1: Microsoft Access Basics

Access Lesson 2: Creating a Database

Access Lesson 3: Creating Queries

Access Lesson 4: Creating and Modifying Forms

Access Lesson 5: Creating and Modifying Reports

Access Lesson 6: Integrating Access

Excel Lesson 1: Microsoft Excel Basics

Excel Lesson 3: Organizing the Worksheet

Excel Lesson 4: Entering Worksheet Formulas

Excel Lesson 5: Using Functions

Excel Lesson 6: Enhancing a Worksheet

Excel Lesson 7: Working With Multiple Worksheets and Workbooks

Excel Lesson 8: Working With Charts

Microsoft Office 2010 Basics and the Internet

Outlook Lesson 1: Outlook Basics and E-Mail

Outlook Lesson 2: Calendar

Outlook Lesson 3: Working With Other Outlook Tools

Powerpoint Lesson 1: Microsoft Powerpoint Basics

Powerpoint Lesson 2: Creating Enhancing Powerpoint Presentations

Powerpoint Lesson 3: Working With Visual Elements

Powerpoint Lesson 4: Expanding on Powerpoint Basics

Publisher Lesson 1: Microsoft Publisher Basics

Publisher Lesson 2: Enhancing Publisher Documents

Introduction Lesson 1: Microsoft Windows 7 Basics

Word Lesson 1: Microsoft Word Basics

Word Lesson 2: Basic Editing

Word Lesson 3: Helpful Word Features

Word Lesson 4: Formatting Text

Word Lesson 5: Formatting Paragraphs and Documents

Word Lesson 6: Working With Graphics

Word Lesson 7: Working With Documents

Word Lesson 8: Increasing Efficiency Using Word

Filters