Exam 7: Excel Module Formatting Workbook Text and Data

When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

(Multiple Choice)

4.9/5

(33)

Question 61

The Format Cells dialog box has six tabs, including _____.

(Multiple Choice)

4.7/5

(40)

Question 62

Setting the _____ to A1:L10 will print only data in those cells.

(Multiple Choice)

4.8/5

(38)

Question 63

Explain how to use conditional formatting effectively.

(Essay)

4.9/5

(28)

Question 64

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. -In one of Harold's columns there are too many numbers after the decimal place. Harold does not need this level of detail. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way?

(Multiple Choice)

4.7/5

(30)

Question 65

Case 2-1 Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. -Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____.

(Multiple Choice)

4.8/5

(19)

Question 66

A(n) ____________________ is text printed in the top margin of each page.

(Short Answer)

4.8/5

(26)

Question 67

A footer appears at the top of each printed page.

(True/False)

4.9/5

(26)

Question 68

_____ merges each of the rows in the selected range across the columns in the range.

(Multiple Choice)

4.8/5

(32)

Question 69

In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.

(Multiple Choice)

4.7/5

(37)

Question 70

Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.

(Multiple Choice)

4.9/5

(34)

Question 71

If you want to print only part of a worksheet, you can set a print area , which is the region of the worksheet that is sent to the printer.

(True/False)

4.8/5

(33)

Question 72

The cell reference for the merged cell is the upper-right cell reference.

(True/False)

4.9/5

(27)

Question 73

By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin.

(True/False)

4.9/5

(31)

Question 74

One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.

(Short Answer)

5.0/5

(29)

Question 75

Showing 61 - 75 of 75

When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

The Format Cells dialog box has six tabs, including _____.

Setting the _____ to A1:L10 will print only data in those cells.

Explain how to use conditional formatting effectively.

A(n) ____________________ is text printed in the top margin of each page.

A footer appears at the top of each printed page.

_____ merges each of the rows in the selected range across the columns in the range.

In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.

Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.

If you want to print only part of a worksheet, you can set a print area , which is the region of the worksheet that is sent to the printer.

The cell reference for the merged cell is the upper-right cell reference.

By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin.

One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.

Word Module Access Module Creating a Database

Access Module : Building a Database and Defining Table Relationships

Access Module Maintaining and Querying a Database

Word Module Creating and Editing a Document

Word Module 2: Navigating and Formatting a Document

Excel Module Getting Started With Excel

Excel Module Performing Calculations With Formulas and Functions

Powerpoint Module Creating a Presentation

Managing Your Files

Communicating With Microsoft Outlook Angel

Productivity Apps for School and Work

Filters