Question 1

Information that prints on each page,like a company name or logo,may be set as a _____.

Accepted Answer

A)  print setup 
B)  copied text 
C)  text header 
D)  print title 
A)  print setup 
B)  copied text 
C)  text header 
D)  print title

Question 2

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

Accepted Answer

The answer of The region that is sent to the...

Question 3

Italic,bold,bold italic,and underline are examples of _____.

Accepted Answer

A)  font themes 
B)  font styles 
C)  graphics 
D)  character settings 
A)  font themes 
B)  font styles 
C)  graphics 
D)  character settings

Question 4

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

Accepted Answer

The answer of The ____________________ tab in the Format Cells...

Question 5

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 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?

Accepted Answer

A)  abbreviate all text 
B)  change the font style 
C)  choose Wrap text for the columns 
D)  delete one column 
A)  abbreviate all text 
B)  change the font style 
C)  choose Wrap text for the columns 
D)  delete one column

Question 6

A _____ indicates a manual page break.

Accepted Answer

A)  dashed blue line 
B)  solid blue line 
C)  dashed red line 
D)  solid red line 
A)  dashed blue line 
B)  solid blue line 
C)  dashed red line 
D)  solid red line

Question 7

Fonts,colors,and cell styles are organized in _____ categories.

Accepted Answer

A)  theme and non-theme 
B)  numbers and text 
C)  color and black and white 
D)  form and function 
A)  theme and non-theme 
B)  numbers and text 
C)  color and black and white 
D)  form and function

Question 8

Header and footer elements such as worksheet name,current date,and time are _____ elements.

Accepted Answer

A)  descriptive 
B)  dynamic 
C)  impact 
D)  required 
A)  descriptive 
B)  dynamic 
C)  impact 
D)  required

Question 9

Explain how to use conditional formatting effectively.

Accepted Answer

​•Document the conditional formats you

Question 10

The Format Painter does not copy formatting applied to selected text within a cell,and it does not copy data._________________________

Accepted Answer

A) True 
 B)False

Question 11

Each header and footer has three sections-a left section,a center section,and a right section._________________________

Accepted Answer

A) True 
 B)False

Question 12

Text and numbers are displayed vertically within cells._________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  Page Format 
B)  Print Area 
C)  Page Break 
D)  Print Preview 
A)  Page Format 
B)  Print Area 
C)  Page Break 
D)  Print Preview

Question 14

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

Accepted Answer

A)  red and green 
B)  yellow and blue 
C)  black and white 
D)  red and yellow 
A)  red and green 
B)  yellow and blue 
C)  black and white 
D)  red and yellow

Question 15

Changing the number of decimal places displayed in a cell does not change the value stored in the cell._________________________

Accepted Answer

A) True 
 B)False

Information that prints on each page,like a company name or logo,may be set as a _____.

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

Italic,bold,bold italic,and underline are examples of _____.

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

A _____ indicates a manual page break.

Fonts,colors,and cell styles are organized in _____ categories.

Header and footer elements such as worksheet name,current date,and time are _____ elements.

Explain how to use conditional formatting effectively.

The Format Painter does not copy formatting applied to selected text within a cell,and it does not copy data._________________________

Each header and footer has three sections-a left section,a center section,and a right section._________________________

Text and numbers are displayed vertically within cells._________________________

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

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

Changing the number of decimal places displayed in a cell does not change the value stored in the cell._________________________

Getting Started With Excel

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters

Exam 2: Formatting Workbook Text and Data

Information that prints on each page,like a company name or logo,may be set as a _____.

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

Italic,bold,bold italic,and underline are examples of _____.

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

A _____ indicates a manual page break.

Fonts,colors,and cell styles are organized in _____ categories.

Header and footer elements such as worksheet name,current date,and time are _____ elements.

Explain how to use conditional formatting effectively.

The Format Painter does not copy formatting applied to selected text within a cell,and it does not copy data._________________________

Each header and footer has three sections-a left section,a center section,and a right section._________________________

Text and numbers are displayed vertically within cells._________________________

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

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

Changing the number of decimal places displayed in a cell does not change the value stored in the cell._________________________

Getting Started With Excel

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters