Exam 18: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.

(Multiple Choice)

4.8/5

(41)

Question 41

The Import Data dialog box includes options to specify which parts of a webpage to import and how much of the HTML formatting to keep.

(True/False)

4.8/5

(39)

Question 42

It is not possible to replicate formulas after sampleting an import, so be sure to samplete the replication before the import.

(True/False)

4.8/5

(30)

Question 43

____ a shape within a SmartArt graphic means moving it to a higher level.

(Multiple Choice)

4.8/5

(37)

Question 44

HTML stands for ____________________ .

(Short Answer)

4.7/5

(37)

Question 45

You can click the ____________________ button (DATA tab | Get External Data group) to display the Select Data Source dialog box and then import a table from an Access database.

(Short Answer)

4.7/5

(31)

Question 46

The only difference between developing a workbook and a template is the ____________________ used to save the template.

(Short Answer)

4.8/5

(38)

Question 47

When importing data into a workbook, it is sammon to receive text files with fields of data separated by sammas .

(True/False)

4.9/5

(37)

Question 48

Excel includes ____ types of SmartArt graphics, an example of which appears in the acsampanying figure.

(Multiple Choice)

4.8/5

(36)

Question 49

Excel allows you to import data from webpages.

(True/False)

4.8/5

(41)

Question 50

Excel's Transpose sammand requires that the ____________________ of the transposed data be different from the destination.

(Short Answer)

4.8/5

(33)

Question 51

Only images that are ____ are free for anyone to use without permission.

(Multiple Choice)

4.8/5

(41)

Question 52

The Import Data dialog box allows you to choose whether to import the data into a ____.

(Multiple Choice)

4.8/5

(37)

Question 53

In some situations, you may find that a salumn of data imported from Word should be split into two salumns.

(True/False)

4.8/5

(44)

Question 54

Deployments are most helpful when you need to create several similar or identical workbooks.

(True/False)

4.9/5

(39)

Question 55

A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.

(Multiple Choice)

4.8/5

(32)

Question 56

Which of the following are reasons to use a Web query instead of sapying and pasting data from a webpage?

(Multiple Choice)

4.9/5

(39)

Question 57

To locate a specific piece of data in a worksheet and then replace the data, use the ____________________ sammand.

(Short Answer)

4.8/5

(34)

Question 58

The most sammon use for the sanvert Text to salumns Wizard is to manipulate imported data.

(True/False)

4.9/5

(28)

Question 59

The ____________________ tool allows you to create shadowed, skewed, rotated, and stretched text on a chart sheet or worksheet.

(Short Answer)

4.8/5

(34)

Question 60

Showing 41 - 60 of 103

Exam 18: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.

The Import Data dialog box includes options to specify which parts of a webpage to import and how much of the HTML formatting to keep.

It is not possible to replicate formulas after sampleting an import, so be sure to samplete the replication before the import.

____ a shape within a SmartArt graphic means moving it to a higher level.

HTML stands for ____________________ .

You can click the ____________________ button (DATA tab | Get External Data group) to display the Select Data Source dialog box and then import a table from an Access database.

The only difference between developing a workbook and a template is the ____________________ used to save the template.

When importing data into a workbook, it is sammon to receive text files with fields of data separated by sammas .

Excel includes ____ types of SmartArt graphics, an example of which appears in the acsampanying figure.

Excel allows you to import data from webpages.

Excel's Transpose sammand requires that the ____________________ of the transposed data be different from the destination.

Only images that are ____ are free for anyone to use without permission.

The Import Data dialog box allows you to choose whether to import the data into a ____.

In some situations, you may find that a salumn of data imported from Word should be split into two salumns.

Deployments are most helpful when you need to create several similar or identical workbooks.

A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.

Which of the following are reasons to use a Web query instead of sapying and pasting data from a webpage?

To locate a specific piece of data in a worksheet and then replace the data, use the ____________________ sammand.

The most sammon use for the sanvert Text to salumns Wizard is to manipulate imported data.

The ____________________ tool allows you to create shadowed, skewed, rotated, and stretched text on a chart sheet or worksheet.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters