Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

Because Antoinette is familiar with conditional formatting,she can use the _____,which provides access to the most common tools for data analysis and formatting.

Accepted Answer

A) Quick Tool Bar 
B) Quick Analysis Tool 
C) Quick Formatting Bar 
D) Conditional Analysis Tool 
A) Quick Tool Bar 
B) Quick Analysis Tool 
C) Quick Formatting Bar 
D) Conditional Analysis Tool

Question 6

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 7

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 8

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,light green,green,light blue,blue,dark blue,and...

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

You can open the Format Cells dialog box by right-clicking a cell or selected range,and then clicking _____ on the shortcut menu.

Accepted Answer

A) Format 
B) Cells 
C) Format Cells 
D) Cells Style 
A) Format 
B) Cells 
C) Format Cells 
D) Cells Style

Question 13

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line._________________________

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

As a general rule,you should _____.

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

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?

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

Because Antoinette is familiar with conditional formatting,she can use the _____,which provides access to the most common tools for data analysis and formatting.

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

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

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.

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

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

You can open the Format Cells dialog box by right-clicking a cell or selected range,and then clicking _____ on the shortcut menu.

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line._________________________

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

A _____ indicates a manual page break.

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

As a general rule,you should _____.

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

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?

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

Because Antoinette is familiar with conditional formatting,she can use the _____,which provides access to the most common tools for data analysis and formatting.

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

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

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.

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

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

You can open the Format Cells dialog box by right-clicking a cell or selected range,and then clicking _____ on the shortcut menu.

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line._________________________

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

A _____ indicates a manual page break.

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