Question 1

If you are concerned about protecting a workbook from being viewed by unauthorized individuals, you can add password protection to the workbook in Excel.

Accepted Answer

A) True 
 B)False

Question 2

PDF stands for ____ document format.

Accepted Answer

A)  printed 
B)  portable 
C)  personal 
D)  private 
A)  printed 
B)  portable 
C)  personal 
D)  private

Question 3

Case EX 17-2 Adam works at a textile company. The company stores information about its products in an Excel workbook. Adam needs to find an easy way to share some of the information with clients. Before sharing the worksheet data with anyone else, Adam should use the ____ to find out if the workbook has any hidden or personal data, and to delete that data.

Accepted Answer

A)  HTML Checker 
B)  Properties Inspector 
C)  Spell Checker 
D)  Document Inspector 
A)  HTML Checker 
B)  Properties Inspector 
C)  Spell Checker 
D)  Document Inspector

Question 4

____ refers to bringing data from other programs into an Excel workbook.

Accepted Answer

A)  Exporting 
B)  Extracting 
C)  Validating 
D)  Importing 
A)  Exporting 
B)  Extracting 
C)  Validating 
D)  Importing

Question 5

In Excel, you can hide comments and columns or rows of data.

Accepted Answer

A) True 
 B)False

Question 6

____ retains the exact look of the Excel document and protects it from being changed.

Accepted Answer

A)  TXT 
B)  XPS 
C)  HTML 
D)  CSS 
A)  TXT 
B)  XPS 
C)  HTML 
D)  CSS

Question 7

Match between columns
                        Premises: A program offered by Microsoft which offers 25 GB of online Web storage for free.
Data that is separated at the same place in each cell, such as after 15 characters.
A security feature that you add to a workbook file so that someone else can sign, or verify, the information.
A database program included in some versions of Microsoft Office.
Data that is separated by a tab, semicolon, comma, or space.

Accepted Answer

The Answer of Access and delimited and fixed width and is...

Question 8

The Show/Hide Comment button is found on the Data tab.

Accepted Answer

A) True 
 B)False

Question 9

____ refers to taking Excel data from a workbook and sending it to another program or to the Web.

Accepted Answer

A)  Exporting 
B)  Extracting 
C)  Validating 
D)  Importing 
A)  Exporting 
B)  Extracting 
C)  Validating 
D)  Importing

Question 10

Hidden data does not occur in workbooks that are shared among several people.

Accepted Answer

A) True 
 B)False

Question 11

In the Document Inspector dialog box, you can add and remove check marks in order to define what you would like to search for with the Document Inspector.

Accepted Answer

A) True 
 B)False

Question 12

The XPS format is accessible to more people than the PDF format.

Accepted Answer

A) True 
 B)False

Question 13

Excel offers the ability to import and export data.

Accepted Answer

A) True 
 B)False

Question 14

Explain what the signature line is and why it is useful.

Accepted Answer

A signature line is a security feature t

Question 15

The TXT format was developed by Microsoft and is similar to PDF.

Accepted Answer

A) True 
 B)False

Question 16

To share a workbook with others on the Web, you can ____ the file to the Web.

Accepted Answer

A)  import 
B)  export 
C)  extract 
D)  divide 
A)  import 
B)  export 
C)  extract 
D)  divide

Question 17

To import text data, click the ____ tab, and then click the From Text button.

Accepted Answer

A)  Data 
B)  Home 
C)  View 
D)  Insert 
A)  Data 
B)  Home 
C)  View 
D)  Insert

Question 18

Case EX 17-2 Adam works at a textile company. The company stores information about its products in an Excel workbook. Adam needs to find an easy way to share some of the information with clients. Adam can save the information from the worksheet as a(n) ____, which can be easily viewed by anyone who has Adobe Acrobat or Adobe Reader.

Accepted Answer

A)  TXT 
B)  PDF 
C)  HTML 
D)  CSS 
A)  TXT 
B)  PDF 
C)  HTML 
D)  CSS

Question 19

The Check for Issues button is found on the ____________________ tab.

Accepted Answer

The answer of The Check for Issues button is found...

Question 20

The XPS format can be read on all platforms.

Accepted Answer

A) True 
 B)False

Exam 23: Importing and Exporting Data

If you are concerned about protecting a workbook from being viewed by unauthorized individuals, you can add password protection to the workbook in Excel.

PDF stands for ____ document format.

____ refers to bringing data from other programs into an Excel workbook.

In Excel, you can hide comments and columns or rows of data.

____ retains the exact look of the Excel document and protects it from being changed.

The Show/Hide Comment button is found on the Data tab.

____ refers to taking Excel data from a workbook and sending it to another program or to the Web.

Hidden data does not occur in workbooks that are shared among several people.

In the Document Inspector dialog box, you can add and remove check marks in order to define what you would like to search for with the Document Inspector.

The XPS format is accessible to more people than the PDF format.

Excel offers the ability to import and export data.

Explain what the signature line is and why it is useful.

The TXT format was developed by Microsoft and is similar to PDF.

To share a workbook with others on the Web, you can ____ the file to the Web.

To import text data, click the ____ tab, and then click the From Text button.

The Check for Issues button is found on the ____________________ tab.

The XPS format can be read on all platforms.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters