Exam 23: Importing and Exporting Data

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.

(Multiple Choice)

4.9/5

(31)

Question 41

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

(True/False)

4.8/5

(33)

Question 42

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

(Short Answer)

4.8/5

(33)

Question 43

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

(Multiple Choice)

5.0/5

(32)

Question 44

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

(Short Answer)

4.8/5

(36)

Question 45

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

(Multiple Choice)

4.9/5

(41)

Question 46

Showing 41 - 46 of 46

Exam 23: Importing and Exporting Data

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

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

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

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

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

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