Exam 2: Formatting Workbook Text and Data

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 would like to center a title across the top of his data.His data runs across five columns,from column A to column E.One way he could accomplish this is to _____.

(Multiple Choice)

4.9/5

(30)

Question 41

-In the accompanying figure,an example of a theme font is _____.

(Multiple Choice)

4.8/5

(46)

Question 42

To remove conditional formatting in Excel,click ____________________ after clicking the Conditional Formatting button.

(Short Answer)

4.9/5

(29)

Question 43

A _____ is the space between the page content and the edges of the page.

(Multiple Choice)

4.7/5

(29)

Question 44

In a workbook's theme,___ colors are designated for text and background,_ colors are used for accents and highlights,and ___ colors are used for hyperlinks.

(Multiple Choice)

4.9/5

(24)

Question 45

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

(Multiple Choice)

4.7/5

(39)

Question 46

By default,numbers appear in the _____ and generally display values exactly as you type them.

(Multiple Choice)

4.9/5

(38)

Question 47

In the Format Cells dialog box,the _____ tab allows you to format currency by choosing decimal places,comma separators,and regular number displays.

(Multiple Choice)

4.9/5

(39)

Question 48

Put the following five steps in the order in which you would perform them to use the Paste Special function. 1)Select and copy a range. 2)Click the Paste button arrow in the Clipboard group on the HOME Tab. 3)Specify exactly what you want to paste. 4)Click Paste Special to open the dialog box. 5)Select the range where you want to paste the Clipboard contents.

(Multiple Choice)

4.8/5

(34)

Question 49

The region that is sent to the printer from the active sheet is known as the ____________________.

(Short Answer)

4.8/5

(34)

Question 50

The $\underline { \text { background image } }$ does not affect any cell's format or content._________________________

(True/False)

4.9/5

(34)

Question 51

When you specify a print area for a nonadjacent range,you are also inserting a(n)____________________ page break.

(Short Answer)

4.8/5

(34)

Question 52

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

(Short Answer)

4.9/5

(27)

Question 53

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 cannot increase the width of his worksheet because,if he does,he will not be able to print it on one sheet.However,his columns are truncating his content.What solution would be the best for Harold to use to make all his text visible without losing data?

(Multiple Choice)

4.8/5

(35)

Question 54

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 has chosen green as the background color for his workbook.He should not use _____ for any of the font or highlight colors.

(Multiple Choice)

4.8/5

(38)

Question 55

-In the accompanying figure,the number 3 displays _____.

(Multiple Choice)

4.8/5

(37)

Question 56

The code _____ will display the filename of the current workbook.

(Multiple Choice)

4.8/5

(31)

Question 57

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

(Multiple Choice)

4.7/5

(29)

Question 58

Ten ____________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and purple-are always available regardless of the workbook's theme.

(Short Answer)

4.8/5

(36)

Question 59

When creating an Excel document,you should avoid using _____ text and background together,since this is the most common form of color blindness.

(Multiple Choice)

4.9/5

(25)

Question 60

Showing 41 - 60 of 100

-In the accompanying figure,an example of a theme font is _____.

To remove conditional formatting in Excel,click ____________________ after clicking the Conditional Formatting button.

A _____ is the space between the page content and the edges of the page.

In a workbook's theme,___ colors are designated for text and background,_ colors are used for accents and highlights,and ___ colors are used for hyperlinks.

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

By default,numbers appear in the _____ and generally display values exactly as you type them.

In the Format Cells dialog box,the _____ tab allows you to format currency by choosing decimal places,comma separators,and regular number displays.

The region that is sent to the printer from the active sheet is known as the ____________________.

The $\underline { \text { background image } }$ does not affect any cell's format or content._________________________

When you specify a print area for a nonadjacent range,you are also inserting a(n)____________________ page break.

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

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 has chosen green as the background color for his workbook.He should not use _____ for any of the font or highlight colors.

-In the accompanying figure,the number 3 displays _____.

The code _____ will display the filename of the current workbook.

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

Ten ____________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and purple-are always available regardless of the workbook's theme.

When creating an Excel document,you should avoid using _____ text and background together,since this is the most common form of color blindness.

Getting Started With Excel

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 2: Formatting Workbook Text and Data

-In the accompanying figure,an example of a theme font is _____.

To remove conditional formatting in Excel,click ____________________ after clicking the Conditional Formatting button.

A _____ is the space between the page content and the edges of the page.

In a workbook's theme,_____ colors are designated for text and background,_____ colors are used for accents and highlights,and _____ colors are used for hyperlinks.

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

By default,numbers appear in the _____ and generally display values exactly as you type them.

In the Format Cells dialog box,the _____ tab allows you to format currency by choosing decimal places,comma separators,and regular number displays.

The region that is sent to the printer from the active sheet is known as the ____________________.

The background image ‾\underline { \text { background image } } background image ​ does not affect any cell's format or content._________________________

When you specify a print area for a nonadjacent range,you are also inserting a(n)____________________ page break.

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

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 has chosen green as the background color for his workbook.He should not use _____ for any of the font or highlight colors.

-In the accompanying figure,the number 3 displays _____.

The code _____ will display the filename of the current workbook.

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

Ten ____________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and purple-are always available regardless of the workbook's theme.

When creating an Excel document,you should avoid using _____ text and background together,since this is the most common form of color blindness.

Getting Started With Excel

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

In a workbook's theme,___ colors are designated for text and background,_ colors are used for accents and highlights,and ___ colors are used for hyperlinks.

The $\underline { \text { background image } }$ does not affect any cell's format or content._________________________