Question 1

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

Accepted Answer

The answer of To remove conditional formatting in Excel,click ____________________...

Question 2

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 3

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 4

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 5

Formatting changes only the appearance of data-it does not affect the data itself._________________________

Accepted Answer

A) True 
 B)False

Question 6

A footer appears at the top of each printed page._________________________

Accepted Answer

A) True 
 B)False

Question 7

Calculated values too large to fit into the cell are displayed in scientific notation._________________________

Accepted Answer

A) True 
 B)False

Question 8

Antoinette's workbook has all the data entered and students' current grades displayed.She would like the current grade cells to display the value in red if it is less than 60.Antoinette needs to add _____ to the cell.

Accepted Answer

A) cell formatting 
B) conditional formatting 
C) highlighting 
D) fill color 
A) cell formatting 
B) conditional formatting 
C) highlighting 
D) fill color

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

A conditional format applies formatting to a cell when its value meets a specified condition._________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Explain how to use conditional formatting effectively.

Accepted Answer

​
•Document the conditional formats you

Question 15

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

Accepted Answer

A) use Format Painter 
B) format each element using the Toolbar 
C) select all cells and use the Formatting dialog box 
D) apply a table style 
A) use Format Painter 
B) format each element using the Toolbar 
C) select all cells and use the Formatting dialog box 
D) apply a table style

Question 16

Excel organizes fonts into theme and non-theme fonts._________________________

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

Accepted Answer

A) Equal to 
B) Between 
C) Duplicate Values 
D) A Date Occurring 
A) Equal to 
B) Between 
C) Duplicate Values 
D) A Date Occurring

Question 20

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

Accepted Answer

The answer of One way to align text over several...

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

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

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

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.

Formatting changes only the appearance of data-it does not affect the data itself._________________________

A footer appears at the top of each printed page._________________________

Calculated values too large to fit into the cell are displayed in scientific notation._________________________

Antoinette's workbook has all the data entered and students' current grades displayed.She would like the current grade cells to display the value in red if it is less than 60.Antoinette needs to add _____ to the cell.

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

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

A conditional format applies formatting to a cell when its value meets a specified condition._________________________

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

Explain how to use conditional formatting effectively.

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

Excel organizes fonts into theme and non-theme fonts._________________________

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

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

Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

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 8: Formatting Workbook Text and Data

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

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

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

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.

Formatting changes only the appearance of data-it does not affect the data itself._________________________

A footer appears at the top of each printed page._________________________

Calculated values too large to fit into the cell are displayed in scientific notation._________________________

Antoinette's workbook has all the data entered and students' current grades displayed.She would like the current grade cells to display the value in red if it is less than 60.Antoinette needs to add _____ to the cell.

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

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

A conditional format applies formatting to a cell when its value meets a specified condition._________________________

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

Explain how to use conditional formatting effectively.

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

Excel organizes fonts into theme and non-theme fonts._________________________

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

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

Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

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

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.