Question 1

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.

Accepted Answer

A) True 
 B)False

Question 2

A conditional format can make negative numbers red and positive numbers black.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  Number 
B)  Font 
C)  Alignment 
D)  Fill 
A)  Number 
B)  Font 
C)  Alignment 
D)  Fill

Question 4

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

Accepted Answer

A)  Merge build 
B)  Merge and Center 
C)  Merge Across 
D)  Merge Cells 
A)  Merge build 
B)  Merge and Center 
C)  Merge Across 
D)  Merge Cells

Question 5

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook.

Accepted Answer

A) True 
 B)False

Question 6

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.

Accepted Answer

The answer of Ten ____________________ colors-dark red, red, orange, yellow,...

Question 7

-In the accompanying figure, the _____ indicates the font is 11pt.

Accepted Answer

A)  Font arrow 
B)  Font size box 
C)  Font color 
D)  Font graphic 
A)  Font arrow 
B)  Font size box 
C)  Font color 
D)  Font graphic

Question 8

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

Accepted Answer

A)  Format 
B)  Orientation 
C)  Sorter 
D)  Alignment 
A)  Format 
B)  Orientation 
C)  Sorter 
D)  Alignment

Question 9

When you don't want to associate a font with a particular design, you use a _____ font.

Accepted Answer

A)  theme 
B)  serif 
C)  sans serif 
D)  non-theme 
A)  theme 
B)  serif 
C)  sans serif 
D)  non-theme

Question 10

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 11

MATCHING
Match each of the following icons with the description that most closely matches its function.
-Aligns the cell content with the cell's top edge

Accepted Answer

A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)  
A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)

Question 12

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

Question 13

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

Accepted Answer

A)  A1!E1! 
B)  A1 
C)  E1 
D)  A1-E1 
A)  A1!E1! 
B)  A1 
C)  E1 
D)  A1-E1

Question 14

MATCHING
Match each of the following icons with the description that most closely matches its function.
-Horizontally centers the cell content within the cell

Accepted Answer

A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)  
A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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?

Accepted Answer

A)  reenter all numbers and only enter two decimal places 
B)  decrease the column width 
C)  decrease the font size 
D)  use the Number group to decrease number of digits displayed 
A)  reenter all numbers and only enter two decimal places 
B)  decrease the column width 
C)  decrease the font size 
D)  use the Number group to decrease number of digits displayed

Question 18

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 19

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

Accepted Answer

A)  Alignment 
B)  Font 
C)  Protection 
D)  Security 
A)  Alignment 
B)  Font 
C)  Protection 
D)  Security

Question 20

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 ____________________...

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.

A conditional format can make negative numbers red and positive numbers black.

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

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

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook.

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.

-In the accompanying figure, the _____ indicates the font is 11pt.

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

When you don't want to associate a font with a particular design, you use a _____ font.

MATCHING Match each of the following icons with the description that most closely matches its function. -Aligns the cell content with the cell's top edge

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

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

MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell

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

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

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

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 7: Formatting Workbook Text and Data

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.

A conditional format can make negative numbers red and positive numbers black.

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

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

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook.

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.

-In the accompanying figure, the _____ indicates the font is 11pt.

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

When you don't want to associate a font with a particular design, you use a _____ font.

MATCHING Match each of the following icons with the description that most closely matches its function. -Aligns the cell content with the cell's top edge

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

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

MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell

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

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

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

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters