Question 1

____ is used to store large amounts of data and provides for easy viewing and printing of data.

Accepted Answer

A)  Access 
B)  Notepad 
C)  Explorer 
D)  Document Inspector 
A)  Access 
B)  Notepad 
C)  Explorer 
D)  Document Inspector A

Question 2

When the file is downloaded from SkyDrive, it opens in Secure View.

Accepted Answer

A) True 
 B)False  False

Question 3

If you need to share your files so that other individuals can view them, you might want to consider placing the files on the Web .

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

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

Question 5

When importing text data, you need to identify the type of data in the imported file as delimited or ____.

Accepted Answer

A)  spiral 
B)  nested 
C)  serif 
D)  fixed width 
A)  spiral 
B)  nested 
C)  serif 
D)  fixed width

Question 6

The ____ tab offers the option to save an Excel workbook as a PDF or as an XPS.

Accepted Answer

A)  File 
B)  Data 
C)  Review 
D)  View 
A)  File 
B)  Data 
C)  Review 
D)  View

Question 7

____ inform users that the file format is final and cannot be changed.

Accepted Answer

A)  File properties 
B)  Check lines 
C)  Edit seals 
D)  Signature lines 
A)  File properties 
B)  Check lines 
C)  Edit seals 
D)  Signature lines

Question 8

When a workbook is saved as a PDF, you need to have Excel installed to open it.

Accepted Answer

A) True 
 B)False

Question 9

The Signature Line button is found in the Text group on the ____________________ tab.

Accepted Answer

The answer of The Signature Line button is found in...

Question 10

Case EX 17-1 Anna just took over a computer repair business. The previous owner had used an Access database and some text files to store client and work data. Anna wants to use Excel to store this data in the future. If Anna wants an easy way to bring the Access data into Excel, she needs to ____ the data into Excel.

Accepted Answer

A)  chart 
B)  throw 
C)  cycle 
D)  import 
A)  chart 
B)  throw 
C)  cycle 
D)  import

Question 11

A file that is downloaded from SkyDrive cannot be edited.

Accepted Answer

A) True 
 B)False

Question 12

Before you export a workbook, you may want to use the ____ to locate possible hidden and personal information.

Accepted Answer

A)  Property Inspector 
B)  Export Checker 
C)  Document Inspector 
D)  Download Checker 
A)  Property Inspector 
B)  Export Checker 
C)  Document Inspector 
D)  Download Checker

Question 13

After you export or upload a file to your SkyDrive account, the file can then be shared and accessed.

Accepted Answer

A) True 
 B)False

Question 14

____ allows you to access and share files online with friends, family members, or co-workers.

Accepted Answer

A)  Document Inspector 
B)  Signature line 
C)  Exporter 
D)  SkyDrive 
A)  Document Inspector 
B)  Signature line 
C)  Exporter 
D)  SkyDrive

Question 15

Figure EX 17-1   Item 1 in Figure EX 17-1 above points to the ____.

Accepted Answer

A)  document properties 
B)  signature line 
C)  footer line 
D)  sign checker 
A)  document properties 
B)  signature line 
C)  footer line 
D)  sign checker

Question 16

Before you export data, you may want to save the file as a(n) ____.

Accepted Answer

A)  FLD 
B)  TEF 
C)  PDF 
D)  SXT 
A)  FLD 
B)  TEF 
C)  PDF 
D)  SXT

Question 17

Text formats that can be imported into Excel include .txt, ____, or .prn.

Accepted Answer

A)  .pdf 
B)  .csv 
C)  .accdb 
D)  .html 
A)  .pdf 
B)  .csv 
C)  .accdb 
D)  .html

Question 18

To access SkyDrive, you must have a ____ account.

Accepted Answer

A)  Google 
B)  Windows Live 
C)  LiveJournal 
D)  Facebook 
A)  Google 
B)  Windows Live 
C)  LiveJournal 
D)  Facebook

Question 19

Figure EX 17-1   Clicking Item 2 in the Figure EX 17-1 above will ____.

Accepted Answer

A)  add the password 
B)  remove the password 
C)  add the signature line 
D)  remove the signature line 
A)  add the password 
B)  remove the password 
C)  add the signature line 
D)  remove the signature line

Question 20

If you try to save a workbook with a signature line with a different name, the signature line will show the words ____________________ above the signature line.

Accepted Answer

The answer of If you try to save a workbook...

Exam 23: Importing and Exporting Data

____ is used to store large amounts of data and provides for easy viewing and printing of data.

When the file is downloaded from SkyDrive, it opens in Secure View.

If you need to share your files so that other individuals can view them, you might want to consider placing the files on the Web .

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

When importing text data, you need to identify the type of data in the imported file as delimited or ____.

The ____ tab offers the option to save an Excel workbook as a PDF or as an XPS.

____ inform users that the file format is final and cannot be changed.

When a workbook is saved as a PDF, you need to have Excel installed to open it.

The Signature Line button is found in the Text group on the ____________________ tab.

A file that is downloaded from SkyDrive cannot be edited.

Before you export a workbook, you may want to use the ____ to locate possible hidden and personal information.

After you export or upload a file to your SkyDrive account, the file can then be shared and accessed.

____ allows you to access and share files online with friends, family members, or co-workers.

Figure EX 17-1 Item 1 in Figure EX 17-1 above points to the ____.

Before you export data, you may want to save the file as a(n) ____.

Text formats that can be imported into Excel include .txt, ____, or .prn.

To access SkyDrive, you must have a ____ account.

Figure EX 17-1 Clicking Item 2 in the Figure EX 17-1 above will ____.

If you try to save a workbook with a signature line with a different name, the signature line will show the words ____________________ above the signature line.

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