Question 1

A  theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.

Accepted Answer

A) True 
 B)False  False

Question 2

To set a page break in Excel, select the _____.

Accepted Answer

A)  first cell below the row where you want to insert a page break 
B)  first cell above the row where you want to insert a page break 
C)  row above where you want to insert a page break 
D)  row below where you want to insert a page break 
A)  first cell below the row where you want to insert a page break 
B)  first cell above the row where you want to insert a page break 
C)  row above where you want to insert a page break 
D)  row below where you want to insert a page break A

Question 3

The background image does not affect any cell's format or content.

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A)  margin 
B)  border 
C)  frame 
D)  ruler 
A)  margin 
B)  border 
C)  frame 
D)  ruler

Question 5

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

Accepted Answer

The answer of One of the benefits of conditional ____________________...

Question 6

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.

Accepted Answer

A)  Four, two, six 
B)  Two, four, six 
C)  Four, six, two 
D)  Six, four, two 
A)  Four, two, six 
B)  Two, four, six 
C)  Four, six, two 
D)  Six, four, two

Question 7

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 8

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.

Accepted Answer

A)  fill color 
B)  tab setting 
C)  format color 
D)  formatting style 
A)  fill color 
B)  tab setting 
C)  format color 
D)  formatting style

Question 9

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

Question 10

Text and numbers are displayed vertically within cells.

Accepted Answer

A) True 
 B)False

Question 11

By default, Excel displays text in a  black font color.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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.

Accepted Answer

A)  1, 2, 4, 3, 5 
B)  1, 2, 4, 5, 3 
C)  1, 5, 2, 4, 3 
D)  1, 5, 2, 3, 4 
A)  1, 2, 4, 3, 5 
B)  1, 2, 4, 5, 3 
C)  1, 5, 2, 4, 3 
D)  1, 5, 2, 3, 4

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

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 16

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

Accepted Answer

The answer of When you specify a print area for...

Question 17

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

Accepted Answer

The answer of Use the ____________________ button in the Alignment...

Question 18

As a general rule, you should _____.

Accepted Answer

A)  center column titles, left-align text, and right-align numbers 
B)  center column titles, right-align text, and left-align numbers 
C)  right-align column titles, left-align text, and right-align numbers 
D)  left-align column titles, left-align text, and right-align numbers 
A)  center column titles, left-align text, and right-align numbers 
B)  center column titles, right-align text, and left-align numbers 
C)  right-align column titles, left-align text, and right-align numbers 
D)  left-align column titles, left-align text, and right-align numbers

Question 19

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value.

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

Accepted Answer

The answer of The ____________________ copies the formatting from one...

A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.

To set a page break in Excel, select the _____.

The background image does not affect any cell's format or content.

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

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

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.

A _____ indicates a manual page break.

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.

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

Text and numbers are displayed vertically within cells.

By default, Excel displays text in a black font color.

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

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

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

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

As a general rule, you should _____.

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value.

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

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

Exam 7: Excel Module Formatting Workbook Text and Data

A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.

To set a page break in Excel, select the _____.

The background image does not affect any cell's format or content.

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

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

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.

A _____ indicates a manual page break.

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.

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

Text and numbers are displayed vertically within cells.

By default, Excel displays text in a black font color.

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

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

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

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

As a general rule, you should _____.

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value.

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

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

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.