Deck 23: Importing and Exporting Data

Question 1

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

Answer 1

False

Question 2

If the worksheet or workbook is saved in PDF format, it can be e-mailed or uploaded to a Web site.

Answer 2

True

Question 3

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

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

Answer 3

D

Question 4

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

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

Question 5

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

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

Question 6

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

Question 7

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

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

Question 8

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

Question 9

A file that is downloaded from SkyDrive cannot be edited.

Question 10

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

Question 11

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 .

Question 12

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.

Question 13

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

Question 14

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

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

Question 15

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

Question 16

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

Question 17

The XPS format can be read on all platforms.

Question 18

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

Question 19

Excel offers the ability to import and export data.

Question 20

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

Question 21

The ____________________ Wizard walks you through the steps to import text data into an Excel workbook.

Question 22

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

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

Question 23

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

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

Question 24

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

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

Question 25

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

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

Question 26

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

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

Question 27

The Save & Send options are found under the ____ tab.

A) Page Layout
B) View
C) Review
D) File

Question 28

To access SkyDrive, you must have a ____ account.

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

Question 29

All of the fonts, formats, and images used in Excel are preserved in the ____ format.

A) DOC
B) HTML
C) ACCDB
D) PDF

Question 30

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

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

Question 31

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

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

Question 32

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

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

Question 33

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.

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

Question 34

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. When Anna is bring the text data into Excel, selecting ____ in Step 3 of the Text Import Wizard will convert the number values to a number format, date values to dates, and the remaining text data will be brought in as text.

A) Text
B) Date
C) General
D) Tab

Question 35

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.

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

Question 36

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

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

Question 37

PDF stands for ____ document format.

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

Question 38

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

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

Question 39

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

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

Question 40

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.

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

Question 42

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.

Question 43

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

Question 44

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

Question 45

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

Question 46

The ____________________ first offers a checklist of items it will inspect, and then offers you the ability to delete those items from the workbook.